T
TomQ
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.
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.