I need an Excel VBA script written to append data to a master worksheet.
I have a new & empty workbook [login to view URL]
I have multiple files, all of which contain 1 worksheet.
I need to copy specific data from the worksheet and paste it into the master worksheet.
The range of data may vary. The range of data to be copied usually starts at cell A6 and ends P##. There is always a blank row following the last row of data to be copied. So you’ll need to dynamically find the data range.
It would be nice if I could select multiple files at a time, or at least point to a file directory and have the script process all files that exist.
Happy [login to view URL] is your day? I have full experience in Excel Excel VBA Excel Macros . I can start just now and can do it perfectly. I hope to discuss more via chatting.Thanks.