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

Transferring data from multiple sheets in workbook to one sheet 1
adding footer to all existing sheets in workbook and also to newsheets which is added 1
Macro VBA coding, Copying content from one workbook to a new one 0
macro to link worksheets 5
list sheets in workbook 3
how to sum up the c13 cells in all of the sheets in a workbook 1
Macro to Copy Sheets to new workbook 18
Macro to Copy / paste from 1 workbook to another 6

Top