Hi All,
I need some help getting a macro to run.
I have a number of workbooks that I need to copy data from and place it in one workbook. The data in each source workbook is contained in one worksheet, but the size of the range (including starting cell) may be different each time. I want this data to be pasted into a new worksheet in the destination workbook for each source workbook. Ideally I'd like these not to be created each time as I will be using these sheets to generate pivot data and I'm not sure how the table/formula will react if the sheets are deleted/created each time the data is updated.
I have gotten to a point where the macro will run and copy one or two worksheets worth of data in but breaks down giving a 'Run-time error '7': Out of memory' message. I assume this is to do with too much data being held on the clipboard, or the size of my copy/pastes due to the dynamic ranges.
I'd be very grateful if you would have a look at the vba I've got so far. I took this from an MSDN page I think (sorry, I lost the source) and have butchered it from there, so apologies if it's horrific, I am very much a novice at this. If anyone can suggest an alternative way to write this, I'd be very happy to see it.
Bookmarks