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
Vishal Goel (Chartered Accountant) (1688 Points)
11 March 2015Meri 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
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...
Excel Mastery Program