Auto updating worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm working on a worksheet that I update daily with new numbers. A new row
daily.
Everytime I add a row I have to go back and update all my trends(formulas)
with correct reference numbers for the new line (such as the reference C7
becomes C8; then next day I fill out the row 9 and C8 becomes C9 and so on).
I know there's a way to program it to auto calculate, but I have no idea how
to do it.

Suggestions
 
You have an active thread at your other post.
I'm working on a worksheet that I update daily with new numbers. A new row
daily.
Everytime I add a row I have to go back and update all my trends(formulas)
with correct reference numbers for the new line (such as the reference C7
becomes C8; then next day I fill out the row 9 and C8 becomes C9 and so on).
I know there's a way to program it to auto calculate, but I have no idea how
to do it.

Suggestions
Click to expand...
 
Hi,

If you are using 2003 you could make your data area into a LIST by choosing
Data, List, Create List.
 
The INDIRECT function may be of help

"Looking for an easier way"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating auto functioning worksheets 16
insert new row and copy formula 1
Need a function 1
Time formulas 15
Timesheet in and out rounding 3
Conditional formula 1
Using NULL in shading cells 1
MAX() and MIN() 4

Back
Top