I have a workbook that is updated and sent to me every day by another company. This workbook contains a new tab that is created for each day with the date as the worksheet name. Each worksheet has columns A through H and an unspecified number of rows (usually not more than 10). I would like to create another workbook that takes this information and puts it all on one worksheet with the date (worksheet name) in the first or last column of each row.
I have a similar situation but different question.
Can anyone help me, as we can do this with vlookup but it can only lookup one worksheet and not entire workbook.
I have a file (named after the month). This workbook, has worksheets named after the 'dates' in the month.
I want to lookup/ find an order# (from different xls file) in the 'month' workbook (all the sheets in the other workbook) and the result I need it to tell me is the date provided in the column within that worksheet.
So, e.g if order # 342 is found in sheet/ tab '21' and '31', I want it to give me this result in the 'cell', where i have list of order numbers.
If I have 500 order #, i want to know in which date these order nos are found in the another file/ workbook.