LinkBack URL
About LinkBacks
pls see second post
pls see second post
Last edited by maheshwow; 01-18-2012 at 10:46 AM. Reason: requirement simplified
i found this code for consolidation which merges all sheet in workbook in a given range Column-A to Column-G.
http://www.rondebruin.nl/copy2.htm
This is want i needed, however with the ability to consolidate sheets referred to in summary page. Summary page also gives each sheet name & no. of times it should repeat in consolidated output.
Please Login or Register to view this content.
(I've made requirement bit simpler than 1st post so that i can modify it according to my need. later)
Please help to update the above code with this feature.
Last edited by maheshwow; 01-13-2012 at 12:42 PM.
I understood from above code that "For Each sh In ActiveWorkbook.Worksheets is the code which selects sheets to be merged.
Please help me modify it to call only for sheets given by me in summary page Column-A, and repeats the sheet entry as many times as mentioned in Column-B of summary page.
pls help. pl let me know if vba doesnt support this type of merging.
y is noone helping me on this....did i ask for something too much?
i'll be really thankfull for a reply to my query.
Please Review the file that you attached.
1. Summary sheet doesnt include the number of times.
2. The QTY number for item "ABC" in the cosolidated sheet doesnt reflect any logic.
Please describe exactly how the cosolidated sheet is calculated.
Regards,
Khaled Elshaer
www.BIMcentre.com
Remember To Do the Following....
- Thank those who have helped you by clicking the Star below their post.
- Mark your post SOLVED if it has been answered satisfactorily:
- Select Thread Tools (on top of your 1st post)
- Select Mark this thread as Solved
Thanks a thousand times for replying. Now i see why i was getting no reply..sry for the stupidity...
Attached files has "Summary" sheet which says that Sheet-A should repeat 1 time, Sheet-B 2 times & Sheet-C 1 time.
The consolidated page is the output page where you'll see the Sheets A,B & C copied as per above criteria.
Sir, you are a life saver, i would rep and kill you if you can find me a solution.
That's good,
Will do it for you.
Here you Go
Please Login or Register to view this content.
Dear Mr.Kelshaer ,
I dont have words to thank you.. I really appreciate your help. I owe you big one!!
This could take me to new level in my career..you wouldnt even believe, all with help of genius..Kelshaer!
THANKYOU FOR YOU HELP.. & I MEAN IT.
You are welcome.
Just remember to help any one if you can
And mark this thread as SOLVED
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks