Hi guys,
Although, it seems that this question has been asked many times, still I can't make it work.
So, here is my case:
I have a file that has 3 worksheets, named Master_Sheet, Monthly_Report and the Data1. Now, the name of the Data1 sheet changes dynamically and from that sheet others are created (again with the dynamic name feature). These "DataSheets" have D4, D8, E3, E7, J41 and K42 the data I'm interested to. These datasheets are deleted after 6 months and others new created.
In my Master_Sheet I have a dynamic list of the worksheet names in column E (if that's helpful). So, what I'm trying to achieve here is to keep the record of the aforementioned cell's values by pastespecial in rows at the Monthly_Record sheet
Any ideas guys for a VBA code?
Or maybe, I can create the table with the reference I want and then have a code that will copy and pastespecial (overwrite) everything at that Monthly_Sheet everytime I close the file. Any ideas?
Thanks in advance.
Although, it seems that this question has been asked many times, still I can't make it work.
So, here is my case:
I have a file that has 3 worksheets, named Master_Sheet, Monthly_Report and the Data1. Now, the name of the Data1 sheet changes dynamically and from that sheet others are created (again with the dynamic name feature). These "DataSheets" have D4, D8, E3, E7, J41 and K42 the data I'm interested to. These datasheets are deleted after 6 months and others new created.
In my Master_Sheet I have a dynamic list of the worksheet names in column E (if that's helpful). So, what I'm trying to achieve here is to keep the record of the aforementioned cell's values by pastespecial in rows at the Monthly_Record sheet
i.e. From Data1:D4 -> 5E, D8 -> 5F, E3 -> 5G, E7 -> 5H, J41 -> 5I and K42 -> 5K
From Data2:D4 -> 6E, D8 -> 6F, E3 -> 6G, E7 -> 6H, J41 -> 6I and K42 -> 6K
when new data is added to sheets added to the workbook or at least before deleted.From Data2:D4 -> 6E, D8 -> 6F, E3 -> 6G, E7 -> 6H, J41 -> 6I and K42 -> 6K
Any ideas guys for a VBA code?
Or maybe, I can create the table with the reference I want and then have a code that will copy and pastespecial (overwrite) everything at that Monthly_Sheet everytime I close the file. Any ideas?
Thanks in advance.
Last edited: