Google spreadsheet compare value columns and past third fix
$10-30 USD
Paid on delivery
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?
Project ID: #15365636
About the project
Awarded to:
Ok i understand it require a formula just need to take a look at your files. Kindly consider me for this job . Thank you
15 freelancers are bidding on average $22 for this job
i will try to fix it using VBA if failed then will do manually................is that ok for you?pm please for further discussion!
!!! Honor !!! We Can Help You Make That Happen !!! Let's discuss..................................
yes I can fix that issue if you want I can start form now thank you ............................../.
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.
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 More
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 More
Hello, i will do it in 4 hours because i have good data entry skill and very fast in copy paste
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 More
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 More
I have a degree in IT and excellent mastery of Office applications. I will meet your expectations in record time
