I have been trying to find code for this problem for some time and have trawled the posts to no avail - hope someone can help out there.
I have four workbooks in the same directory - all have the same structure including sheet names, just different data.
I need to regularly Copy PasteSpecial Values with Formats from a specific sheet (DataSheetName) in each workbook (ie four sheets with this name over four files) and paste the results into the master file in a single sheet with the date of this operation going into the sheet name.
The rows of data in each DataSheetName will vary between each file and from time to time. I want however to copy each successive sets of data rows below the data rows copied from the other file.
As the data in each DataSheetName is produced changes with time and data entered between updates the DataSheetName needs to be recalculated before copying.
Can anyone help me here? Thanks to ajm for trying.
I have four workbooks in the same directory - all have the same structure including sheet names, just different data.
I need to regularly Copy PasteSpecial Values with Formats from a specific sheet (DataSheetName) in each workbook (ie four sheets with this name over four files) and paste the results into the master file in a single sheet with the date of this operation going into the sheet name.
The rows of data in each DataSheetName will vary between each file and from time to time. I want however to copy each successive sets of data rows below the data rows copied from the other file.
As the data in each DataSheetName is produced changes with time and data entered between updates the DataSheetName needs to be recalculated before copying.
Can anyone help me here? Thanks to ajm for trying.