[SOLVED] Combining Macros

Hi, I am working on creating an easy to use template for my coworkers and myself. So far it is working great with the macros I am using, but I did notice that two of them could probably be turned into one macro and cut out a couple extra steps. It isn't necessary that this be done, but if it is possible, I would love to know how to.

Right now, data is coming in on daily spreadsheets that I insert a column before column A and then sort and remove what is not relevant to my job. I then highlight everything from the end of the data up to column A (excluding the header row) and use this code to paste it into my template.

Please Login or Register  to view this content.

Essentially my template is all of the same columns twice, the first time they are exactly the same as on the original spreadsheet sent to me, except I don't see them because they are hidden. What I do see; however, is the duplicate of each column that links to the corresponding column's information by way of formulas...this way I can change the order of the columns so that I can view the information that is most important to my job easily. Also, there is a blank column (column A) that I use to paste the information from the original spreadsheet to (which is why I inserted a column in the original spreadsheet).

I use the code that I previously stated, which pastes the information and then copies all the information on the sheet and paste's it again as values so that I do not have formulas anymore.

After that is done, I then need to transfer the information into a running spreadsheet that I can use to see all of my information for the entire month. To do that, I click on the last cell of the last row and column and then use this macro...

Please Login or Register  to view this content.

That copies everything up to BR2 (which is where the hidden columns end and the data I have in the order I want begins) and pastes it into my monthly spreadsheet where the first empty row is found.

I am very happy with this set up, but as I said before, it seems that there should be a way to work the 2 codes together into one. I believe 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 3,000 rows and some of my formulas create text that would be problematic for that. I could; however, insert a column at the end with a formula that if there is a value in a different cell (a cell that there always is data in), then it outputs a certain symbol and then the macro could search for the last instance of that symbol...if that is a possibility.

Sorry if I gave too much information, but I figured if someone feels that something else I am doing can be simplified as well, then by all means...I'll take any suggestions but my first priority is to get these macros working together as one.

:]