Microsoft Excel Programming
Required knowledge: Data Entry, Data Processing, Excel
I have two spreadsheets. One has customer information, Name, address, account number, sales rep, etc. The second spreadsheet has catalog product information - Item#, description, cost, discount, etc. I need to have a program/macro make unique spreadsheets for each customer with the customers information on the cover sheet, and the product ordering information following. I realize that this can be done with a database, but I'm just a salesman looking for a quick and clean solution. The resulting file needs to be emailed to the customers once a month. when anything changes in the customer file, the resulting Customer file needs to be updated. I am looking for ideas and solutions. I realize that this is not defined in detail yet, just concept. Please submit ideas and budgets. Thanks, |
Job Categories: |
Data EntryData ProcessingExcel |
Related projects: |
|
|
Access Excel Programming2. Speed of completion of project. I expect you to complete the job within the time frame you state. If the project is delayed for any reason except caused by me, then the project is subject to full cancellation.3. Your history and rating - I will consider those with few ratings if they communicate well and demonstrate they understand the project. 4. Price Contact me via PMB to schedule a skype session to walk through the job spec by voice. |
Simple MS Excel Program to calculate Projected salesWe need to modify a simple Microsoft Excel program to calculate projected sales for a restaurant.Interested and experienced uses who knows MS Excel PM me for more details. |
file conversion excel to csvI need to convert the following microsoft excel file to csv formatThe CSV file must be ASCII text and have a CSV extension Each row must appear on a separate line Each column/field must be separated by a comma The winner bidder must show an example of the output - perhaps the first 10 rows out of the 3372 rows. This needs to done quickly. Many thanks |
Extract Data from Scanned PDF into Word Table or Excel Spreadsheet. The finished document will be proofread.Sorry, but I will not consider new providers for this job. You must have positive feedback on similar projects. Type the words twenty-one camels in your bid so I know you are a live person. My budget is around $ 50 for the entire job, a little more if you have excellent reviews and a lot of relevant experience. If the entire job is completed within 24 hours, with minimal errors, I will pay a $ 10 bonus. |
Automatic transfer needed - From Microsoft Excel to eBay Turbo - Anyone???ay turbo program is becoming very time consumingMy set up: In my excel sheet i have all of my information which i transfer manually to the eBay turbo site. I need someone who can have a program do it automatically Specifics: -In my excel sheet the info for each eBay item is on a different row. -All items CANNOT be transferred at the same time. -Items must be transferred one by one. Please let me know if you are interested. |
VBA Excel 2007 SalesCopy Writing, Ebook Writing, Article Writing, Market Research, Niche Research,PT ANY BIDS FROM ANYONE IF THEY DO NOT SUBMIT THE PROJECT CODE ALONG WITH THEIR BID PROPOSAL. This project code is highlighted in GREEN in the uploaded word document attached to this project. You MUST submit this Code by PM to me and your bid will be considered. Please unzip this file first and read all the requirements before you bid.. Thank you and I look forward to your response.********Thank you and I look forward to working with you |
Import, Export data from my MySQL to MS Excel, MS Wordin the past, so that, input it "by hand" is not a good idea.2/ Some managers from a specific department want a report when they visit our website. So, the code can get the information from database, and make a report for them (in Microsoft Excel and in Microsoft Word). The managers can choose from what date to what date they want to have the report of the projects. They can only get the information of their department. Details we can talk later. |
Web Application with Excel file for Databaseeb site.The Web site will be created by myself using Joomla and MySQL on Linux. Please send me message on the time and cost for this project and explain: 1. In what language/software will you develop this Web interface 2. How the interface will be connected to the Excel files 3. How the Excel files will be updated 4. If you have ever used an Excel file as a database for a Web application 5. Your hourly rate Many thanks in advance. |
Excel, Programming, Data extractionas instructed from both the pdf and the webpage and puts it into an excel sheet- create a program that uses this data and puts it into a preformatted excel sheet provided. TERMS - Payment is on completion, good communication is compulsory To be considered, please include examples of prior work when bidding. I will be happy to offer more information through private message. PLEASE DO NOT BID IF YOU ARE NOT READY TO START IMMEDIATELY! |
Excel/Visual Basic Macro projectdeleted from Worksheet B. Please come up with a quick Macro using Visual Basic that copies lists of customers from worksheet A to worksheet B. But where there is a 0 in the field of worksheet B (where old customer details were kept - the ones that have been deleted), we require customers' details from worksheet A to be added to this available space.The simplest and most elegant solutions to this problem will be considered for this temporary post. Thank you. |
EXCEL Visual Basic Macro programmer needed !!!sic programmer needed for simple data consolidation project and for future collaboration on similar projects.The workbook contains two spreadsheets at the beggining, one introduction, and other one that enables user to insert new "item" (spreadshit) that contains certain information that user needs to fill in. After he finish adding the "items" (spreadsheets), I want to consolidate automaticaly all the data in one single sheet. |
Online Reporting Systemglesyndication.com/pagead/show_ads.js"> |
Additional files submitted:
Visit+Record2.xls
Multiple Choice Questions Prog
data from MS Excel sheet and present it
on my website. The visitor will come and
solve the test and get the ranking online
at once he submits the test. There would
be one question and five answers. There
would be set of twenty questions in each
subject and total 100 questions. There
will be many sets of such 100 questions.
The payment would be made through the
website only.
Press Releases X100
t must be sent in Microsoft Excel Format upon completion.The winning bidder will be whoever can deliver the highest quality in the quickest time.
If successful, I have a lot more work that can be offered.
Must be fluent in English and must have previous experience. Excellent communication is essential.
Please quote SLBS at the top of your bid to show you have read this.
Budget is $ 35 so don't bid above that amount.
Thank You
Text file automation project
Once a month I need cut and paste emails from a notepad text file and drop them into microsoft Excel. I want someone to write a script so that I can automate this process. Basically, I want to press a button and have a script to pick out every email in the document and drop it into Excel.
Word processing - data editing
you can be very clear with what I am expecting when completed.Additional files submitted:
Catalog+sample+GAF.xls
Quickbooks PRO 2006 Daily Export to Microsoft Excel File
I need a program written either in sql server 2008 or something that will work in windows xp that will call a quickbooks pro 2006 file that is password protected and every day pull the inventory that is in stock and export it to an excel file with the fields
-part number
-description
-quantity
Gui Application Development
all these projects in the future which I would eventually like to turn into a freeware toolbox for viral advertising of my consulting services.5. The developer/programmer chosen would also be responsible for future enhancements/upgrades to developed programs on a "lump sum" or "time worked" basis.
Thank you for your interest and I look forward to your proposal/bid at your earliest convenience on the current project.
Kind Regards,
Erik
Need a quote on Copy and Paste Data entry for 100 products
v class="horizontalLine">Additional files submitted:
freelancer+product+entry.csv
forfreelancer.zip
Weight Program
ve the list as an .XLS file (Microsoft Excel) and a Clear All button (would be nice to have a confirmation "Are you sure you want to clear the entire list?" before clearing the list). I would also like the list to autosave once a new item is added to it just in case of a program error. A simple txt or xml file somewhere would be fine.Also, source code will be required upon completion for any edits that might need done in the future.
Any questions please PMB me.
