Require an Excel VBA macro to do the following.
Given an Excel spreadheet (see attachment) require a macro that will prompt the user for Amount in USD, Category (See attachment for list of categories) and comment.
Once data is entered, the amount should be filled in the respective row, column in the spreadsheet. As an example, an
entry on August 01, 2003 can be the following.
Amount(US $): 34.95
Comments: 34.95 for dinner at P.F Changs.
This will need to be automatically entered in cell H1 on sheet named August.
Similarly, other entries will need to be filled. See example on Spreadsheet. Rows are the dates for the month and columns are the categories.
If a cell already has a previous entry, the entered amount must be summed with the existing amount and applied to the cell. Comments must be concatenated to the existing comment.
Finally a report for the month should be made available that will neatly print on one page. [landscape format, comments not required to be printed]
Extra effects thrown in are appreciated.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.
This will need to run on Excel 2002, Windows 2000, XP.