Need macro to consolidate all sheets in workbook
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? |
Need macro to consolidate all sheets in workbook
|
All times are GMT +1. The time now is 08:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com