pandora1234
New Member
- Joined
- Aug 10, 2014
- Messages
- 1
Hi I have to copy values from columns A, D and E from one worksheet to the same columns in another worksheet. I want to use vba as its a fiddly process otherwise. It would be easier to copy the whole range of data initially from A to F, but then click a button on the second worksheet to paste special the selected column values into the second worksheet. Any ideas how I could do this? I'm using excel 2007, and would assign the macro to the quick toolbar at the top. Thanks