FrenchCelt
Board Regular
- Joined
- May 22, 2018
- Messages
- 214
- Office Version
- 365
- Platform
- Windows
Hello,
I want to create a macro that looks for blank cells in row 12 of a daily Excel-based report I generate. When it finds one, I want to select every cell in that column starting with row 11 and going down until the same row as a cell in Column A that contains the text "Total Unapproved Indirect Labor" and then deleting and shifting cells left. This range of rows will vary from spreadsheet to spreadsheet, and the number of columns will also vary, but these constraints are constant.
Can anyone help?
I want to create a macro that looks for blank cells in row 12 of a daily Excel-based report I generate. When it finds one, I want to select every cell in that column starting with row 11 and going down until the same row as a cell in Column A that contains the text "Total Unapproved Indirect Labor" and then deleting and shifting cells left. This range of rows will vary from spreadsheet to spreadsheet, and the number of columns will also vary, but these constraints are constant.
Can anyone help?
Last edited:
