Hello - Hoping someone here can help me with this one.
I have a spreadsheet that is used as a Time-Off requester (i.e. the end users request time off via a user form. The data from the user form is sent to Sheet1(Reporting) and later by a macro is copied from the Reporting sheet to Sheet7(Log). The Reporting sheet is then cleared (for the next use of the macro).
The Log sheet keeps populating via the macro (it’s a running list of pending time off requests). Column J of the Log has the current status of the request – either Yes, No, or Pending, pending being the default.
What I need is (I think) a worksheet change macro for the Log that will run whenever column J is changed, but not when it is Pending. So when the column is changed to anything other than pending.
The macro I'm hoping to run on the change (I've been trying by call) will copy the active cells row on the Log & send it to a transfer tab Sheet13(AETrans), which then sends an email, etc.
Any help would be greatly appreciated.
Bookmarks