Sam Longstaff
Member
Hi,
I wish to merge sheet data (from multiple worksheets) into one consolidated worksheet (master sheet named POSITIVE) using VBA that runs before saving.
I would like to be able to loop through all of the worksheets except my master sheet and a worksheet named QFT. Ideally I would like to consolidate the data from each column (A to H) but only if the data in column G is "Yes". If this is not possible I'd be happy for all the data from each sheet to be consolidated into the master and then I can filter it.
The workbook will be added to continually over time so I would like a solution that will not create duplicate data in the master sheet.
I have found some consolidate VBAs on the web but I'm a novice with VBA so I haven't managed to amend one to meet my need.
I hope someone can help, thanks in advance.
I wish to merge sheet data (from multiple worksheets) into one consolidated worksheet (master sheet named POSITIVE) using VBA that runs before saving.
I would like to be able to loop through all of the worksheets except my master sheet and a worksheet named QFT. Ideally I would like to consolidate the data from each column (A to H) but only if the data in column G is "Yes". If this is not possible I'd be happy for all the data from each sheet to be consolidated into the master and then I can filter it.
The workbook will be added to continually over time so I would like a solution that will not create duplicate data in the master sheet.
I have found some consolidate VBAs on the web but I'm a novice with VBA so I haven't managed to amend one to meet my need.
I hope someone can help, thanks in advance.