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)
(1688 Points)
Replied 03 April 2015
Hello Mukesh Ji
Your link is not working.
Vishal Goel
(Chartered Accountant)
(1688 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
- Urgent doubt on GST
- Profit or Loss on Sale of Assets Accounting treatm
- Clarification on RCM on Rent Payment for QRMP Deal
- Reclaimed itc in gstr9
- Gamification in Accounting Software: Boosting Enga
- I want to knw Hsn code and gst rate of resin produ
- Schedule FA clarification
- Income tax on freelance income from crypto
- ITC temporary reversal and reclaim
- Query on Transactions
Related Threads
CAclubindia
