Copy data from field on next worksheet

  • Thread starter Thread starter Cate
  • Start date Start date
C

Cate

I have two worksheets in my workbook. Worksheet #1 has
cells that contains calculated amounts. Worksheet #2 is a
summary worksheet into which I simply want to copy cell
values from Worksheet #1.

The worksheets and cells are not "named."

How do I do this?

Thanks - Cate
 
Cate, do it like this (for a single cell):

1-In the destination cell on Worksheet #2, type =
2-Switch to Worksheet #1 and click the cell with the calculated amount
3-Press Enter.

Or like this (for a range of cells):

1-Select the cells on Worksheet #1 that you want to copy
2-Edit > Copy
3-Switch to Worksheet #2 and select a target cell
4-Edit > Paste Special > Paste Link
 
This will copy the entire worksheet(1) to Worksheet(2):

Worksheets(1).activate

Cells.Select ' you can change the selection up here
'Range("A1:G5").Select

Selection.Copy

Worksheets(2).activate

Range("A1").Select

Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone
SkipBlanks _
:=False, Transpose:=False



SDNICSM:( ;) :mad
 
Back
Top