I have a spreadsheet that I would like to automate. Everyday, I need to save these rotations and would like to put a macro in and a push button to do it automatically.
I've included a portion of my spreadsheet. I would like it to copy the information beginning in K1. When I copy it the next day I would like it to copy beside the other information leaving two columns for visual purposes. I'd like to put one weeks worth of information in the same columns and rows, then it would increment down the appropriate cells and start the process over until 52 weeks worth of information is stored. I have a macro written to clear the information with a push of a button.
I'm not very good with visual basic and am looking for a good book/tutorial to become more knowledgable. I would appreciate any assistance ya all may lend.
Appreciated Wyatt12
Bookmarks