Search for project

More than 2000 projects issued through our platform and this
amount increases very fast.

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

Bids placed

(There are 3 bids on this project, these are listed below)
 
Contact*:
Email*:
Telephone:
(Include country code)
Enquiry*