Hello and greetings!
I have just joined today. I am a basic Excel user, self taught. I need a solution to my problem, I could not post the query in Excel forum, I was redirected here. Please guide me if I am wrong.
My issue is this:
I have a sheet containing about 120 rows of data, consisting of 13 columns, with a heading for each column.
On different days, I need to select and copy data from different rows and paste them on a different sheet, for calculation and printing.
Is there a way by which I can say include a radio button against each row and then when the buttons against the required rows are pressed, the selected data (all 13 columns) are selected and copied to another file, in the order that they were pressed? To clarify, if I press row no. 7, followed by 2 and then 14, I would like the data in the new file to reflect that order (7, 2, 14, etc).
Would greatly appreciate any help on this. I could attach a sample file showing the 'before' and 'after' effects that I am looking for, but I understand I am not allowed to do so.
Regards and thanks much.