How bring over result to sheet 2

[Jacko]

Hi,

In sheet 1 i have sum calculations, and the result are in list A1 til
A50

Now after every new calculation they change and i want them to brin
over to sheet 2 in (a1 till a50) and from there i can make a other lis
with the resuts..

But i don't find a simple trick to do it ...(excel 2000)
Greetz.

 

[Leith Ross]

Hello Jacko,

Link the cells on Sheet2 A1:A50 to the same cells on Sheet1.

LINKING CELLS USING A FORMULA:

On Sheet2
A1 =Sheet1!A1
A2 =Sheet1!A2
A3 =Sheet1!A3
etc.

At this point drag fill the cells to A50.

Sincerely,
Leith Ross

 

[Nick Hodge]

Jacko

How about

Sub CopyValToSheet2()
Worksheets("Sheet1").Range("A1:A50").Copy
Worksheets("Sheet2").Range("A1:A50").PasteSpecial Paste:=xlValues
Application.CutCopyMode = False
End Sub


--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)