Reading and writing from/into several worksheets

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

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
 
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
 
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").ClearContents
 
Back
Top