Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a worksheet that has a macro that performs a certain function that my
business needs. Unfamiliar with macros, I re-formatted it to suit our needs, but messed up the macro functionality in the process. I will be taking macro classes this June, but for now we need a working worksheet for work purposes. The sheet that has the macro we need is named "AnalysisCost." Please, can anyone help. The address immediately below is for the original worksheet that has the working macro (for reference purposes). The "AnalysisCost" sheet in it has the macro that does almost what we need. http://savefile.com/files/1488555 The address below is for the revised worksheet that is formatted the way we need it, but has messed up macro in the "AnalysisCost" sheet. Please take note of the notes in the AnalysisCost sheet because it describes how we would like the sheet to properly function. http://savefile.com/files/1488556 If you need to email me, please send to Thanks in advance. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
You're not going to get many people to open your workbook, so try this.
Open the workbook Alt F11 Find the macro of interest Copy and paste the code here. Someone should be able to help you from there. -- HTH, Barb Reinhardt "timteebow66" wrote: I have a worksheet that has a macro that performs a certain function that my business needs. Unfamiliar with macros, I re-formatted it to suit our needs, but messed up the macro functionality in the process. I will be taking macro classes this June, but for now we need a working worksheet for work purposes. The sheet that has the macro we need is named "AnalysisCost." Please, can anyone help. The address immediately below is for the original worksheet that has the working macro (for reference purposes). The "AnalysisCost" sheet in it has the macro that does almost what we need. http://savefile.com/files/1488555 The address below is for the revised worksheet that is formatted the way we need it, but has messed up macro in the "AnalysisCost" sheet. Please take note of the notes in the AnalysisCost sheet because it describes how we would like the sheet to properly function. http://savefile.com/files/1488556 If you need to email me, please send to Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
need help to update macro to office 2007 macro enabled workbook | Excel Discussion (Misc queries) | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) |