I tried to do this for several days in row and i had a little to zero results.
I attached the file.
Firstly i need to copy the table from Sheet "table" ( i tried to make it standard.) and paste it in a new generate sheet. this sheet should be renamed after the cell J449 from the "Baza"
in this new sheet i must complete all the info as in the sheet Demo. table .
In the end i want to delete the row 449 and take the next one. into a loop
i thought on the following for the start:
Sheets.Add After:=ActiveSheet Range("A1:G8").Select Selection.Copy ActiveSheet.Next.Select ActiveSheet.Paste
and then copy paste in the new tabel
and to make an if with an offset into the suplier
Can you help me with some ideas to start .
i would really need it and appreciate i.
i tried with record macro too but it crashed big time
I thought the following: