Terminé

Excel Macro Needed for project

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.

Compétences : Excel, Visual Basic, Visual Basic pour les apps

en voir plus : excel macro needed, excel macro project daten importieren, excel macro protect project, excel vba projects free download, excel macro examples download, excel macro tutorial for beginners, useful excel macros examples, macros in excel for beginners, cool vba projects, excel vba projects for practice, excel macro tutorial pdf, excel macro read microsoft project, excel macro import project files, excel macro html source code, excel macro call project, excel macro programmer needed, project excel macro, macro export project report excel, export project excel macro, macro import project excel

Concernant l'employeur :
( 24 commentaires ) Newark, United States

Nº du projet : #18213325

Décerné à:

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 Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 0 jours
(785 Commentaires)
7.8

19 freelance font une offre moyenne de $123 pour ce travail

Webxpert4u

****************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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(195 Commentaires)
7.7
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(172 Commentaires)
6.9
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(88 Commentaires)
7.0
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(291 Commentaires)
6.3
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(47 Commentaires)
6.0
rinabuoy13

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(55 Commentaires)
5.6
nwss1986

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(82 Commentaires)
5.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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(36 Commentaires)
5.5
vmadhavan15

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(23 Commentaires)
4.8
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(37 Commentaires)
4.9
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(27 Commentaires)
4.1
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(16 Commentaires)
3.5
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(15 Commentaires)
3.4
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(4 Commentaires)
2.9
C3guru

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
0.1
thenabeel

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0