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. -Chandr Plus
19 freelance font une offre moyenne de $123 pour ce travail
****************PRICE NEGOTIABLE************* We can discuss and can fix price. I am ready to create macro.. Please send me excel file so I can check and can get better idea about your problem. I am sure, I can fix Plus
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 co Plus
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 accep Plus
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 availab Plus
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 yo Plus
Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards
Hi, I went through the description. If I could see the templates, it will be helpful to understand better about the pattern of changes, that might occur in the columns. Other than that, I can do the project and can del Plus
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 Plus
am not a random bidder.. Please ping me if you are interseetd with my proposal and share the excel sheet.. thank you..
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 whic Plus
I can help you build a flexible solution to your mapping problem. If something has a pattern or rule, it surely can be automated. Thanks, Simple
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 Plus
"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 eff Plus
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
Hello, I've read your description and I thought that I'm the most appropriate freelancer for this project cos I have more than 3 years of experience in such projects. Well, talking about me, Data-processing is my tale Plus
Hello Sir, I can do your required work and will be able to complete it even in a tough deadline and work will be up to standard. Further terms and conditions will be agreed after the consideration of the project. Thank Plus