Excel VBA User Form Development III (ID:1905)
Project Creator: |
Scott Perry
FC Member For 6700 Days
Credits 120 Completed Proj. Num. 3 / 4 Total payment USD 320.00 Avg Daily Online 0.00 h (From 21/5/2007) Available on MSN/Skype No Last Login 6/23/2009 Peers Rating 100.00% |
---|---|
Budget: | Less than 250 |
Created: | 2/13/2007 9:02:19 AM EST |
Bidding Ends: | 2/16/2007 9:02:19 AM EST ( Expired ) |
Development Cycle: | 3 Days |
Bid Count: | 3
|
Average Bid: | 66.67 |
Project Description:
I have an excel workbook with 2 worksheets titled "Today" and "Monthly Total" and I need to copy and paste information between them using a macro. At the end of the day I would usually go into "Today" and copy all of the information that has been entered during the day. I would then use paste special values to get the information onto "Monthly Total". The information needs to be pasted into "Monthkly Total" beining at the the first blank cell in column "A". I have a Macro which almost does this but instead of pasting into the first blank cell it simply pastes over the top of previously pasted information. The final step (which works fine in the current macro) is for "Today" A500:CR500 to be copied and pasted over A19:CR499. I need the macro to be fixed so that it performs the above actions correctly. I am happy to send a copy of the spreadsheet and macro to the winnig bidder. Please ask me if you have any questions. |
|
Job Type | Visual Basic |
Attached Files: | N/A |