Hi everybody
I have a master file named "Trial.xlsm" and Files as Project01.xlsm, Project02.xlsm ...to 30 in a server...
Trial file have two sheets "Report" and "Data". Project01...30 files having a sheet named "List" and a Chart also.
*Note: Among these files Project01 to 30, any file will be deleted and new file will be added frequently. So that max number of files are 30 but names will vary
I need to combine all the "List" sheets in to "Trial" and should be renamed as Sheet 3 to 32 when opening the file "Trial" everytime (If the data already exists, then skip otherwise copy the data every time)
And I have to name a dynamic range in all the sheets 3 to 32
The range is =OFFSET(Sheet3!$D$13,,,COUNTA(Sheet3!$D$13:$D$499)) upto sheet 32
The name should be like Date03 to Date32...
If you need additional details pls msg me
It would be very much thankful if i complete this task...
I have a master file named "Trial.xlsm" and Files as Project01.xlsm, Project02.xlsm ...to 30 in a server...
Trial file have two sheets "Report" and "Data". Project01...30 files having a sheet named "List" and a Chart also.
*Note: Among these files Project01 to 30, any file will be deleted and new file will be added frequently. So that max number of files are 30 but names will vary
I need to combine all the "List" sheets in to "Trial" and should be renamed as Sheet 3 to 32 when opening the file "Trial" everytime (If the data already exists, then skip otherwise copy the data every time)
And I have to name a dynamic range in all the sheets 3 to 32
The range is =OFFSET(Sheet3!$D$13,,,COUNTA(Sheet3!$D$13:$D$499)) upto sheet 32
The name should be like Date03 to Date32...
If you need additional details pls msg me
It would be very much thankful if i complete this task...