Forum Discussion

Copper Contributor

Jan 09, 2018

Summarize data from multiple tabs on another workbook

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 ...

Macros & VBA

Need Help

Kavitha Fernando

Copper Contributor

Jan 10, 2018

Hi Jason,

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.

I hope my issue is easy to undersand.