Chewyhairball
Active Member
- Joined
- Nov 30, 2017
- Messages
- 312
- Office Version
- 365
- Platform
- Windows
Hi Folks
I have a table of data and I would like to be able to copy arow of data and paste it into a different row using VBA and a button.
My table goes from columns A-G and infinite rows down.
Here is what I require but cant figure out..
Also it needs to be copy and paste instead of moving anycells.
I have an old macro that does something a little bit similarbut I cant for the life of me adapt it.
Thanks for any help with this.
Rory
I have a table of data and I would like to be able to copy arow of data and paste it into a different row using VBA and a button.
My table goes from columns A-G and infinite rows down.
Here is what I require but cant figure out..
- Click anywhere on a row I want to move to adifferent row
- Press a button at the top of the page that saysMove Row( I can do this bit J)
- The macro highlights columns A-G in the row thencopies.
- A message pops up telling you to ‘Select yourdestination Row’
- You select any cell in that row then click OKfor the above message.
- The data is then pasted into the selected rowand the old date in rows A-G are deleted.
Also it needs to be copy and paste instead of moving anycells.
I have an old macro that does something a little bit similarbut I cant for the life of me adapt it.
Thanks for any help with this.
Rory