Anyone know if 'PrevSheet' or similar can be used in a formula?

Question

Level 1

10 points

Anyone know if 'PrevSheet' or similar can be used in a formula?

Hi,

New to numbers and spreadsheets in general.

I did dabble a few years back in Excel for home use, i.e. creating a monthly budget and spending file, and wish to do the same in Numbers.

I've created a master sheet which ideally I will use for each new month, however to allow the new sheet to pull in the rolling balance from the previous month I need to reference the same field on the previous sheet. I know this can be done in a formula if I actually name the sheet to be referenced, but I would have to edit the formula every time I created a new sheet.

I know in Excel you used to be able to use 'PrevSheet' or similar, to simply reference a particular cell on the sheet before, but I can't seem to get that to work in Numbers or find any reference to it.

Any help appreciated.

Mac OS X (10.4.10)

Posted on Aug 22, 2007 8:55 AM

Reply

Answer 1

KOENIG Yvan

Level 8

41,819 points

Aug 22, 2007 10:06 AM in response to Ken Clark

Hello

As far as I know, this feature is not available in Numbers.

I tried to define a sheet name from a string stored in a cell but can't get a working soluce.

Yvan KOENIG (from FRANCE mercredi 22 août 2007 19:05:50)

Reply

Answer 2

WWJD

Level 6

15,830 points

Aug 22, 2007 2:27 PM in response to Ken Clark

You can do this in numbers as long as the sheet is in the same file. Start your equation ( = ) then select the cell in the previous sheet.

Regards,

Reply

Answer 3

WWJD

Level 6

15,830 points

Aug 22, 2007 2:31 PM in response to Ken Clark

Here's a simple example. Sheet 27 links to sheet 21.

Regards,

Reply

Answer 4

Ken Clark Author

Level 1

10 points

Aug 22, 2007 4:37 PM in response to WWJD

WWJD,

Thanks for the advice, but that's not quite what I was after, perhaps I didn't explain myself too well...

I understand that you can do what you've suggested, but I would like the formula you've exampled to simply look at whichever sheet was before it, not by name, i.e. 'Sheet 26' before 'Sheet 27', but just to look at the same cell in the sheet before.

I did do this once many moons back in Excel the last time I played with spreadsheets, and would have done, '=PrevSheet (C4)' for example, therefore not having to change the formula on every sheet.

Hope that's a little more clearer.

Thanks again.

Reply

Answer 5

WWJD

Level 6

15,830 points

Aug 22, 2007 6:04 PM in response to Ken Clark

Do you think someone had written a little Macro/VBA for this function? Excel 2000 does not have it neither does Excel 2004 for the Mac. I'll check Excel XP and 2007 tomorrow.

Regards,

Reply