I have a spreadsheet with data that can change quickly and I want to retain the previous data in a different sheet in the workbook. Can someone tell me how to construct an icon that I can click that will move the data from a certain row to the desired sheet? I have hundreds of rows and columns A thru AA. Thank you!
Hi, kasonjacks,
you would need to tell us if it will always be the same row you want to copy.
Please change the names of the Sheets to suit:
If you want to consider the position of the ActiveCell on Sheet1:
Please Login or Register to view this content.
Cioa,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks