john3j
03-16-2009, 08:08 AM
Hey guys,
Im trying to eliminate human interaction because we all know people just tend to mess things up. I have an excel sheet that has multiple pages that sorts and then calculates data to create charts. As of now, I am going into my database....microsoft access db...and i am running a macro that pastes the data into a new spreadsheet. From here, I am opening the spreadsheet that was created, selecting rows 2 thru 1000, and then pasting them into row two of my workbook that was created. If there any way to make it so that when I run the macro, it will populate into my workbook, while preserving all of my premade sheets? Let me know! Thanks!
John
Im trying to eliminate human interaction because we all know people just tend to mess things up. I have an excel sheet that has multiple pages that sorts and then calculates data to create charts. As of now, I am going into my database....microsoft access db...and i am running a macro that pastes the data into a new spreadsheet. From here, I am opening the spreadsheet that was created, selecting rows 2 thru 1000, and then pasting them into row two of my workbook that was created. If there any way to make it so that when I run the macro, it will populate into my workbook, while preserving all of my premade sheets? Let me know! Thanks!
John