Hi
how do i copy in sheet1 rows,cell A1 data of Sheet2 to Sheet 4
and also copy down in row of sheet 1 ,sum of data in column B of sheet2 ,sheet3,sheet4
anything like absolute reference where sheet name change but cell reference don't change
please check attached file
Maybe you are looking for a so called 3D reference??
For example in Sheet1!B6:
Formula:
Please Login or Register to view this content.
This yields 667 - the sum of B2:B6 in sheets 2,3,4
Geoff
Did I help significantly? If you wish, click on * Add Reputation to say thanks.
If your problem has been resolved please select ?Solved? from the Thread Tools menu
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks