Oops sent to wrong forum: Excel Macros

[Dar]

Hi: I have a workbook with 14 worksheets. I need 14 macros

I want the name of the macro to be the name of each worksheet. ex. FA2E,
FA3E, FA4E, etc. the macro is the same except for referencing the worksheet
name.
I have the first macro and am copying/pasting 14 times, changing the
worksheet name and macro name.
However, it doesn't work properly. About the 5 copy/past excel seems to
want to call the macro by the name of the workbook, dot, worksheet. What am
I doing wrong.
When I open up tools, macro, I want to see the 14 names as stated above.
Because, I have a final macro that calls each macro, so I would call,
FA23, FA3E etc.

Help would be appreciated.

 

[Daryl S]

Dar -

If the macro is the same other than the worksheet name, why don't you just
use the one macro, and use a variable name for the sheet name. This will be
much easier to maintain.

 

[amandamaomao]

Do you want to merge excel sheets from separate worksheets, you can consolidate
data from each separate worksheet into a master worksheet. The worksheets can
be in the same workbook as the master worksheet or in other workbooks. When
you consolidate data, you are assembling data so that you can more easily
update and aggregate it on a regular or ad hoc basis.
You need not worry about this puzzle，solve it easily with this free software.