San Antonio Heat
Active Member
- Joined
- Oct 10, 2003
- Messages
- 333
- Office Version
- 2019
- Platform
- Windows
I have a workbook with multiple pages. Is it possible to use some simple code and remove all matching dates and the two cells to the right of it within the entire workbook, for all pages?
Every page with have the same dates and the dates all appear in column "A". I would also like to remove the data next to it so it removes Column "B" and "C" as well. The Dates are on different cells on each page, that's why I need some code to find them easier. 3/10/2011 will appear in cell A68 on page 2 and on page 3, it will appear on cell A90. Dates will always be in cell A.
Ex:Page 2
A68.................B68...........C68
3/10/2011 .......Hamilton.....Corvette
Page 3
A90..................B90.............C90
3/10/2011........Detroit..........Mazaradi
So you click a button and all the matching 3/10/2011 in the workbook get deleted along with the data in B and C cells next to it, thanks!
Every page with have the same dates and the dates all appear in column "A". I would also like to remove the data next to it so it removes Column "B" and "C" as well. The Dates are on different cells on each page, that's why I need some code to find them easier. 3/10/2011 will appear in cell A68 on page 2 and on page 3, it will appear on cell A90. Dates will always be in cell A.
Ex:Page 2
A68.................B68...........C68
3/10/2011 .......Hamilton.....Corvette
Page 3
A90..................B90.............C90
3/10/2011........Detroit..........Mazaradi
So you click a button and all the matching 3/10/2011 in the workbook get deleted along with the data in B and C cells next to it, thanks!
