First and foremost, I want to apologize for my ignorance with macro coding and VBA, now with that being said, I am VERY new to the sport (somewhere nearing a week), and this is my first post.
After watching several MrExcel youtube videos, I have been able to create a worksheet named "Receipt" and have macros set to a button, that when clicked will post the info I want to keep track of into a second worksheet called "Register, Copy and Save the active workbook as a .xlsx file, print two copies, close the active workbook, clear the contents of the "Receipt", create a new "Receipt" with sequential numbering, and save the new workbook.
What I would like is, to automatically have the "Register" print and save a copy for redundancy when it gets full. Can this even be done without going to the "Register" sheet and creating a macro just to print and save? If it can be done, how? I have no clue where to start.
Thank you in advance,
Greg
After watching several MrExcel youtube videos, I have been able to create a worksheet named "Receipt" and have macros set to a button, that when clicked will post the info I want to keep track of into a second worksheet called "Register, Copy and Save the active workbook as a .xlsx file, print two copies, close the active workbook, clear the contents of the "Receipt", create a new "Receipt" with sequential numbering, and save the new workbook.
What I would like is, to automatically have the "Register" print and save a copy for redundancy when it gets full. Can this even be done without going to the "Register" sheet and creating a macro just to print and save? If it can be done, how? I have no clue where to start.
Thank you in advance,
Greg