Dear All, I have a problem with two excel sheets, which I need to synchronize. For example: Sheet1 and Sheet2
I have a table in Sheet1 from row 72, which is automatically get an information from another sheet(call Products). It has a VBA code which take the rows with product details with a specific logic. (Sometimes the table in Sheet1 has 1 row, sometimes has 10 rows). I need to synchronize that specific table with the Sheet2, which will be the main one and we can add all the information from Sheet1 everytime we include information from "Product" sheet.
Could somebody helped me with it? I guess it should be some VBA code, but I'm really new with it and couldn't find a way how to do it.
Thank you in advance!
I have a table in Sheet1 from row 72, which is automatically get an information from another sheet(call Products). It has a VBA code which take the rows with product details with a specific logic. (Sometimes the table in Sheet1 has 1 row, sometimes has 10 rows). I need to synchronize that specific table with the Sheet2, which will be the main one and we can add all the information from Sheet1 everytime we include information from "Product" sheet.
Could somebody helped me with it? I guess it should be some VBA code, but I'm really new with it and couldn't find a way how to do it.
Thank you in advance!
