PDA

View Full Version : Copy ranges from different worksheet to new worksheet



Riaaz66
10-14-2010, 02:55 AM
Hi,

I want to copy two ranges from 2 different worksheets to another sheet.
Each range is in the same workbook but on different worksheets.
The second range should be pasted on the pasted on the next empty row of range 1. There are always 8 columns, but the number of rows may vary on daily base.

For example:
Sheet 1 has a range of 8 columns wide and 65 rows long
Sheet 2 has a range of 8 columns wide and 78 rows long
Now I want to copy both ranges to sheet 3
The range of sheet 2 should start at row 66.

How to code the follwing:
- Determine and select range of worksheet 1 and copy to worksheet 3
- Determine and select range of worksheet 2 and copy to last empty row in sheet 3 and paste it there.

I hope you can help me,

Regards,

RM

CharlesH
10-14-2010, 11:53 AM
Hi,

A copy of your workbook would help.