angeloudaki
New Member
- Joined
- Jul 7, 2015
- Messages
- 46
I have multiple workbooks and want to consolidate them into one, maintaining the individual worksheets. There are ~2-5 sheets in each workbook depending on reports received. Each tab (worsksheet) is unique in name. I can easily do this by opening each workbook but I'd like to do this for different reports too so I don't want to be opening 100+ workbooks! There are threads about this topic but I can't find one which lends itself to this - feels like a needle in a haystack. If a thread does exist, please do point me in the direction!
I then need to be able to pull across all instances of a set of values. For example, delivery expectations - I need to find all instances of the expected deliveries promised so we can see just how angry we need to be... Grrr.
I then need to be able to pull across all instances of a set of values. For example, delivery expectations - I need to find all instances of the expected deliveries promised so we can see just how angry we need to be... Grrr.