I'm using a workbook containing a worksheet with same layout for each customer with their orders & delivery quantities by date and means of transport. I want to consolidate all the data from the different worksheets into one worksheet (Summary), where update has to be automatically by activating the sheet Summuray. Other sheets are added weekly with new customers. I have been looking everywhere to consolidate with a macro or udf, but could not find the exact solution. Can someone help me ? Thanks a lot.
-
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.
Consolidate Worksheets (and new added sheets) into One Worksheet+ sum by date & customer
- Thread starter guatelize
- Start date
Similar threads
- Question
