Adnandos
New member
- Joined
- Jun 12, 2018
- Messages
- 25
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 365
Hi. I have a data capture spreadsheet that I roll out to data capturers.
They capture information by row, with certain columns being automated and locked.
My spreadsheet follows a uniform structure, makes provision for a large number of rows, and I have 18 columns, 6 of which are automated by way of locked formulas, leaving 12 Data Entry Cells per row.
How can I create a button that will be in column A, of each row, that will only clear the 12 Data Entry Cells in that row?
Just looking for a quicker way for data capturers to clear their rows if they identified numerous problems.
I have a basic understanding of Macros, but only very limited knowledge of VBA.
Any assistance would be appreciated.
They capture information by row, with certain columns being automated and locked.
My spreadsheet follows a uniform structure, makes provision for a large number of rows, and I have 18 columns, 6 of which are automated by way of locked formulas, leaving 12 Data Entry Cells per row.
How can I create a button that will be in column A, of each row, that will only clear the 12 Data Entry Cells in that row?
Just looking for a quicker way for data capturers to clear their rows if they identified numerous problems.
I have a basic understanding of Macros, but only very limited knowledge of VBA.
Any assistance would be appreciated.