Displaying the same information every week in different cells and preserving data.

M

meghantrus

Each column displays data in a cell that was pulled from a pivot table
at the end of the week.(friday) I want to preserve the data in cell
B43 that I collect for mar.2,2007. On Mar. 9, 2007, the same data
will be pulled and placed in C43.
I have tried two different functions, but both do not preserve the
data.
Either nothing is displayed, or it is overwritten with the current
date's value.

=SUMIF(A1,">="&DATE(2007,3,2),Summary!E14) ...this one will overwrite
with the value I obtain from
Summary!E14 on Mar. 9. If I remove the > sign, "0" is displayed after
3/2/2007.

=IF(TODAY()=DATE(2007,3,2),GETPIVOTDATA("mnemonic",Summary!$A
$2,"status","NOK"),"")...this one will not display anything for a date
after 3/2/2007

Any ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Number of hrs worked in a week, based on dates in a different column 1
Reference constant cells in different files from a master workbook 1
complicated drop down menu question 1
Finding the date using the number of the week in a year 2
Why can't I just use the = sign in a function, and not use >=? 8
formula patterns with a gap of two 0
Pasting to Cells to the Right. 2
Use cell_ref in place of an item in get pivot data function 2

Top