ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,689
- Office Version
- 2007
- Platform
- Windows
I have a table where the Headers are in row 2
My row range is A3:I3 then down the page.
My goal is to have the user select a customers name cell in column A
The user will then use the command button code to move that customers entire row to row 3
Example
Tom Jones is currently at row 10
The user will select Tom Jones name in cell A10
Click the command button.
Tom Jones should now be at row 3.
The rows after A10 should all move up as to not have row A10 with all empty cells.
Please can you advise.
Thanks.
My row range is A3:I3 then down the page.
My goal is to have the user select a customers name cell in column A
The user will then use the command button code to move that customers entire row to row 3
Example
Tom Jones is currently at row 10
The user will select Tom Jones name in cell A10
Click the command button.
Tom Jones should now be at row 3.
The rows after A10 should all move up as to not have row A10 with all empty cells.
Please can you advise.
Thanks.