[Solved] Data from cell to cell (different dates)

[misevo@gmail.com]

Dear Calc specialists. Sorry my English. As complete Calc and exel novice i strugle my head with heavier then =SUM or =COUNT functions.
Been reading yours and others help forum and tutorials for couple of days and found out that asking directly is the best way to find the solution.
Witch is, i think and hope, as simple as can be for to me to undertand and maybe use in similar tasks.

Problem I have (i include a working Sheet):
- Sheet can be called "januar 2022 - Tadej", there will be 11 more for this name and 20 (persons) x 12 (months) for others
- I manualy copy left data (A1:F41) - every month separatly from another Data sheet wich is on Cloud and used by others
- I need to automaticly fill the summed cells in the Formular (every month new one) - that will be manualy copied to empty sheet and Printed for archive.
- My problem is with Values represented as name (Colum C) and copying theirs values to the cells in Formular when there are more then 1 value (coludnt use Vlookup). The represented Value is named 201 - ... and is always with different dates, mostly same number but can alsow differ. I colored the Cells in working Left table and position in the Formular to be placed in. Position in working left table is alway different (cant auto row copy).

Please help with simplest solution there can be. Was trying with different Array formulas Index and Iferror but cant wrap a head around them...

[FJCC]

Here is what I understand that you want. Whenever "201 - Dvig gotovine na banki" appears in column C, you want the date from column A and the amount from column E to appear in row 17. So P17 should show 150, T17 should show 2022-02-10, X17 should show 200 and AB17 should show 2022-02-27. There are two more cells for amounts and two more for dates if there were more "201 - Dvig gotovine na banki" transactions. Is that right?

[misevo@gmail.com]

Thank you for switf answer. Yes, thats what I wolud like to see. There are more empty cells mentioned becouse 201 can hapen up to 4 ot 5 times a month. The exact translation of 201 is "cash withdrawl". Other numbers mostly different shoping recives (clothes, sweets, hobby, cigarets...).
I work in Special care facility for mentaly disabled, they are preaty much self sufficient and go to shops and buy their things. And I need to keep their monthly finance for supervision.

[FJCC]

The attached file shows one way to get the numbers into the cells in row 17. I put some functions in BD1:BG1 to help with the search for "201 - Dvig gotovine na banki". I also had to edit the text in AW1, which was not identical to the text in column C. The dash in AW1 was a different character than the dash in column C. That is an example of how fragile this calculation is. Do you have to use this layout? It would be better to put all of the data, every month and every person, on one sheet and use filters and pivot tables to view the data.

[misevo@gmail.com]

This is working, i tried ading aditional data in left table and the cell to cell data was shown as a charm.
I see i need to be much more carefule.
The data on the left is from a continues table on Cloud for aevery persn for every month, so it is populated with late brougt recives, next month bank transfers nad income and by aditional staff. It would stay as it is and be copied to this sheet for every month, for retrieving data to Formular.
Frormular is on another file, every sheet for every month and had to bee populated "by hand". I am in proces of joining them and neede your help.
Could bee in some time it could be joined, but i need to "clean" it as it was builded with different aproaches is not all the same (some aditional data for internal use not needed in this Formular).
Thanke you verry much !

[misevo@gmail.com]

This is now work in progres, starting to populate other cells and pages.
Thenk you again and Mary Christmas !

It crashed first time i tried to copy page 1 with all the formulas to new page 2, after restart worked ok.

[misevo@gmail.com]

Hello again.

Working and finding some errors in progres.
Uper Formular works ok, the one on the bottom "not to be printed" (after page brake) makes me headeacke.
The formulas for the upper cell transfer you provided, are making some strange results after i copy and populate them. I am probably making some grand mistakes ?
If please can be checked what I am doing wrong.
Attaching file.

[misevo@gmail.com]

To answer my selfe, i tried some options and foun out the row number MUST be exact as per text string. Will tray to add another column for numbers (102, 103,...) to avoid mistipings froum copyed Cloud cells and copling them with "=SUMPRODUCT(--(ISNUMBER(FIND(BF49;C1:C41))))"

[Villeroy]

I removed all the useless formatting and all data except input data.
I added a header row to the source data and a most simple pivot table.

Data_sheet_Tadej_januar_PV.ods[/attachment This is how a pivot table works with a bigger record set: [attachment=0]Pivot_Mont_Person_Category.ods

The source table has all data from all dates. Source data are NOT split into separate sheets for each month.
A pivot does not depend on any sort order. My source table is not sorted in any way. In fact I sorted the rows in random order.
Simply insert a new row anywhere in the source table before adding a new record. RIght-click>Refresh refreshes the pivot table.