I have a spreadsheet containing production information. I want to be
able to search by date (can do this using VLOOKUP), and extract
information from the same row as that date.
However, I also want to be able to extract the previous 10 entries as
well, for comparison purposes.
ie I enter a date and find that it is in B95, and the piece of info I
want is in C95. I also want to be able to pull out C86-94 and place it
all into a new sheet.
I'd be grateful for any help offered. Thanks
--
dudara
------------------------------------------------------------------------
dudara's Profile:
http://www.excelforum.com/member.php...o&userid=37475
View this thread:
http://www.excelforum.com/showthread...hreadid=571357