Hi Team,
I have a set of excel sheets containing capacity data of resources client wise.I need to consolidate all the data in a single sheet .Attaching the excel file. Pls guide me how to do this with the help of VBA code.There are total 15 sheets which needs to be consolidated in the consolidation file.Pls help as I am a newbie.
Regards,
APS
Hi aparnawangu,
This is the same question as the one a week ago, what has changed?
Hi Dave,
The question is same as the code given earlier is not fetching the correct result.So started it afresh and closed the old thread.Just included the real time columns and no of sheets that's the change.As I have a sheet with sumit formulas and I created that for time being so that my work doesn't stop.While comparing with that sheet I came to know the data fetched by macro is not correct.As I m not a macro expert and just started learning it ,so was unable to fix the problem with macro.Please seeif u can help me.
Regards
APS
Hi Team,
Can I get help on this.I require the code which will consolidate data from all sheets to one consolidation sheet.
Please I am new to macros.Help me out.
Regards
APS
Some informations back will help.
The final sheet is "Consolidation" ???
In sheet "Consolidation" from where is coming data: Portfolio column A and Portfolio column F
The sheets where to gather data are all sheets except "Consolidation" : Included "Client Services"
There is a sheet named "Client Services" can we use it to prepare "Consolidation"
Last edited by PCI; 12-17-2017 at 07:12 AM.
- Battle without fear gives no glory - Just try
Nevertheless this IS the same workbook and essentially the same question as your other thread. We have a rule about duplicate threads - please abide by it.
You should now continue in your other thread. This one is closed.
Continue here, please: https://www.excelforum.com/excel-pro...one-sheet.html
Last edited by AliGW; 12-17-2017 at 07:25 AM.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks