excel figure carry over from sheet to sheet

  User-67C15525-3DBE-41EF-B48A981FE25748D2 19:52 13 Aug 2006
Locked

at work i'm looking to create a weekly stats sheet with each sheet tab representing a week. i'm looking to have 52 sheets.
each week will have a carry over figure that i want to automatically populate into the next week.

e.g. cell a1 from sheet 2 is copied from cell b1 in sheet 1, cell a1 from sheet 3 is copied from cell b1 in sheet 2.

i can of course repeat the reference to the previous sheet manually but i was wondering if there was a quick way of setting up the sheets so that the reference to the previous sheet and specific cell is done automatically?

is there also a quick way to set up all 52 sheets rather than copy 51 times?

tia.

  VoG II 20:48 13 Aug 2006

Yes it is possible using a macro. Is it just those cells that need to be copied. What are the sheet names? Do you need to copy the FORMULA or the VALUE in A2?

In other words perfectly doable but more info needed.

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

Elsewhere on IDG sites

OnePlus 5 review

See the work of famous artists playing with toys

iPad Pro 10.5in (2017) review

Comment faire une capture d’écran sur un Mac ?