This probably has been asked before, but everything I search for gives me a ton of results.
I have a lot of experience with excel, but I'm just starting to play with macros. So, I don’t really know how a lot of the functions work yet.
I have a spreadsheet with a bunch of information that is automatically updated daily. I have a worksheet set up to summarize all of that information. What I'm trying to do is take the totals from the summary worksheet (that will always be in the same location) and copy that information to another worksheet that tracks the daily totals.
So, the problem that I'm running into is making my macro paste the new totals below the previous day's totals. I understand how to use the offset function for relative references. I just can't figure out how to get back to a different row every time it runs.
Is there a way to make it come back to the row that the cursor is starting at after I make my copy? Because I could easily just make it move to the correct starting cell for the next time at the end of the macro.
Right now, I have it set up to copy the static cells that I want, and I used the relative reference to get back to the columns that I want. But, it is just going to paste over the same row every time. Hopefully, I am missing a way to make it do a relative reference based on the starting location instead of the current location, because I have a lot of other similar uses for macros like this.
Thanks
I have a lot of experience with excel, but I'm just starting to play with macros. So, I don’t really know how a lot of the functions work yet.
I have a spreadsheet with a bunch of information that is automatically updated daily. I have a worksheet set up to summarize all of that information. What I'm trying to do is take the totals from the summary worksheet (that will always be in the same location) and copy that information to another worksheet that tracks the daily totals.
So, the problem that I'm running into is making my macro paste the new totals below the previous day's totals. I understand how to use the offset function for relative references. I just can't figure out how to get back to a different row every time it runs.
Is there a way to make it come back to the row that the cursor is starting at after I make my copy? Because I could easily just make it move to the correct starting cell for the next time at the end of the macro.
Right now, I have it set up to copy the static cells that I want, and I used the relative reference to get back to the columns that I want. But, it is just going to paste over the same row every time. Hopefully, I am missing a way to make it do a relative reference based on the starting location instead of the current location, because I have a lot of other similar uses for macros like this.
Thanks