Copy and paste dynamic range from two worksheets into one

Hi All,

I have two separate worksheets that have a dynmic range, and need to colsolidate them into one worksheet. What I wanted to do was to take the data from the worksheet PCR Summary, which has a fixed range of columns A:E, and rows starting at row 6 to ???, and the data from the worksheet Parts Summary, which has a fixed range of A:F, and rows starting at row 6 to ???. I wanted to find the valid data range in both of these ranges, and put them in the same worksheet called PCR Parts Summary, where the data for the PCR Summary is pasted in to the row starting at A4, and the data from the Parts Summary is pasted starting two rows below the last used row from the PCR Summary data.
Thanks in advance, I'm relatively new to VBA and this one is beyond me!

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

Hi, Try this:-

Please Login or Register  to view this content.

Regards Mick

Cross posted here: http://www.mrexcel.com/forum/showthread.php?t=459489

wpryan please read this: http://www.excelguru.ca/node/7

Dom