Excel - Automatic data transfer between sheets of the same workbook

Hi colleagues,

I have a problem with a file that would be based on a simple solution and I would like to avoid a macro.
I work on one Deliveries.xlsx file with a "Collective" spread sheet and a dozen others with city names. The point is that I enter daily data on deliveries only in the "Collective" sheet with a table with the necessary headers (Date, Place, Quantity), and the data are automatically saved in the next sheets according to the place of delivery, i.e., e.g. enter in the sheet "Collective" 13/03/2017 | Warsaw | 25t and this data is automatically saved in the same constructed table with 3 headers in the "Warsaw" Sheet, etc. Attached I am sending a simplified file as it would ultimately look like. Is the solution only macros, or is it possible to do it using the function ?? I tried with the Search function, but there were a lot of free fields then because each row is searched for each city, and the correct record is only for one place of delivery ... I will be very grateful for help. Marcin

The easiest way would be to use auxiliary columns (attachment)
PS Formulas are "copyable" vertically and horizontally, so there will be no problem with other cities (in the example).

Hello!

You can also after moving some columns, setting names for ranges and inserting several formulas, do it as in my attachment.

Prot Dost..y.xlsx Download (12.01 kB)

Welcome back.

Cool! Thanks so much for your help. Actually, the Index function here does the job. I will use both ways to the final file.
Thanks again for your help.
Marcin

hondaspike wrote:

Is the solution only macros, or is it possible to do it using the function ?? I tried with the Search function, but there were a lot of free fields at the time because each row is searched for each city, and the correct record is only for one place of delivery ...

You can probably ... ...
Only the patterns will be cosmic and will occupy a large number of side cells. For example, the formula for obtaining the name of a sheet from a notebook saved on the disk is:

= MID (CELL ( "filename", A1) SZUKAJ.TEKST ( "]" CELL ( "filename", A1) 1) 1, LEN (CELL ( "filename", A1)) - SEARCH. TEXT ( "]" CELL ( "filename", A1) 1))

Functions obtaining cell addresses - instead of the values sought in them - will be even more 'aggregated' and long.

It would be better to write your own function that will return addresses to cells, even if text. Then using only 3 worksheet functions - Poem, Addr. Address, Address - it will be possible to compile nice tables with data - and if you deny it, it will even work with one function.