Pasting data from other user defined workbook difficulties

Hello all,

I have been working on this code to
1. let user pick file
2. copy all cells that contain data on sheet 1, 2, 3, 4 and over 30
3. paste into first blank row of source workbook on Sheet 4

For some reason this seems to only paste one cell into "A" on sheet 4 on the first blank row of source workbook. I cant figure out how to make it copy all data (cells that contain data) from user defined workbook (wb2, with multiple sheets) and paste into source workbook (wb1) on sheet 4 on first blank row. Any help is greatly appreciated.

Please Login or Register  to view this content.

Jeez, that works really really well. Thank you so much for the help.

Originally Posted by Mumps1

The macro assumes that there is data in column A of all the worksheets.

Question, (apologies if its already been answered, I cannot seem to find it for the change to usedrange) what if the only place that has constant data is "C". A & B may not have data but are still part of the row?

I apologize for that. I did not know the two forums were linked. That is now known .

It seems that code is not also copying and pasting rows based on column "C" instead of "A". I've spent alot of time with it.. but I seem to have issues in getting the looping to work with copying and pasting between worksheets/ workbooks like that. I think it may be something to do with .UsedRange value? Ill keep working on it anyway and really thank you so much for your time... The code above simplified the process and has been a great base for me to play with and try to get it working as im learning all this.

Understood, this makes sense. Thank you.