See my attached sheet as it is. I know what I'm asking is incredibly simple...I just can't figure out the formula needed to do it and I can't seem to ask the right question in Google to find my own solution.
I'd like for a second button to be on the right of "Click me" that exports the number data in A1 along with the date to Sheet 2 A1 (number) B1 (date). When pressed again it would go to Sheet 2 A2 (number) B2 (date) and so on. Any help is greatly appreciated!
Format the date to your preference.
Also, "Sheet1" and "Sheet2" may need to be changed to match your actual workbook.
Please Login or Register to view this content.
I'm interested in starting a career working with VBA, if anyone knows of any opportunities!
Perfect! Works like a charm. Thanks a lot!
You're welcome. Please mark this thread as SOLVED, and any reputation points (the star in the lower left of the posts) is appreciated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks