ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,279
- Office Version
- 2007
- Platform
- Windows
With my work I enter values in each cell from column A to AD
Now & then the same customer returns for a second or third job.
I would like to save time & be able to copy all the values in that customers row to row 5
It would be put on a command button & work like so.
Select the customer in column A
Run the code on the command button which will copy the values from A to AD
Insert new row at row 5
Now paste the copied values into the new row that was just created.
Please advise many thanks.
Now & then the same customer returns for a second or third job.
I would like to save time & be able to copy all the values in that customers row to row 5
It would be put on a command button & work like so.
Select the customer in column A
Run the code on the command button which will copy the values from A to AD
Insert new row at row 5
Now paste the copied values into the new row that was just created.
Please advise many thanks.