I have a workbook with 15 sheets for different business lines.
This workbook is a template with multiple empty rows on each sheet.
I would like to consolidate sheets 1, 4, 7, 10, and 13 into a master sheet that adds only rows that are not empty.
In addition, I would like to consolidate sheets 2, 5, 8, 11, and 14 into a master sheet that adds only rows that are not empty.
I believe this can be done with VBA, but I don't know how to do that.
Plz explain about : You mentioned 15 sheet.
> But sheet 3,6,9,12,15 (diff every two sheet)
Can you share/attach sample file with before (original data) & after (required result data, enter manually)
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
I can't attach the spreadsheet because of IP regulations, but I can explain further.
I have fifteen sheets named thusly: 1. Demand Scores - HR 2. Project Dates - HR 3. Service & Portfolio Mgmt - HR 4. Demand Scores - ITSM 5. Project Dates - ITSM 6. Service & Portfolio Mgmt - ITSM 7. Demand Scores - ITOM 8. Project Dates - ITOM 9. Service & Portfolio Mgmt - ITOM 10. Demand Scores - ITBM 11. Project Dates - ITBM 12. Service & Portfolio Mgmt - ITBM 13. Demand Scores - CSM 14. Project Dates - CSM 15. Service & Portfolio Mgmt - CSM
These spreadsheets are for use by individual business lines for the prioritization of demands and projects. They will be managed by a central Program Management team, who will require consolidated information from each of these 5 business units. I'd like to take all the Demand Scores sheets, from all the business lines, and combine them into one master Demand Scores spreadsheet. I'd also like to take all the Project Dates sheets, from all the business lines, and combine them into one master Project Dates spreadsheet.
In this case you can enter dummy data & attach the same.
That works. Thanks so much in advance!
Idea not clear. can you mentioned manually required data in respective sheet in specific location (color code for required as : "Green")
From which sheet data extract and where. Give some more specific example.
One suggestion : Instead of separat sheet, kindly maintain in one sheet.
Your sheets "Demand Scores - HR", "Demand Scores - ITSM", "Demand Scores - ITOM", "Demand Scores - ITBM" & also other two sheet each group is same structure.
if you reduse sheet name and in those sheet add additional reference name its more clarity. Also i notice that you have some column is blank & also merge cells, thats not right pratice in excel. Try to avoid blank column, row, or merging cells.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks