Forum Discussion

julie vandermeulen

Copper Contributor

Apr 19, 2018

Macro

I want to create a macro that creates a new sheet and pulls from the most recent sheet I was working on. So I have a worksheet named 5/3/2018 I want to use as a template to create a new sheet nam...

julie vandermeulen

Copper Contributor

This helps a lot!! Thanks
My sheets are actually named 5-3-2018, 5-10-2018, 5-17-2018, etc. May I use that in the macro?

Haytham Amairah

Silver Contributor

Apr 24, 2018

Hi Julie,

In this case, all you have to do is:

Replace this line:

ThisWorkbook.ActiveSheet.Name = Month(nextDate) & " " & Day(nextDate) & " " & Year(nextDate)

With this:

ThisWorkbook.ActiveSheet.Name = Month(nextDate) & "-" & Day(nextDate) & "-" & Year(nextDate)

I hope this helps you

Haytham

julie vandermeulen
Copper Contributor
Apr 24, 2018
Yeah I did that.

Now the issue I'm having is that the formulas aren't updating. For example the formulas in Column A, B, and D pull from 4-19-2018 into 4-26-2018. And in 5-3-2018 they pull from 4-26-2018, etc.
Is there a way to update the formulas so it automatically pulls from the previous tab without having to make those adjustments each time?
- Haytham Amairah
  Silver Contributor
  Apr 25, 2018
  Hi Julie,
  
  This will pull/copy all formulas from the previous tab as it is.
  What type of adjustment would you like to make on formulas?
  - julie vandermeulen
    Copper Contributor
    Apr 25, 2018
    It does pull the formulas but it doesn't change the formulas. In Columns A, B, and D of 5-3-2018 sheet the formula is ='4-19-18'!K10 but I want it to update automatically and be ='4-26-2018!K10. Then the following week in sheet 5-10-2018 the formulas should update to be ='5-3-2018'!K10. Everything else updated and pulled correctly, just not the formulas in these columns. As far as I can tell so far.

Share

Resources