Reading and writing from/into several worksheets
 

Hi there,

I would like to write a macro/formula to read certain information from
several excel worksheets and to write it into another worksheet.
I have no clue how to start so if anybody can help me or provide me
with some links where I can get information about that I would be very
happy.

Thanks

Christian

Reading and writing from/into several worksheets
 

Try this for a macro solution
http://www.rondebruin.nl/tips.htm


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Chris" wrote in message om...
Hi there,

I would like to write a macro/formula to read certain information from
several excel worksheets and to write it into another worksheet.
I have no clue how to start so if anybody can help me or provide me
with some links where I can get information about that I would be very
happy.

Thanks

Christian

Reading and writing from/into several worksheets
 

Hi Ron,

many thanks for your help, is there a big difference if I use a template
that I already have to fill in the information instead of creating a new
sheet ?

Christian

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Reading and writing from/into several worksheets
 

No problem

If you want to update your data by running the sub again use a line like this
to clear the old data.

Sheets("yoursheet").Cells.ClearContents

Or a range
Sheets("yoursheet").Range("b1:g60000").ClearConten ts


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Christian Balduhn" wrote in message ...
Hi Ron,

many thanks for your help, is there a big difference if I use a template
that I already have to fill in the information instead of creating a new
sheet ?

Christian

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!