Is there a way to gather information that is inputted on a worksheet, and paste that into another worksheet via a macro? In other words, if there's a bunch of data on one worksheet for that given week, but i want to press a button whereby that data is copied into another worksheet to maintain historical data of each week. I was easily able to record a macro to do the copy/paste, but i can't figure out how to automatically append a new row each time the button is pressed
help is appreciate
help is appreciate