Hi Guys,
Monthly, I receive a file with multiple sheets on it (but with the same sort and format).
This sheets contains expenses charged into multiple WBS (Cost Centres).
I'm working on a project, who has specifics WBS (listed in a sheet called "WBS Needed".
The challenge here is to retrieve those rows from the other sheets that meets the criteria of my list of "WBS Needed", and show, in a new worksheet, a new table just the expenses that corresponds to my project (or my WBS).
Attached is my workbook for reference.
The criteria key is WBS number, but I don't know how to list, on the a new sheet, those rows from different sheets that meets the criteria.
(one below the other)
Can be with a Macro maybe? or is there a formula that make things easier?
Rows quantity may vary each month.
Many thanks!
Lean
Bookmarks