Relative references to Excel Sheets

  Grogan 11:13 31 Oct 03
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.

  VoG II 18:33 31 Oct 03

You can't.

Unless anyone knows differently!

  VoG II 19:10 31 Oct 03

It is possible using VBA click here

If you need help with using these, please shout.

  Grogan 22:16 31 Oct 03

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

  petersmyth1 01:37 01 Nov 03

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.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…