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