Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a formula in spreadsheet to pull data from a pivot table. Part of the
formula is a Date function. I would like to copy this formula down the spreadsheet with the date advancing to the next day, but it only directly copies the fomula. How can I get this to work without going into each cell and changeing the date? =GETPIVOTDATA("Result",Pivot!$A$4,"Result","In","L ocation","Finished Product","Line",11,"Sample type2","0 day","MFG",DATE(2010,1,1)) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What funtion to use? | New Users to Excel | |||
How create my own Funtion | Excel Worksheet Functions | |||
If Funtion | Excel Worksheet Functions | |||
If funtion help | New Users to Excel | |||
IF funtion | Excel Discussion (Misc queries) |