Find Jobs
Hire Freelancers

Convert a Table into Multple Work Sheet

$30-250 CAD

Completed
Posted over 11 years ago

$30-250 CAD

Paid on delivery
I have a List of Customer Price List Table ( Which can be changed and it can be 5000 Lines Long) I need a SQL (Or VBA programm) or anything which works. On any change in the Company Information the Program has to generate a Price Letter using the Templete provided. ( Location details to save the Price Letter to be asked before doing it) A company can have multiple Products. New Letter to be created once the company name changes. I have attached the Price Templete and a Data Table. Let me know if you need more details.
Project ID: 2657294

About the project

11 proposals
Remote project
Active 11 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
We are a team of 2 having a vast experience on excel VBA scripting. Looking forward to work with you. thanks !!! Please have a look at our message in your PMB.
$65 CAD in 2 days
4.8 (215 reviews)
6.2
6.2
11 freelancers are bidding on average $109 CAD for this job
User Avatar
dear sir please check pm
$100 CAD in 1 day
4.9 (106 reviews)
6.8
6.8
User Avatar
Hi, Ready to start your work. Eagerly awaiting for your positive reply. Please check your inbox for further details. Thanks, Shaik.
$79 CAD in 5 days
5.0 (30 reviews)
4.7
4.7
User Avatar
I have over 25 years of experience and am ready to begin today. Please see PM for more details.
$150 CAD in 5 days
5.0 (13 reviews)
4.3
4.3
User Avatar
Hi sir , My name is Luigi Widmore and i'm an expert web developer. My areas are HTML/CSS PHP/MYSQL Design/Photoshop. I can complete this project in 4 days or less. Please check PM for details , you may be impressed. Thank you
$130 CAD in 999 days
5.0 (8 reviews)
3.8
3.8
User Avatar
Hello. My name is Shaun R., business consultant, Excel guru, and admin of a popular Excel website. I would be happy to create a VBA macro that would automate the process of creating the formatted output sheet (Price Letter) from the "DATA sheet" data. To be sure I understand the scope correctly, for each "company" listed in the "DATA sheet" data, you want to create a "letter sheet" filled in with the details from the "DATA" sheet, corresponding to each company. You also want a prompt upon completion of the "Letter" sheet which would allow you to save the letter in a location/name you select upon completion. If interested, please provide more detail as to exactly what you would like done (as well as the necessary files to do so) and I would be happy to get started early, prior to you selecting me as your provider for this project, allowing you a preview of the quality of my work, as well as providing further assurance that we are on the same page regarding the required output and time-frame for delivery of completed items. I am also available to start immediately. My credentials are listed below. BA - Business Administration - Accounting major, and approx. 14 years experience using Excel, including developing a variety of historical/proforma budgeting/forecasting/charting/graphing/pivot-table options, as well as a variety of VBA macros to automate tasks and analyze information From user entry pop-up windows, to looping through excessive data sets, making comparisons/calculations of dynamic and/or ever-changing data, copying/pasting, merging and providing formatting and/or graphical output based off of this analysis, I have the ability to program functions/formulas that go far beyond the basic capabilities of Excel. Most deliverables are completed in 1 week, usually just a few days (sometimes same-day, which would be very likely in your case), and if for any reason you are not satisfied with the work provided, I offer to refund any amount reasonably agreed to as unearned by unsatisfactory work, up to 100%, so there is absolutely no risk for you. Please feel free to visit my freelancer.com profile page to get to know a little more about me and/or view relevant work samples/experience as I assure you that you will like what you see. Thank you greatly for your consideration and I hope to hear from you very soon. Shaun R. XCNetworks
$100 CAD in 1 day
5.0 (1 review)
3.5
3.5
User Avatar
Hi I am proposing a solution using Excel VBA. Please clarify: for company ABCDEF, we have two delivery terms FOB and DEL. There is only one entry in the letter template. Similarly, Price Effective and Expiry dates, there are 3 against 1 slot. Also there are 2 names to insert into one slot. I have no issue with other requirement please.
$75 CAD in 3 days
5.0 (7 reviews)
3.2
3.2
User Avatar
Hi Sir, Please check pm.
$120 CAD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi there I've worked as a developer for more than 12 years using several kind of languages. I can help you with this Kind Regards Vasco Lopes
$50 CAD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
Mississauga, Canada
5.0
7
Payment method verified
Member since Nov 18, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.