Update Columns to Another Worksheet, then update another worksheet based on a set criteria

[mnunnley]

Please Help
1. How can I have columns A-N for each Auditor write to the MASTER tab when saved or when a button pressed.
2. After the Master tab is updated
3. If Column F of the Master tab is populated with the following Hold Reasons (listed below) send the information populated in columns A-F to the Re-evaluate tab.
· Pending
· AEXT
· APM Pending
· D Account
· Escalation
· Ground Date
· Inspection Date
· Pull Ahead Pending
· Sales Proceeds
· Sales Tax
· SCRA
· Short Payoff
· Status

[xladept]

A lot of whitespace in your sample:

Please Login or Register  to view this content.

[xladept]

Hi Malisa,

I've put a button on your Re-evaluate tab assigned the macro to it and saved your book as macro-enabled.

Here are some instructions (but I've already done this book):

Directions for running the routine(s) just supplied

If you haven't used macros before you'll need to go to:
File- options - trust center -trust center settings - macro settings ,
the second option down (disable all macros with notification)

Then - Copy the code to the clipboard

Open your Workbook

Press ALT + F11 to open the Visual Basic Editor.

Select "Module" from the Insert menu

Type "Option Explicit" then paste the code under it

With the cursor between Sub and End Sub press F5 (F8 to Single Step)

OR

Press ALT + Q to close the code window.

Press ALT + F8 then double click on the macro name
*Be sure to save the book with the code as Macro-Enabled

[mnunnley]

All I can say is that you are truly a GENIUS. Thank you for your help.

[xladept]

You're welcome and thanks for the compliment and for the rep!