CAN Some one HELP ME?? URGENT Pleazzzz

[eciraje]

Hi Guys
I have several excel forms in one directory . all form are identical but contains different data. and i want to take out information from all forms to one excel sheet. Can any one of you know how to creat a macro??
This message was edited by eciraje on 2002-09-19 18:02

 

[Historian]

On 2002-09-19 16:39, eciraje wrote:
Hi Guys
I have several excel forms in one directory . all form are identical but contains different data. and i want to take out information from all forms to one excel sheet. Can any one of you know how to creat a macro??
This message was edited by eciraje on 2002-09-19 18:02

I think you will need to re-write your question.

What do you mean by a form?
(Template? User form? Workbook? Worksheet?)

Do you really mean a directory or do you mean a workbook?

"All forms are identical" except for the data.
Same format? Same number of rows/columns? Same formulas?

How to put the information to one worksheet?
Consolidate data? Paste data(values only?) in sets, one beneath the other? Or .... ?

More specific details are required before anyone will be able to help.