https://www.box.com/s/8c70deb964524d2d8111 File Name: TestMrExcel
Please see the attached document.
My desire is to pull a value from a dataset based on certain parameters. I would like to complete the following within the document (example) but on a larger scale.
I need a macro/formula for the following to occur (instructions are within document as well): If valueof one cell in "MC Sales Amount" column in database "ChargeDaddy" is greater than or equal $100,000, List value and highlight in red. If not over $100,000, list max value in standard black.
The second thing I would like to be able to do is create hyperlinks within the document automatically. I know how to do them manually but if we have over 1000 tabs at one time, how can I create hyperlinks between my running analysis page and each individual tab upon creation. I have a macro thanks to hiker that populates the tabs automatically however, I would like to be able to populate that same listing into the analysis spreadsheet after the macro has completed its work. Let me know if you have questions.
Thanks!!
Please see the attached document.
My desire is to pull a value from a dataset based on certain parameters. I would like to complete the following within the document (example) but on a larger scale.
I need a macro/formula for the following to occur (instructions are within document as well): If valueof one cell in "MC Sales Amount" column in database "ChargeDaddy" is greater than or equal $100,000, List value and highlight in red. If not over $100,000, list max value in standard black.
The second thing I would like to be able to do is create hyperlinks within the document automatically. I know how to do them manually but if we have over 1000 tabs at one time, how can I create hyperlinks between my running analysis page and each individual tab upon creation. I have a macro thanks to hiker that populates the tabs automatically however, I would like to be able to populate that same listing into the analysis spreadsheet after the macro has completed its work. Let me know if you have questions.
Thanks!!