Thread: how do I reference a cell in a previous sheet not by name, by orde
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
I.P.Phrielie I.P.Phrielie is offline
external usenet poster
  
Posts: 3
Default how do I reference a cell in a previous sheet not by name, by orde
I have an inventory of stock with formulae to calculate
"StartOfDay + Deliveries - Sales = EndOfDay"
I'm trying to write or record a macro to create a new worksheet and copy
EndOfDay from the previous days worksheet into the StartOfDay of the new
worksheet.
When I record the macro it records the actual name of the sheet ie
"Sheet4!E2" which does not give the incremental effect needed. Something like
"Sheets.Previous!E2" is needed

Cheers!
Reply With QuoteReply With Quote