CAN Some one HELP ME?? URGENT Pleazzzz

eciraje

New Member
Joined
Sep 18, 2002
Messages
49
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
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Historian

New Member
Joined
Jul 3, 2002
Messages
4
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.
 

Forum statistics

Threads
1,144,060
Messages
5,722,276
Members
422,420
Latest member
losc

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top