Microsoft Excel Programming
Required skills: 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,
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,
Posted In:Data EntryData ProcessingExcel |
Related projects:
Microsoft Excel Expert Wanted To Help On A Project.
Hi,
Microsoft Excel expert wanted to help on a project.
Kindest Regards
Dan
Microsoft Excel expert wanted to help on a project.
Kindest Regards
Dan
Import File From Microsoft Excel To Quickbooks Plus 2010/11
I am looking for someone to import my Microsoft Excel customer listing into QuickBooks Plus 2010/11. This should be a super quick process for the right person. Details MUST be checked for accuracy upon completion.
The successful applicant will quote "PINKY".
The successful applicant will quote "PINKY".
Creating an Microsoft Excel:Mac2011 Routine on a Mac
ters:
9.1) E, cell color red, (E-, E, E+)
9.2) D, cell color red, (D-, D, D+)
9.3) C, cell color red, (C-, C, C+)
9.4) B- cell color red light
9.5) B, cell color blue light
9.6) B+, cell color blue royal,
9.7) A-, cell color green light,
9.8) A, cell color green dark
9.9) A+, cell color green dark.
10) To put a sign / in the cell when the rate of Acc/Dis is going up, (E is the worst and A+ i
9.1) E, cell color red, (E-, E, E+)
9.2) D, cell color red, (D-, D, D+)
9.3) C, cell color red, (C-, C, C+)
9.4) B- cell color red light
9.5) B, cell color blue light
9.6) B+, cell color blue royal,
9.7) A-, cell color green light,
9.8) A, cell color green dark
9.9) A+, cell color green dark.
10) To put a sign / in the cell when the rate of Acc/Dis is going up, (E is the worst and A+ i
Macro that will create two tabs in Microsoft Excel
on the data file to populate the “Program” column on the import tabs.
• The “Grant” column on both import tabs will default to 12345 for all of the associated transactions.
Below are two screenshots of what the import tabs should look like after the macro has been run. These will be the columns that will populate each import tab, and the corresponding data that will match with each transaction from the original data file.
• The “Grant” column on both import tabs will default to 12345 for all of the associated transactions.
Below are two screenshots of what the import tabs should look like after the macro has been run. These will be the columns that will populate each import tab, and the corresponding data that will match with each transaction from the original data file.
Microsoft Excel Database Expert
ceiving lists, contractor will clean lists. Cleaning lists pertains to finding the owner of the property and verifying that the property meets the criteria of the Employer.
Each property will be logged on the excel spreadsheet after the property has been cleaned.
Candidate must have access to the internet and be able to send 2-5 faxes per week.
Skills Required:
Microsoft Excel, internet research, database skills
Each property will be logged on the excel spreadsheet after the property has been cleaned.
Candidate must have access to the internet and be able to send 2-5 faxes per week.
Skills Required:
Microsoft Excel, internet research, database skills
Microsoft Access Microsoft Excel
use one worksheet in your Excel file for each problem. Question 5 should be invoice 1003. For question 4, you should do screen captures (using Control+PrintScreen) to copy the image on your computer and paste it into the Excel file so I can see the steps you took to set up the ODBC."
Part 2: is also done its regarding the project details the only thing that needs to be done is the COVER MEMO.
PART 1: has to be done all.
Part 2: is also done its regarding the project details the only thing that needs to be done is the COVER MEMO.
PART 1: has to be done all.
Expert in Microsoft Excel? We need an Article Writer.
is a long term project so we expect at least 3-5 original Tutorials a day, 5 days a week. We will decide how long you are employed based on your quality of work.
We want you to create 1 demonstration Excel Tutorial before we hire.
Please introduce yourself on the PMB. You will need to simply type out step by step Tutorials along with some image screen shots. You will then post them to our Wordpress site.
Thanks!
We want you to create 1 demonstration Excel Tutorial before we hire.
Please introduce yourself on the PMB. You will need to simply type out step by step Tutorials along with some image screen shots. You will then post them to our Wordpress site.
Thanks!
Microsoft Excel Database Expert
eiving lists, contractor will clean lists. Cleaning lists pertains to finding the owner of the property and verifying that the property meets the criteria of the Employer.
Each property will be logged on the excel spreadsheet after the property has been cleaned.
Candidate must have access to the internet and be able to send 2-5 faxes per week.
Skills Required:
Microsoft Excel, internet research, database skills
Each property will be logged on the excel spreadsheet after the property has been cleaned.
Candidate must have access to the internet and be able to send 2-5 faxes per week.
Skills Required:
Microsoft Excel, internet research, database skills
Microsoft Excel Database Expert
eiving lists, contractor will clean lists. Cleaning lists pertains to finding the owner of the property and verifying that the property meets the criteria of the Employer.
Each property will be logged on the excel spreadsheet after the property has been cleaned.
Candidate must have access to the internet and be able to send 2-5 faxes per week.
Skills Required:
Microsoft Excel, internet research, database skills
Each property will be logged on the excel spreadsheet after the property has been cleaned.
Candidate must have access to the internet and be able to send 2-5 faxes per week.
Skills Required:
Microsoft Excel, internet research, database skills
Need 300 Microsoft Excel Tutorials Added TODAY!
Good morning!
Your job: Search and find 300 Microsoft Excel Tutorials and paste them to my Wordpress blog as new Posts. These must be clear, step-by-step, "how-to" type of Tutorials. Cannot link back to original source.
We are paying $ 30 for 300. The tutorials must be current, informative and high quality. Old pre 2005 tutorials will not count.
WE ARE HIRING TODAY - RIGHT NOW - GO GO GO!
Your job: Search and find 300 Microsoft Excel Tutorials and paste them to my Wordpress blog as new Posts. These must be clear, step-by-step, "how-to" type of Tutorials. Cannot link back to original source.
We are paying $ 30 for 300. The tutorials must be current, informative and high quality. Old pre 2005 tutorials will not count.
WE ARE HIRING TODAY - RIGHT NOW - GO GO GO!
Need 300 Microsoft Excel Tutorials Added to my Blog
orning!
Your job: Search and find 300 Microsoft Excel Tutorials and paste them to my Wordpress blog as new Posts. These must be clear, step-by-step, "how-to" type of Tutorials. Cannot link back to original source.
We are paying $ 30 for 300. The tutorials must be current, informative and high quality. Old pre 2005 tutorials will not count.
WE ARE HIRING TODAY - RIGHT NOW SO STAY ONLINE - GO GO GO!
Your job: Search and find 300 Microsoft Excel Tutorials and paste them to my Wordpress blog as new Posts. These must be clear, step-by-step, "how-to" type of Tutorials. Cannot link back to original source.
We are paying $ 30 for 300. The tutorials must be current, informative and high quality. Old pre 2005 tutorials will not count.
WE ARE HIRING TODAY - RIGHT NOW SO STAY ONLINE - GO GO GO!
Need 300 Microsoft Excel Tutorials - Copy, Paste
Good morning!
Your job: Search and find 300 Microsoft Excel Tutorials and paste them to my Wordpress blog as new Posts. These must be clear, step-by-step, "how-to" type of Tutorials. Cannot link back to original source.
We are paying $ 30 for 300. The tutorials must be current, informative and high quality. Old pre 2005 tutorials will not count.
WE ARE HIRING TODAY - GO GO GO!
Your job: Search and find 300 Microsoft Excel Tutorials and paste them to my Wordpress blog as new Posts. These must be clear, step-by-step, "how-to" type of Tutorials. Cannot link back to original source.
We are paying $ 30 for 300. The tutorials must be current, informative and high quality. Old pre 2005 tutorials will not count.
WE ARE HIRING TODAY - GO GO GO!
Create Microsoft Excel Loan Calculator
tomised Microsoft Excel financial calculator. Basically we will need a loan calaulator with an amortization schedule. Also we would like to be able to have structured payments/option to make extra payments.
We will need the framework built and then we can add in all the other company specific stuff later as thing progress and change.
We will provide a list of other fields we will need such as document fee, stamp duty etc.
We will need the framework built and then we can add in all the other company specific stuff later as thing progress and change.
We will provide a list of other fields we will need such as document fee, stamp duty etc.
Creation of Microsoft Excel 2010 Macro
ex; 8X)
COLOR CHANGES
Hit “CONTROL” AND
Hit "Semicolon" (changes color from black to blue to black to blue, etc)
Hit "Apostrophe" (changes color to black, blue, red, purple, green, white)
DECIMAL CHANGES
Hit “CONTROL” AND
Hit "J" to increase the number of decimal places
Hit "K" to decrease the increase the number of decimal places
COLOR CHANGES
Hit “CONTROL” AND
Hit "Semicolon" (changes color from black to blue to black to blue, etc)
Hit "Apostrophe" (changes color to black, blue, red, purple, green, white)
DECIMAL CHANGES
Hit “CONTROL” AND
Hit "J" to increase the number of decimal places
Hit "K" to decrease the increase the number of decimal places
Microsoft Excel specialist
all prices on same time on that specific category.
(example: if I change the category price on specific cell +20% or -20% all prices only on that specific category will change on same time)
*Important things to consider:
- The price list have 35 different categories (Posters, Flyers, Business cards, Hang tags etc...)
- after job done, please show-me the cells that I should change the percentages.
Thank You
(example: if I change the category price on specific cell +20% or -20% all prices only on that specific category will change on same time)
*Important things to consider:
- The price list have 35 different categories (Posters, Flyers, Business cards, Hang tags etc...)
- after job done, please show-me the cells that I should change the percentages.
Thank You
Web Scraping to Microsoft Excel Cricket
sier on both of us! If this phase of the project is promising there is the chance for more complex and interesting work down the road.
This is a personal project and not business related so the if the cost is too high then the project will sadly be delayed to a time when I can afford it.
Looking forward to working with the lucky collaborator!
This is a personal project and not business related so the if the cost is too high then the project will sadly be delayed to a time when I can afford it.
Looking forward to working with the lucky collaborator!
Microsoft Excel Project
f ebook.
Additional files submitted: (Files are only available for logged in users)
Result_afterConversion.xlsx
Additional files submitted: (Files are only available for logged in users)
Result_afterConversion.xlsx
VBA/Excel Programming For JPEG Image Processing
of information.
I could help you by giving you some examples of the images i want to use for the concept (Attached one image). The format of images will be in JPEG format.
I can offer help at time you want, just to make sure you comply with what i need/want.
If you manage to satisfy my demands, i would be more than happy to pay you what you deserve.
Thank you
I could help you by giving you some examples of the images i want to use for the concept (Attached one image). The format of images will be in JPEG format.
I can offer help at time you want, just to make sure you comply with what i need/want.
If you manage to satisfy my demands, i would be more than happy to pay you what you deserve.
Thank you
Excel Macros And Spreadsheet Project Work
I have a number of tasks that require some excel programming to be written for my business. We use a lot of spreadsheets and there are about 4-5 things we would like to be automated.
I have a preference for people in our timezone (London) as there will most likely be a need for communication to ensure the projects are done properly.
I have a preference for people in our timezone (London) as there will most likely be a need for communication to ensure the projects are done properly.
