Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy and paste formulas that apply to multiple worksheets
i have 7 work sheets that are all have information that is going on a master
sheet. i have a the equation written that adds the sum of say cell A1 on all 7 sheets. but when i copy and paste it it doesn't update the row number (i.e. instead of being the sum of all A2, it just pastes all A1 info). How do i fix this!!?? Help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy and paste formulas that apply to multiple worksheets
Hi,
I have tried your problem and do not get it. I guess that there is a problem in the formula. I have tried =SUM(Sheet1:Sheet7!A1) this copies correctly If i try =SUM(Sheet1:Sheet7!$A$1) the problem occurs Hoop this helps, Executor |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy and paste formulas that apply to multiple worksheets
ok, here is the idea: sheet1boxA1+sheet2boxA1+sheet3boxA1+etc. then taking
that formula and moving it forward throughout the sheet. i.e- sheet1boxA2+sheet2boxA2+sheet3boxA2 and so on and so forth, all going to the master worksheet. does that help ? "Executor" wrote: Hi, I have tried your problem and do not get it. I guess that there is a problem in the formula. I have tried =SUM(Sheet1:Sheet7!A1) this copies correctly If i try =SUM(Sheet1:Sheet7!$A$1) the problem occurs Hoop this helps, Executor |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy & paste macro for multiple worksheets | Excel Discussion (Misc queries) | |||
Copy range from one worksheet and paste to multiple worksheets | Excel Discussion (Misc queries) | |||
multiple selection copy & paste across multi-worksheets | Excel Discussion (Misc queries) | |||
copy multiple worksheets of a workbook, and paste onto a Word document ( either create new doc file or paste onto an existing file.) I need this done by VBA, Excel Macro | Excel Programming | |||
apply cell names to formulas in multiple worksheets | Excel Worksheet Functions |