Excel Macro Needed for project
$30-250 USD
Πληρώθηκε κατά την παράδοση
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.
Ταυτότητα Εργασίας: #18213325
Σχετικά με την εργασία
Ανατέθηκε στον:
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 Περισσότερα
16 freelancers κάνουν προσφορές κατά μέσο όρο $124 για αυτή τη δουλειά
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 Περισσότερα
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 Περισσότερα
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 Περισσότερα
Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards
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 Περισσότερα
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 Περισσότερα
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 Περισσότερα
am not a random bidder.. Please ping me if you are interseetd with my proposal and share the excel sheet.. thank you..
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 Περισσότερα
"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 Περισσότερα
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
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