Hi..I have a table like below
Date P1 P2 P3 P4
4/24/2010 22 33 44 55
Suppose i have these values P1,P2,P3,P4 obtained by VLOOKUP of The data from another table.Also this another table(Table1) is refreshed daily,so P1,P2,P3,P4 keep changing daily.However,i need to keep track of the changes and store each days data in another table.
For example,if today is 25th then the above table changes to
Date P1 P2 P3 P4
4/25/2010 42 3 54 89
but i need to have a central table like the below(Table3) where each days values are copied.so that i form a repository(i am doing this because when i said another table(Table1it is refreshed daily and is a pivot table so cannot store values on a daily basis,)
Table 3
Date P1 P2 P3 P4
4/21 12 13 9 76
4/22 33 43 62 12
4/23 21 32 43 54
4/24 22 33 44 55
4/25 42 3 54 89
Can i write a macro or is there an easier way to do this in excel..Please help...
Please look at the uploaded file for details on the problem...
Bookmarks