Copy data from multiples sheets to specific cells in "summary"

**sweetboy02125** · 09-16-2010, 05:43 PM

How can we take data from:
sheet 1 column A and B and put into Summary column F and G
sheet 2 column A and B and put into Summary column H and I
sheet 3 column A and B and put into Summary column J and K
...... so on...

I'm not sure how it's done? Newbie asking.
Thanks

**pgschwarb** · 09-17-2010, 02:53 AM

Hi,

in summary sheet, click on cell F? enter = then move to sheet 1 & click on cell A? then enter.
You may copy the formula into cell G? in summary sheet

**sweetboy02125** · 09-17-2010, 10:05 AM

I would like to use the VBA module (ex: command button...?) instead of using formula....

This is the code:

PHP Code:


Sheets(J).Range("C11:D" & LR).Copy         'pick C11 and D11 for starting row 
Sheets("Summary").Range("F" & Rows.Count).End(xlUp).Offset(1, 0).PasteSpecial xlPasteValues