Hi everyone
Well I have a bit of a problem, and kind on need some advice/help.
I have a spreadsheet containing data, I have several columns such as quatity, names etc and around 40 records/rows. I have some code which highlights a row If I click on the first cell within the row, however what I want to happen is when a row is highlighted, a button can be clicked which will transfer the data to a new spreadsheet, I have tried using a macro, however obviously this only works for one row, and I need it to work for all rows.
Example
Say row nine is highlight, row A9-G9 will become highlighted, then the data within coulumn A9, should be forwarded to cell G32 B9 to I22 etc etc onto a different spreadsheet, this in the same for all cells highlighted.
The main problem is getting it to work for all rows selected, would appriciate your help on this.
Cheers