Excel help


Vishal Goel (Chartered Accountant)     11 March 2015

Vishal Goel
Chartered Accountant 
 135 likes  1621 points

| My Other Post

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

avater

Arpit Shah (Accountant)     11 March 2015

Arpit Shah
Accountant 
 445 likes  21335 points

View Profile | My Other Post

Check Link That Will Help You

 

https://www.ablebits.com/consolidate-worksheets-excel/worksheets-consolidation.php

1 Like
avater

Arpit Shah (Accountant)     11 March 2015

Arpit Shah
Accountant 
 445 likes  21335 points

View Profile | My Other Post

Other link

 

http://www.extendoffice.com/documents/excel/1184-excel-merge-multiple-worksheets-into-one.H T M L

avater

CA Kumar Mukesh (CA CMA FINAL and Advance Excel Trainer)     03 April 2015

CA Kumar Mukesh
CA CMA FINAL and Advance Excel Trainer 
 466 likes  6806 points

View Profile | My Other Post

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

avater

Vishal Goel (Chartered Accountant)     03 April 2015

Vishal Goel
Chartered Accountant 
 135 likes  1621 points

View Profile | My Other Post

Hello Mukesh Ji

Your link is not working.

 

avater

Vishal Goel (Chartered Accountant)     03 April 2015

Vishal Goel
Chartered Accountant 
 135 likes  1621 points

View Profile | My Other Post

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...

 


Leave a reply

Your are not logged in . Please login to post replies

Click here to Login / Register  




Popular Discussion


view more »