Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula Copying in workbook
I have a workbook with 3 pages. Each page has stocks listed from different accounts. One has 5, one has 3 and one has 1. I copy the information and formulas down for each day so i can put the daily prices in them. This works well but i added another sheet that takes the totals for the day and addes them up. An example is "=SUM(Sheet1!F4192+sheet2!F5585+sheet3!F1353)" and this works good also but when i copy the formula down to the next line the numbers change to "=SUM(Sheet1!F4193+sheet2!F5586+sheet3!F1354)" instead of what i want . I need them to change in different amounts. The next line needs to say "=SUM(Sheet1!F4197+sheet2!F5592+sheet3!F1355)" I don't know if there is an easy way to do this or even if there is a way to do it. Any help would be very much appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
problem copying formula from one workbook to another | Excel Discussion (Misc queries) | |||
formula for copying values from one workbook to another | Excel Worksheet Functions | |||
Copying formula to another workbook | Excel Worksheet Functions | |||
copying cell formula from one workbook to another | Excel Programming | |||
Copying a formula to new workbook | Excel Discussion (Misc queries) |