Macros

hgg_21 · Apr 24th, 2002, 03:02 AM

Hi,

Sorry if u think this is a stupid question. But I want to know what does macros in excel do and how do i create one?

regards

Audiojoe · Apr 24th, 2002, 03:15 AM

Your best bet is to look at the Excel help file, under Macro Overview. This explains what a macro is used for. Under Macro Creating you will find out how to create one. When you have a specific task in mind for your macro post a request up here and someone will help you if you're having trouble

Audiojoe

Afcb · Apr 24th, 2002, 03:16 AM

Look up Macro in the Help file, and look at the following :-

Macros: Automating tasks you perform frequently

Record a macro

Run a macro

hgg_21 · Apr 24th, 2002, 03:17 AM

Hi,

I have two tabs in an excel file. I need to create a macro that can insert an additional tab and insert data in one of the tab into the new tab plus some additional fields.
Can I have a rough idea how to go about doing it?

Thanks and regards

Audiojoe · Apr 24th, 2002, 03:21 AM

To begin with, just try going to Tools>Macro>Record New Macro. Now give your macro a name and click OK

Now just do whatever it is that you want the macro to do and when you're finished, go to Tools>Macro>Stop Recording.

Now you have recorded the macro and what you want it to do. Every time you want to use it you go to Tools>Macro>Macros and select it OR you can assign it to a button by drawing one and right clicking then choosing Assign Macro

Audiojoe

hgg_21 · Apr 24th, 2002, 03:28 AM

hi,

thanks for the fast reply.
I m very new to this macro thing. I shall now go read up on it and do so examples.
Will be back when I encounter any problems and hope that u be here to help!

Thanks and regards!!!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 24th, 2002, 03:02 AM	#1
hgg_21 New Member Join Date: Apr 2002 Location: Singapore Posts: 17	Hi, Sorry if u think this is a stupid question. But I want to know what does macros in excel do and how do i create one? regards

Apr 24th, 2002, 03:15 AM	#2
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	Your best bet is to look at the Excel help file, under Macro Overview. This explains what a macro is used for. Under Macro Creating you will find out how to create one. When you have a specific task in mind for your macro post a request up here and someone will help you if you're having trouble Audiojoe

Apr 24th, 2002, 03:16 AM	#3
Afcb New Member Join Date: Mar 2002 Posts: 5	Look up Macro in the Help file, and look at the following :- Macros: Automating tasks you perform frequently Record a macro Run a macro

Apr 24th, 2002, 03:17 AM	#4
hgg_21 New Member Join Date: Apr 2002 Location: Singapore Posts: 17	Hi, I have two tabs in an excel file. I need to create a macro that can insert an additional tab and insert data in one of the tab into the new tab plus some additional fields. Can I have a rough idea how to go about doing it? Thanks and regards

Apr 24th, 2002, 03:21 AM	#5
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	To begin with, just try going to Tools>Macro>Record New Macro. Now give your macro a name and click OK Now just do whatever it is that you want the macro to do and when you're finished, go to Tools>Macro>Stop Recording. Now you have recorded the macro and what you want it to do. Every time you want to use it you go to Tools>Macro>Macros and select it OR you can assign it to a button by drawing one and right clicking then choosing Assign Macro Audiojoe

Apr 24th, 2002, 03:28 AM	#6
hgg_21 New Member Join Date: Apr 2002 Location: Singapore Posts: 17	hi, thanks for the fast reply. I m very new to this macro thing. I shall now go read up on it and do so examples. Will be back when I encounter any problems and hope that u be here to help! Thanks and regards!!!