I have searched the board without any luck. I’ve come close, but no cigars.
I have a question about whether I can automatically delete certain cells all in the same row, but not in adjacent columns. All based on an answer from a popup box, or something similar??
First, I would like to press a button to start the macro,
Then ask the user for the id #, or cancel the macro,
Find the row with the id# in column E, (the sheet has up to 355 rows and is dynamic),
Then go to the left of the id# cell (same row) and start to delete the cell in column D (has a checkmark, formatted as Marlett font),
Then delete cell in column E (id#),
Delete cells in Columns F and G (front and back names),
Skip the cell in column H (formulas),
Then delete the next two cells in columns I and J (both dates),
Skip the last two columns K and L, (the deleting basically ends in column J),
Then a message box pops up either confirming the deletions, or if the user canceled.
Hope I’ve made myself clear, and much thanks for all the fantastic help on this board.
Peter
I have a question about whether I can automatically delete certain cells all in the same row, but not in adjacent columns. All based on an answer from a popup box, or something similar??
First, I would like to press a button to start the macro,
Then ask the user for the id #, or cancel the macro,
Find the row with the id# in column E, (the sheet has up to 355 rows and is dynamic),
Then go to the left of the id# cell (same row) and start to delete the cell in column D (has a checkmark, formatted as Marlett font),
Then delete cell in column E (id#),
Delete cells in Columns F and G (front and back names),
Skip the cell in column H (formulas),
Then delete the next two cells in columns I and J (both dates),
Skip the last two columns K and L, (the deleting basically ends in column J),
Then a message box pops up either confirming the deletions, or if the user canceled.
Hope I’ve made myself clear, and much thanks for all the fantastic help on this board.
Peter