tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
I want a macro that can do this.
I have 5 sheets named
"sales"
"New"
"Old"
"Canceled"
"Data"
I want to be able to select a cell in column A of any of the above sheets and have a macro delete that row in all Sheets
So for example:
I select Sheet"Data" range(A21) if A21 is Empty do nothing,
If A21 is not empty, then message box "You are about to delete Project (and the name in A21) do you want to continue?" if yes
then delete Row 21 entire row from all sheets (
"sales"
"New"
"Old"
"Canceled"
"Data")
message box " Data has been deleted!"
please help if you can
thanks
Tony
I want a macro that can do this.
I have 5 sheets named
"sales"
"New"
"Old"
"Canceled"
"Data"
I want to be able to select a cell in column A of any of the above sheets and have a macro delete that row in all Sheets
So for example:
I select Sheet"Data" range(A21) if A21 is Empty do nothing,
If A21 is not empty, then message box "You are about to delete Project (and the name in A21) do you want to continue?" if yes
then delete Row 21 entire row from all sheets (
"sales"
"New"
"Old"
"Canceled"
"Data")
message box " Data has been deleted!"
please help if you can
thanks
Tony