| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function to take info fromseveral worksheets and put into a master
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
function to take info fromseveral worksheets and put into a master
A1 has a date.
In A2 enter =A1 + 7 Copy down. Gord Dibben MS Excel MVP On Sat, 12 Sep 2009 17:22:01 -0700, Yan wrote: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FUNCTION that reads 7 worksheets and brings info into another work | Excel Worksheet Functions | |||
| Want to move several cells info to next available row on master sh | Excel Discussion (Misc queries) | |||
| Getting info from individual sheets into master sheet | Excel Worksheet Functions | |||
| Getting info from individual sheets into master sheet | Excel Discussion (Misc queries) | |||
| Pulling info from a master over to other worksheets. | Excel Discussion (Misc queries) | |||
Hybrid Mode
