tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,201
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
I have a tab call "Sales"
In Column A in have statuses,
In column J I have if the job is current or completed.
I'd like a macro that could do this,
If a cell in column A is changed to Active then that same row Column J = "Current"
if a cell in column A is Changed to Inactive then I get a message box saying "Is Sale (and the name of the sale from Column D of the same row) Completed?
if they answer Yes then Column J same row = "Completed"
if they answer No "Current"
anything else no change.
Please help if you can
Thanks
Tony
I have a tab call "Sales"
In Column A in have statuses,
In column J I have if the job is current or completed.
I'd like a macro that could do this,
If a cell in column A is changed to Active then that same row Column J = "Current"
if a cell in column A is Changed to Inactive then I get a message box saying "Is Sale (and the name of the sale from Column D of the same row) Completed?
if they answer Yes then Column J same row = "Completed"
if they answer No "Current"
anything else no change.
Please help if you can
Thanks
Tony