Need macro to consolidate all sheets in workbook

C

Christine

My workbook has many sheets, each contains part no and selling price of
special customers:

A B C
Partno Customer Unit Price (header)
xxxxx yyyyy 999.99 (data)

As and when there are new customers, a new sheet will be added. The name of
the new customer will be indicated at the sheet tabs.

I need to consolidate all these sheets into one and sort by part no.
Let's call it consolidated sheet - 'Consol' and it will be placed at the
front.

How to have macro that will do the consolidation, bearing in mind that new
sheets for new customers are added periodically?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
How to consolidate multiple worksheets into one. 16
macro to link worksheets 5
Copy Sheet to new Sheet and clear cells on original sheets 7
how to sum up the c13 cells in all of the sheets in a workbook 1
Macro To Delete/Add & Rename/Arrange Sheets 5
Macro to Copy Sheets to new workbook 18
Macro to Copy / paste from 1 workbook to another 6

Top