extract the data of last 15days fom current day.

[reachmanoj27]

hi every one i have file which has data of last 30 days but it have to extract data daily of last 15 days from current day. now i am manually putting the dates of last 15 days and using vlook up to match but i guess there is another way through VBA . the data is in column A. Any one please help. thank you.

 

[123rickfear]

could you not use vlookups and today?

=VLOOKUP(TODAY(),A:B,2,0)
=VLOOKUP(TODAY()-1,A:B,2,0)
=VLOOKUP(TODAY()-2,A:B,2,0)

all the way to =VLOOKUP(TODAY()-14,A:B,2,0)

then you wouldn't need to input new formula every day

Rick