Google spreadsheet compare value columns and past third fix

Completato Pubblicato 6 anni fa Pagato alla consegna
Completato Pagato alla consegna

Hi,

We have a Google Spreadsheet with 2 tabs. We have to copy new prices into our system, but we can't do it one by one since it's about 2500 products.

[url removed, login to view]

We need the following to be fixed:

We need the new prices of our supplier matched to the article number, and copy paste the right amount into the new columns.

IT WORKS LIKE THIS:

WHEN a field in column A 'ItemNo' of Tab 1 (Listing) matches a field in column B 'ItemNo' in Tab 2 (New prices) THAN the matching prices of column B and C of Tab 1 (Listing) should be copy pasted into the pricing columns B and C of Tab 2 (New prices).

It can be empty when there is no match.

Can someone fix this for us?

Column Installation Excel PHP

Rif. progetto: #15365636

Info sul progetto

15 proposte Progetto a distanza Attivo 6 anni fa

Assegnato a:

Anasra

Ok i understand it require a formula just need to take a look at your files. Kindly consider me for this job . Thank you

$10 USD in 1 giorno
(43 valutazioni)
5.1

15 freelance hanno fatto un'offerta media di $22 per questo lavoro

sohandas

i will try to fix it using VBA if failed then will do manually................is that ok for you?pm please for further discussion!

$20 USD in 1 giorno
(127 valutazioni)
6.3
oadsmedia

!!! Honor !!! We Can Help You Make That Happen !!! Let's discuss..................................

$25 USD in 1 giorno
(49 valutazioni)
5.7
Programmer59

yes I can fix that issue if you want I can start form now thank you ............................../.

$25 USD in 1 giorno
(38 valutazioni)
5.5
renesontiongson

Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much.

$25 USD in 1 giorno
(62 valutazioni)
5.2
Developer000

NO AUTOMATIC BIDDING........................ I am here freelancer first to discuss the details then i can sure about my price and the deadline. My way of working is not only to complete but also to provide enough u Altro

$25 USD in 1 giorno
(13 valutazioni)
4.5
mastanraja

I will do this project with less Price high accuracy rate I will give you 100% assurence to your project result. I have good experience in this work so give me a chance I will prove myself I will do with less p Altro

$15 USD in 1 giorno
(3 valutazioni)
1.1
vipingfreelancer

Hello, i will do it in 4 hours because i have good data entry skill and very fast in copy paste

$13 USD in 1 giorno
(1 Recensione)
0.0
shalinimmanuel

I am very good in data entry, writing, verifying information, analyzing errors, and managing confidential information. I am also deeply familiar with MS Excel & adapt quickly to new programs Relevant Skills and Experi Altro

$25 USD in 1 giorno
(0 valutazioni)
0.0
nwiforemmanuella

I work with excel and i have good internet process this task. I will deliver the work accurately. The project requires that I transfer the data on the spreadsheet into your database. milestone: copy and paste?typ Altro

$17 USD in 1 giorno
(1 Recensione)
0.0
shahididewitness

I have a degree in IT and excellent mastery of Office applications. I will meet your expectations in record time

$25 USD in 1 giorno
(0 valutazioni)
0.0