New Sheets obtaining data

  • Thread starter Thread starter Trip Poly
  • Start date Start date
T

Trip Poly

HI
I have a workbook that we keep financial data in. Every day the daily
sales are entered into the current week. I have a template sheet that
I copy every week and have to input the lookup for the previous
week...

example...

In the newly created sheet week22 B:31 has " =week21!H31+B29".....this
just addes some variances that need to be calculated.

Each week I have to type this in for the new sheet adjusting for the
new week.

I was wondering if there was a way to have a template that would do
this but advance the week each time automatically. New week 23 would
be copied and it would know to look at week 22 sheet instead of week
21.

Thanks
C
 
this idea should get you started. It will give you the name of the last
sheet.

Sub lastsheetname()
MsgBox Sheets(Sheets.Count).Name
End Sub
 
Back
Top