Hello,
I have an interesting problem I'm hoping one of you fine Freelancers will be able to assist with.
I need to fill out 4 separate templates (the targets Tabs 2 through 5) based off of values found in a Single template (the source in Tab 1).
I think this can be accomplished using a macro of some kind. But the catch is, the macro CAN NOT work off of cell position, I need it to work off of cell contents because the "target" templates come in many variations and today the "TITLE" field (for instance) may be in A4, and tomorrow it can be in A8. Same thing with the source template. Today "TITLE" may be in A2, tomorrow it could be in A6. It really all depends.
One positive factor in this, is they will always be in the same row, only the column may change from one day to another. Also, they are called different things across different templates, so TITLE in the source may be called "MAIN_TITLE" in Target 1, "ProductNAME" in Target 2, etc. etc. To that end, I've already mapped out the fields which your macro would need to match. We're looking at about 17 total (that may increase).
So to take one quick example out of the 17 total. Your macro needs to identify "TITLE" in the Source, copy all cells in that column beneath it into a field called "MAIN_TITLE" in Target 1, then that same info into "ProductNAME" in Target 2, "TITLE" in target 3, and "ShortTitle" in target 4. But as I stated, the columns in which all of these fields exist WILL change in both the source and target, and your macro needs to work off of the field header names, not the absolute position.
It's kind of simple so I don't want to overexplain. I will happily discuss this in more detail with anyone interested.
Name a price, if its fair, I'll select you.
HI,
I am good at Excel VBA. I can find the the relevant columns based on the column mapping. I can take care of the dynamic titles position. Looking forward. Please share the file to refer and work on it.
-Chandra
$150 USD in 0 day
5.0 (1155 reviews)
8.4
8.4
16 freelancers are bidding on average $124 USD for this job
Hi, there!
My name is Paris, and I was glad to see that you're looking for an Excel, and VBA developer. I reviewed your brief and what you ask is straight-forward. I will write the required VBA code myself. I have completed similar tasks hundreds of time in the past. The macro will detect the column based on its name then it will paste the values below it.
I will charge you $130 and can deliver within a day from awarding (a single milestone to release once you're happy with my file).
I'm among the most experienced, and skilled Excel, and VBA developers on this platform. I have completed 267 projects successfully in less than six years, and I feel confident to complete your project as well. You're welcome to visit my page on this platform (https://www.freelancer.com/u/paris2785) and get an idea of who I am and what services I provide to my clients.
I'm online from 8 am to 9 pm daily (including weekends), Athens time. I'm looking forward to working with you.
Sincerely,
Paris Pallas
Hello,
I've done this kind of columns handling and mapping in my projects:
https://www.freelancer.com/projects/Excel/Excel-Database-for-retrieving-web/
https://www.freelancer.com/projects/Software-Architecture/Write-some-software-8244997/
If interested, contact me with a sample of your spreadsheets.
Carlos (aka Grunty)
Hello,
I am a highly rated Excel and VBA developer and can write your required script within 24 hours. Its not difficult to find the title in any of the columns and fill the template accordingly. I am ready to accept full payment once you have tested the functionality. Please discuss via chat.
Thank you,
Usman
Hi
I have rich experience in excel and have worked on many complex projects. I will write an Algorithm to identify the headers from the source header and map it to the target columns in a dynamic manner. I am available to start working now
Regards
HI, I can help you with this interesting project. Taking advantage that the fields are already mapped between source and target sheets, it can be done using a VBA macro.
I was thinking to create a settings sheet in your Excel file where you can place the field mapping, so, if it changes in the future, you can update it easily.
If you like, I can put a button in the ribbon or in the new settings sheet where you can trigger the macro.
I can send you a version of this macro later today.
You can review my profile to check my experience.
Let me know your thoughts
Hello,
I read through the details job post. Would be great if a sample is also shared. I got the requirement. Row Remains same, but the Title will be Dynamic. There are about 17 different expected Title Names which the macro should identify. I have done similar tasks in the past and can start off right now. Can do a small sample for your data if that would help you evaluate my fit for the task. Looking forward to hear from you soon to start off.
Best Regards,
Akila.K
Hi Good Day!
A serious freelancer here!
I can help you to complete this project in 1-2 days. I have a lots of available time for this work, but need to know the full requirements to assess how long would it take to complete every project.
I am a vba macro developer for over 8 years now and has strong knowledge with Ms Excel Formulas and Functions. I created different template and tools for financial reports. I am also a Project Management Analyst that focused in Financial and Metrics report and analyzation.
Feel free to message me to discuss more about this project. Hope you will consider me to this project, I'll promise to give you the high quality of work.
You can check my portfolio for some of my previous project in Ms Excel Macro Thank you!
"Hi,
I have just gone through your project description and reviewed everything. Yes, I’m able to work as per your instructions in your current project and able to provide accurate and quick service. You know! I’m efficient and experienced data entry worker.
If you consider me for this job, I will try my level best to complete your project within our committed deadline. I look forward to hearing from you about the project.
Regards"
It is possible to check the row index in a particular column for the content and particular row can used to pick other columns to pick other required columns.i can share more if you wish
Thank you