function to take info fromseveral worksheets and put into a master

[Yan]

Hi!

I have this Darts Stats sheet that i am doing, the sheet is alwyas the same
except that the name of the sheet changes every week with the actual day
dates.......

And, on my master sheets, i made the 1st value lookup with absolute value
and the onjly thing i need to do when copying the cell down i want the cell
to just change the date automatically......in increment of 7......thank you!

 

[Gord Dibben]

A1 has a date.

In A2 enter =A1 + 7

Copy down.


Gord Dibben MS Excel MVP