Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help writing formula to merge two worksheets | Excel Discussion (Misc queries) | |||
Need sample for reading value from and writing value to cell E53 from outside Excel | Excel Discussion (Misc queries) | |||
reading from SQL | Excel Discussion (Misc queries) | |||
Reading XML | Excel Discussion (Misc queries) | |||
Writing macro to format multiple worksheets? | New Users to Excel |