Hi, we are an automotive data company that publishes used car values. We maintain Excel spreadsheets showing all the vehicles we list and the values for each year. Between the columns we calculate the difference in price year-to-year. The Excel sheets are populated where we want the values to show up with our unique six digit ID's. We have two Access db's with tables containing these 'GUID's' and the current values of the vehicles. We publish two values for each vehicle, a 'Trade-In value' and a "Market Ready value', so we would like the ability to select which one we want to use to populate the sheets.
"[login to view URL]": contains our regular prices that we publish
"Projected [login to view URL]": contains our preliminary 'working' prices not quite ready for publication
Here's how we would like the process to work:
We open a macro and it asks us which Excel sheet we would like to use, so we would specify for example "For_Analysis"
It would then ask "Use Trade-in or Market Ready values?"
If we specify 'Trade-in', the six digit GUID's in the For_Analysis sheet would be replaced with either galves_partner/Vehicles/ph_cprice OR Projected values/Proj_GUID/ph_pprice.
If we specify 'Market Ready' the six digit GUID's in the For_Analysis sheet would be replaced with either galves_partner/Vehicles/ph_price2 OR Projected values/Proj_GUID/ph_price2.
When analyzing the data in the populated Excel sheets, it is very important to know whether a value came out of the [login to view URL] or the Projected [login to view URL] so we would like ANY VALUE(ph_pprice or ph_price2) THAT COMES FROM PROJECTED [login to view URL] TO HAVE ITS CELL SHADED IN LIGHT BLUE, this way we can easily tell that it is a projected value. This is a must-have feature.
It is worth noting that each GUID should have values in only ONE of the two Access db's, but accidents are possible so if a GUID has populated values in both mdb's, would it be possible for the macro to issue a warning maybe? That would be helpful but not required.
We will run this macro frequently, so I would think the best practice would be to maintain the original worksheet with the GUID's and have the macro create a second, populated worksheet with the current values. This second sheet would be OK to be overwritten each time the macro runs, we have no reason to archive each running of the macro.
The attached files are abbreviated versions that contain BMW vehicles only. The complete files we will be using are much larger and contain ALL manufacturers. We also have an Excel file called 'AMER_analysis' that we use for American made vehicles, so that would be the third Excel sheet we would need to specify the macro to work with.
I hope I have explained things clearly, please let me know if you have any questions.
Thanks!
Thank you for contacting me. Half is already done, meaning all the Trade-In related, including the initial question (trade in vs market value), the blue cells etc.
Relevant Skills and Experience
I included a beautiful summary dialog box that specifies how many prices were retrieved from Galves Partners, from Projected Values, how many ambiguities were found and how many ph_guid didnt match.
Proposed Milestones
$111 USD - Excel Macro with Access DB Connection
you can see a Printscreen in your messages. I really hope you like it.
$111 USD 2 päivässä
5,0 (13 arvostelua)
5,7
5,7
17 freelancerit tarjoavat keskimäärin $251 USD tätä projektia
Greeting,
I have understood your Excel Macro task and can do it with your 100% satisfaction. Please ping me for more discussion.
Relevant Skills and Experience
I have more than 5 years of experience in Data Processing, Excel, Microsoft Access, Visual Basic, Visual Basic for Apps
Proposed Milestones
$250 USD - Excel Macro
Hi, my name is Sevinc.
I read your "Excel Macro" project descriptions carefully before bidding. I checked the attached sample worksheets as well... I got what you need and ready to go ahead.
Relevant Skills and Experience
I am 5-star excel and vba coding expert here at freelancer.com. Pls check my profile and feedbacks first to have some idea about the quality of my previous businesses.
Proposed Milestones
$250 USD - after delivery
Hello, I’m an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
Stay tuned, I'm still working on this proposal.
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros.
Check my reviews.
Best regards
Relevant Skills and Experience
VBA/Databases
Proposed Milestones
$250 USD - final delivery
Hello, we are certified and experienced excel experts, we created these kind of excel sheets, from the last 15 years we are successfully delivering more complex methods in a simple way.
Relevant Skills and Experience
excel
Proposed Milestones
$750 USD - milestone
Stay tuned, I'm still working on this proposal.
Develop a VBA program in Excel to select one of 2 Access tables and import data, then finding the differences in prices from previous years and marking the GUIDs in color based on the origin table.
Relevant Skills and Experience
I have 17+ years experience working with Excel/Access VBA and 13 years teaching them (all levels). I can certainly do excellent work with your project.
Proposed Milestones
$120 USD - Initial milestone
$120 USD - Project completion
Hi, there
I can code your current project via Ms Access software
Relevant Skills and Experience
I'm programming in Access/SQL/VB since 1997
Proposed Milestones
$250 USD - default
Hello Sir,
hope you are having a good holiday time.
I can meet your requirements in no time but rather that a user prompted interaction I can project a simple button with otpions selectable.
Relevant Skills and Experience
Ecel formulae and macros, sheet design and data graphing.
Proposed Milestones
$66 USD - job completed