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
- Gst on hired vehicle repair maintenance
- Return defective due to turnover mismatched with I
- Ineligible ITC availed and later reversed under wr
- Temples GST HSN
- Tax filing for the belated payment credit
- Legal service RCM
- OUT OF STATE ADDITIONAL PLACE OF BUSINESS
- Excess claim and paid with DRC03
- Upload of qualified audit report on MCA portal
- Form 26QB on multiple installment
Related Threads
Trending Online Classes
-
25 Hours GST Scrutiny of Return and Notice Handling(With Recording)
Industry Expert14 February 2025 -
Survey, Search and Seizure under Income Tax Act 1961
CA Hari Agarwal
CAclubindia
