VBA Project to create an Excel spreadsheet for expenses
$30-100 USD
Selesai
Disiarkan sekitar 19 tahun yang lalu
$30-100 USD
Dibayar semasa penghantaran
Project (2 parts)
1. Create an excel spreadsheet for each quarter.
- A script to copy a template sheet for x weeks
This will create x copies of the worksheet in the single excel file
- The title of each worksheet is the Start date of the week (Cell J13)
- Create a Summary worksheet in the same file that summarizes each week by category and total.
2. Create a script (macros or VBA script) to copy data from a spreadsheet [login to view URL] to a
worksheet in this new file created in 1.
Attached is a copy of the spreadsheet described in 1. and 3 examples of the [login to view URL] files.
This is a simple project for someone who knows what they are doing.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Windows 2000
Excel XP