1 Attachment(s)
Collating information available on excel sheets
Hello sir,
I have some excel sheets (15 to 30 nos) containing identical data on certain x number of items; but relates to different dates. Now I need to collate the data pertaining to particular one item(among x number of items)(which is available in 15 to 30 worksheets)and consolidate/group all of them into a single excel sheet.The result must appear like this:
The resultant excel sheet must have all the rows relating to the selected item extracted from all the sheets and presented chronologically in a single sheet.
I have also attached a simpler sample worksheet on the above model with expected answer sheet affixed on a worksheet
Thanks in Advance
Vks64