How bring over result to sheet 2
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.. :confused: But i don't find a simple trick to do it ...(excel 2000) Greetz. -- Jack ----------------------------------------------------------------------- Jacko's Profile: http://www.excelforum.com/member.php...fo&userid=2876 View this thread: http://www.excelforum.com/showthread.php?threadid=48463 |
How bring over result to sheet 2
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 -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=484633 |
How bring over result to sheet 2
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 HIS "Jacko" wrote in message ... Hi, In sheet 1 i have sum calculations, and the result are in list A1 till A50 Now after every new calculation they change and i want them to bring over to sheet 2 in (a1 till a50) and from there i can make a other list with the resuts.. :confused: But i don't find a simple trick to do it ...(excel 2000) Greetz.. -- Jacko ------------------------------------------------------------------------ Jacko's Profile: http://www.excelforum.com/member.php...o&userid=28762 View this thread: http://www.excelforum.com/showthread...hreadid=484633 |
All times are GMT +1. The time now is 03:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com