Meri ek excel workbook me 100 sheet hai. mujhe ek single sheet me har sheet se data ko lana hai..
excel me koi formula hai kya isko karne ke leye...Plz help.
Thanks
5 Replies
Arpit Shah
(Accountant)
(21438 Points)
Replied 11 March 2015
Check Link That Will Help You
https://www.ablebits.com/consolidate-worksheets-excel/worksheets-consolidation.php
Arpit Shah
(Accountant)
(21438 Points)
Replied 11 March 2015
Other link
https://www.extendoffice.com/documents/excel/1184-excel-merge-multiple-worksheets-into-one.H T M L
CA Kumar Mukesh
(CA CMA FINAL and Advance Excel Trainer)
(6881 Points)
Replied 03 April 2015
You want make data consolidation?
Just click on my articles over these problems
/articles/data-consolidation-in-microsoft-excel-part-2-advance-excel--22698.asp
Vishal Goel
(Chartered Accountant)
(1693 Points)
Replied 03 April 2015
Hello Mukesh Ji
Your link is not working.
Vishal Goel
(Chartered Accountant)
(1693 Points)
Replied 03 April 2015
Hello,
Ek excel work book me 100 sheet hai, har sheet ke CELL C10 me total hai us sheet ka....mujhe har sheet ke CELL C10 ki value ko 101 number wali sheet me lana hai....Kindly help
Cell reference use kar sakte hai but bahut time waste ho jata hai...
Recent Topics
- Bonjour quel est la meilleur banque a Delhi
- What is the fees for UPSC coaching in Delhi?
- Filling form 26 QB
- RPT AND ITC ISSUE
- Tax Liability and ITC Summary related Issues
- Choosing Between APA, MLA, and Chicago Styles for
- The world's most luxurious train
- REQUIRED FORMAT FOR AMENDMENT TO PARTNERSHIP DEED
- TDS Applicability on Hotel Room Rent Exceeding 
- Long Terrm Capital Gain Tax Expemption - Question
Related Threads
CAclubindia
