Macro to reference sheet other than active - unhide and/or export

[Dirty Laundry]

I have created a tool in Excel that allows a sales person to price a widget, view a Proposal (available on a separate tab via a macro), and then export this Proposal into a separate workbook so they can send it to their customer. No problem!

On the Proposal tab, I tried to add more functionality to the "Export Proposal" macro. I would like to also export Material information that is located on a separate hidden tab. If that is not feasible, then I would like to simply unhide the tab. Then I'll just create a new macro on the Material tab to export that Material information.

The following requirements have made this a challenging feat:

• I'll need to use "IF / THEN / ELSE" statements to accomplish either scenario.
• The "IF / THEN / ELSE" statements will be referencing a static cell that is on a separate hidden tab (Formula Data) that contains most of my "back end" formulas.
• Also, I was hoping to be able to do some nesting within the "IF / THEN / ELSE" statements to include "OR" (please see example below).

I have tried fooling around with this code for hours. I have searched online for answers. Then I realized that I just don't know enough yet, and I should ask for help instead of fruitlessly banging my head against the wall.

Here's what I have so far (but I keep getting syntax and break mode errors):

Please Login or Register  to view this content.

So, that is my conundrum. If anyone can provide assistance or feedback, I would greatly appreciate it. Thank you!

[mudraker]

Dirty Laundry

Please take a couple of minutes and read the Forum Rules


Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here