Excel Sheet to copy data to a second sheet and third sheet.

Completed Posted 4 years ago Paid on delivery
Completed Paid on delivery

I need someone to come up with a macro or formula's that allows me to do the following with 3 excel sheets. Sheet 1 contains my items and all their image links. Sheets 2 and 3 have data of my items, but all the image link columns are empty. I need you to match all my images and their links on sheet 1 to their corresponding products on sheet 2 and 3.

It has to look in sheet 1 starting at column AV, which is an "image name" and then find that image name in sheet 2 which is located in column L of the second sheet. Once it finds the match in sheet 2, I then need it to copy all the corresponding image links from sheet 1 (column AW to column BG) and add them to all the image link columns for that image name in sheet 2.

For Sheet 3, it has to look in sheet 1 at Column A and then match that to Sheet 3 at Column A. Like Sheet 2 I need to add all the corresponding image links

I have attached a small sample so you can see what I need. When your bid is accepted, I will send you the real sheet which has sheet 1 containing 105,000 rows, sheet 2 containing 141,000 rows, and sheet 3 containing over 60,000 rows.

If you can do this for me, please place a bid.

Data Entry Data Processing Excel Excel Macros Visual Basic

Project ID: #20059960

About the project

13 proposals Remote project Active 4 years ago

Awarded to:

AnowarRatul

$ 13 ONLY !!! IN 2 HOURS!! Sir, I have seen your attachment, and understand your requirements very well, it is quite basic to me. I have expertise in Excel, Excel VBA, Pivot Table, Chart, Graph etc. I can assure you More

$13 USD in 1 day
(79 Reviews)
5.0

13 freelancers are bidding on average $29 for this job

muzammil21

Dear Sir, I have read the project description carefully and I’m interested in taking up this task. Please, consider sending a message so that we can discuss the project details more exclusively. Thanks for reading m More

$20 USD in 7 days
(89 Reviews)
6.7
nvchien94

Hello there, I read your attactment and I can create 1 macro to do it for you. Formula or macro is both or but I think macro is better. Please contact me and we can make decision. Thanks.

$35 USD in 1 day
(176 Reviews)
6.2
sultanang464

Hi there, I am highly experienced in copy paste jobs. I am an expert in Copy Typing, Data Entry, Data Processing, Excel and I am really interested in your project. I am available to start working on it now. I work More

$30 USD in 1 day
(130 Reviews)
5.9
rengrish

Hi I went through the project. I have understood the job completely. Need to copy the image url from sheet to 2,3 with different matching criteria for each tabs. Please ping back to discuss and get started right away. More

$50 USD in 1 day
(170 Reviews)
6.0
leemilun

Hi. I have read your description. I'm a Visual Basic developer and until now I did all projects perfectly. Checking my profile, you can see the projects I had done. I can work at anytime with the great satisfactions, q More

$30 USD in 2 days
(12 Reviews)
5.5
RyanHo521

The project looks interesting . I have checked the attached file and understand what to do (actually already start coding). I am a VB expert for over 10 years. I could finish this in 2-3 hours.

$20 USD in 1 day
(1 Review)
2.4
ramesh354

HI SIR GREETING OF THE THE DAY, I AM EXPERT AND EXPERIENCE IN THIS FIELD BECAUSE I AM NOW DOING IN THIS WORK

$25 USD in 1 day
(0 Reviews)
0.0
souravdasgupta29

I can help you with this. It will not take me more than a day to complete this. And I can assure of the quality of the work too. Thanks, Sourav Dasgupta

$25 USD in 1 day
(0 Reviews)
0.0