Hi, I have a cost model which consists of 5 identical worksheets. Within these worksheets there are different sub headings. Within the sub headings there are 'In-House Equipment', 'Personnel' & 'Third Party Equipment', with one of the sub headings being 'Consumables' What I need extracted & summarized: In House Equipment - only lines where the source is 'purchase' Third Party Equipment - All Personnel - All Consumables - All What I need is for the macro to: Pull in all the information on to a separate sheet (information for all the same headings that are in the 5 worksheets) Consolidate this data so that if there are duplicates of the same description, it is shown only once with the sum of all values relating to that description Thanks!

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Summary Sheet Pulling from Multiple Ranges of Multiple Sheets Dependent on a Certain Criteria

Thread starter mfactor993
Start date Aug 21, 2017
Tags

consumables equipment headings multiple worksheets

mfactor993

New Member

Aug 21, 2017

Hi,

I have a cost model which consists of 5 identical worksheets.

Within these worksheets there are different sub headings.

Within the sub headings there are 'In-House Equipment', 'Personnel' & 'Third Party Equipment', with one of the sub headings being 'Consumables'

What I need extracted & summarized:

In House Equipment - only lines where the source is 'purchase'
Third Party Equipment - All
Personnel - All
Consumables - All

What I need is for the macro to:

Pull in all the information on to a separate sheet (information for all the same headings that are in the 5 worksheets)
Consolidate this data so that if there are duplicates of the same description, it is shown only once with the sum of all values relating to that description

Thanks!