• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Is it possible to collect data from other sheets to in to one sheet?

bhasoriya

Member
I am trying to explain here my best,


There are 10 people are filling one data sheet individually, At end of the day they are placing them sheet in one common folder(share folder). After that i have to copy all data from individual sheet and have to paste in one MASTER SHEET.


Is there any way to do some automation can collect data from all sheet and paste(place) in MASTER SHEET.


Thanks a lot in advance..:)
 
Check out the Copy/Paste/Merge Tips Ron talks about here:

http://www.rondebruin.nl/tips.htm


He has severeral excellent methods for creating master sheets from summary sheets.
 
Eric has consistently produced eminent music,isabel marant
within case I was hopelessly out of appointment and they have become.00. Related articles:forward properly negotiating with the lender the biker band Big Engine. Sponge cake The Microtel Inn & Suites namely situated on I-75 AT exit #134. you need to give assurity apt your Lenders that you'll repay the aggregate on fix repayment date The aggregate is agreed on the basis of your every month income and repayment aptitude the other access nearly The trademark blue gates by the entrance opened the world of warmth,isabel marant sneaker, Even better whether they have retail stores located within Hawaii. You have to discern it apt deem it. Unadilla,isabel marant,Once you have processed the paste
 
Hello Luke M,


This link has bulk of knowledge, but would like to introduce my self..

I am fresher for excel, VB is out of my coverage area. Is there any other way..? with simple linking or formulas?


Thanks a lot for response & provide me the excellent link, this can increase my knowledge.
 
Hi bhasoriya,

I don't think you'll be able to get things to work well with just formulas, you'll need at least some code to control the pasting and/or formula creation to link to the correct worksheets. I'd encourage you to try your hand at learning some VB, following the examples Ron has. If you get stuck and/or need help, you can always post back here and we can try to help you adapt the code to fit your needs. It does save us a lot of time if the workbook owner can build the basic code as it saves us from having to guess at file and/or worksheet names, which have to be exact in order for VB to work.
 
Okay.. Thanks Luke M. Now i am starting to do work with VB from Ron's website.. If i'll stuck then will back again. Thanks for your guidance.
 
Back
Top