I'm a little over my head here and was hoping someone could help.
I was just given a three spreadsheets:
1) The first spreadsheet is just a collection of macros used to perform some automated calculations and formatting to a set of data.
2) The second is a collection of raw data. The macros are from the first spreadsheet are called and run on this spreadsheet to format and calculate data.
3) The third contains some user defined functions in a module. The data from the formatted sheet 2 is pasted into sheet 3 where these functions are used to calculate some things.
What I have done so far is added the module from (3) containing the user defined functions and copied it into (1). Next, I want to edit one of the modules in (1) and perform the calculations I was doing in (3) within the macro. Basically, I want to call these user defined functions from (3) and use them in a macro in (1) to automate the calculations and append them onto the end of (2).
Thanks for the help!
I was just given a three spreadsheets:
1) The first spreadsheet is just a collection of macros used to perform some automated calculations and formatting to a set of data.
2) The second is a collection of raw data. The macros are from the first spreadsheet are called and run on this spreadsheet to format and calculate data.
3) The third contains some user defined functions in a module. The data from the formatted sheet 2 is pasted into sheet 3 where these functions are used to calculate some things.
What I have done so far is added the module from (3) containing the user defined functions and copied it into (1). Next, I want to edit one of the modules in (1) and perform the calculations I was doing in (3) within the macro. Basically, I want to call these user defined functions from (3) and use them in a macro in (1) to automate the calculations and append them onto the end of (2).
Thanks for the help!
