Excel Macro Needed for project

Ολοκληρωμένο Αναρτήθηκε Πριν 5 χρόνια Πληρώθηκε κατά την παράδοση
Ολοκληρωμένο Πληρώθηκε κατά την παράδοση

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.

Excel Visual Basic Visual Basic για Εφαρμογές

Ταυτότητα Εργασίας: #18213325

Σχετικά με την εργασία

16 προτάσεις Απομακρυσμένη εργασία Ενεργό Πριν 5 χρόνια

Ανατέθηκε στον:

cgullapalli

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 Περισσότερα

$150 USD σε 0 μέρες
(1155 Αξιολογήσεις)
8.4

16 freelancers κάνουν προσφορές κατά μέσο όρο $124 για αυτή τη δουλειά

paris2785

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 Περισσότερα

$130 USD σε 1 μέρα
(493 Αξιολογήσεις)
8.4
Grunty

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 Περισσότερα

$120 USD σε 3 μέρες
(59 Αξιολογήσεις)
7.7
maverick44000

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 Περισσότερα

$160 USD σε 1 μέρα
(94 Αξιολογήσεις)
7.1
rinabuoy13

Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards

$122 USD σε 3 μέρες
(124 Αξιολογήσεις)
6.6
rohitagarberg

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 Περισσότερα

$100 USD σε 3 μέρες
(426 Αξιολογήσεις)
6.7
diorisaguilar

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 Περισσότερα

$90 USD σε 3 μέρες
(65 Αξιολογήσεις)
6.4
AkilaArun

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 Περισσότερα

$80 USD σε 1 μέρα
(54 Αξιολογήσεις)
5.7
vmadhavan15

am not a random bidder.. Please ping me if you are interseetd with my proposal and share the excel sheet.. thank you..

$250 USD σε 3 μέρες
(28 Αξιολογήσεις)
5.0
paulodayto08

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 Περισσότερα

$50 USD σε 2 μέρες
(77 Αξιολογήσεις)
5.4
dataexplorer

"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 Περισσότερα

$150 USD σε 5 μέρες
(18 Αξιολογήσεις)
4.3
Simplesolz

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

$40 USD σε 2 μέρες
(27 Αξιολογήσεις)
4.1
nishantha041

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

$60 USD σε 2 μέρες
(4 Αξιολογήσεις)
2.9
$83 USD σε 2 μέρες
(0 Αξιολογήσεις)
0.0