Relative references to Excel Sheets

  [DELETED] 11:13 31 Oct 2003
Locked

When using Excel how do I make a reference to a previous sheet relative?
I wish to carry forward a number of balances from sheet to sheet but can only do so by using an absolute reference to the preceding sheet. This tends to be very laborious. Thanks, Oliver.

  [DELETED] 18:33 31 Oct 2003

You can't.

Unless anyone knows differently!

  [DELETED] 19:10 31 Oct 2003

It is possible using VBA click here

If you need help with using these, please shout.

  [DELETED] 22:16 31 Oct 2003

Thanks VoG. I will have a go at using (or trying to understand) the VBA instructions you sent. Many thanks. However if I get stuck I will shout for help (very likely)
Grogan

  [DELETED] 01:37 01 Nov 2003

Grogan I just copy and paste the last line of 1 tax year sheet to the top line of the new tax year sheet.:-)

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Amazon Prime Day 2018: Best Deals & Launches

The humble pint glass is redesigned from bottoms up by design legend Sir Kenneth Grange

The best Amazon Prime Day Apple deals 2018

Quel est le meilleur antivirus pour Windows ?