Move data from multiple worksheets to single workbook

[Guest]

Here is the idea that I have, and wonder how I would go about it or if it is really possible without trying to create some sort of Access database

Right now I am using daily Excel worksheets (printed out) to keep track of student behavior in my self contained behavior disabilities classroom.

What I would like to be able to do is use a laptop (or palmtop - i.e. Sharp Mobilon w/MS Excel) to collect daily data (numbers) with daily Excel workbooks and at the end of the day, move the data from the daily workbook (via script or some method other that manually keying the information) to a "Yearly" workbook. The yearly workbook would be used for inquiry or year to date reporting.

Any ideas? Is there another forum inwhich I should have asked this question???

Thanks in advance!

 

[Ron de Bruin]

Hi tom

You can read the data from all your workbooks into one workbook
Check out this page
http://www.rondebruin.nl/copy3.htm

Or you can use a database workbook to copy your data in
http://www.rondebruin.nl/copy1.htm#workbook


--
Regards Ron de Bruin
http://www.rondebruin.nl

Here is the idea that I have, and wonder how I would go about it or if it is really possible without trying to create some sort of Access database.

Right now I am using daily Excel worksheets (printed out) to keep track of student behavior in my self contained behavior disabilities classroom.

What I would like to be able to do is use a laptop (or palmtop - i.e. Sharp Mobilon w/MS Excel) to collect daily data (numbers)

with daily Excel workbooks and at the end of the day, move the data from the daily workbook (via script or some method other that
manually keying the information) to a "Yearly" workbook. The yearly workbook would be used for inquiry or year to date reporting.