run macro on next row without changing macro.

[Saoirse]

Have a macro with two formulas, a count if and a countifs pulling information from another sheet. But each time I try to run in on sheet B it changes the formulas within the macro. I am very very new to macros and am a beginner trying to create a tracker for my boss and could use any advice I can get to make this awesome.

 

[Saurabhj]

Hi, change it to now-1

Sheets("E923928").Range("A" & nextRow) = Format(Now-1, "MM-DD-YYYY")

 

[Saoirse]

It works!!! AHH yes!! Thank you so much!

 

[Saurabhj]

Great. Thanks for the feedback.