[SOLVED] Combining Macros for Template

Hi, I posted this earlier, but I think I gave too much info and it was a little confusing, so here goes again...a little more to the point.

I am trying to combine these two macros into one for a template that I use to paste data from a daily spreadsheet and then after it is formatted with these macros, it then is moved to my final monthly running spreadsheet.

Please Login or Register  to view this content.

After that macro, I click on the last cell of the last row and column of data and then use this macro...

Please Login or Register  to view this content.

I think the answer is a code that can find the last cell of data on the page and then make that the new active cell before beginning the second macro. The problem with that is that I have the template set up for as many as 2,000 rows when I may only use 20 some days...and some of my formulas create text down all 2,000 rows that would be problematic in doing this.

I could; however, insert a column at the end with a formula that will always input a certain symbol, like a * or something...so that the macro can search for the last instance of the * and make that cell the new active cell to begin the next macro.

Possibly there could even be a code that as I am using the first macro to paste in the information from the original spreadsheet to my template, it deletes everything on the template after that, which could then allow the next part of the macro to search for the last cell with data in it.

I just don't know enough about coding to figure out the easiest way to do this.

Any suggestions?