ABsolute Refereneces

  • Thread starter Thread starter Flipper
  • Start date Start date
F

Flipper

Is it possible to globally update absolute references for an entire
workshett? I have formulas that are linked to other worksheets. For
example. Each month I prepare a summary of investments. They are linked to
another worksheet so when I need to update the worksheet for the next month,
the link needs to change to the next cell down. Is there a way to do this
without manually updating the worksheet?
Thanks
 
Is it possible to globally update absolute references for an entire
workshett? I have formulas that are linked to other worksheets. For
example. Each month I prepare a summary of investments. They are linked to
another worksheet so when I need to update the worksheet for the next month,
the link needs to change to the next cell down. Is there a way to do this
without manually updating the worksheet?
Thanks
Click to expand...

Please repost your question in an Excel group; this newsgroup is for a
different program, Microsoft Access. The webpage can be confusing and may have
misled you.
 

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

Excel Count If Formula Question 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Excel Vba to change displayed year automatically. 14
trying to create a link to a link in Excel (2007) 3
Excel VBA 1
Excel Excel Formula OFFSET maybe? 1
Excel Referencing one cell from a different worksheet and slide in powerpoint 0

Back
Top