Update inventory file in Google Sheets (Merge updated file with source file, flag new, removed, updated)


I need to update Google Sheets with inventory lists. Please provide the fully updated new Master file + provide the formulas to join such files for future updates within Google Sheets.

File A is the original/Master file

File B is the update file

FIle A2 is the original with flagged items

Update File A based on the updates in File B (and A2).

- Update all data in File A if data changed

- Flag removed items in the inventory list

- Add new items and mark them as new

Examples of the files will be provided beforehand on request.

Skills: Data Entry, Excel

See more: populate google doc from spreadsheet, import csv to google spreadsheet script, google sheets import csv from drive, google apps script import excel, mail merge from google sheets to google doc, auto import csv to google sheets, google forms mail merge, google sheets api import csv, Hi, I need a creative logo for a new concept called \ LiveShop\ . It\ s basically a live FaceTime or Skype call from a retail st, I need to build a new website for online shopping. I need the site to have full control of c-panel, picture display on products, script update cell google sheets, php update inventory, update inventory commerce, google flex charts source code, update inventory vba, update inventory separate sheet excel, using csv files update inventory, google maps distance source, update excel google finance, link inventory google

About the Employer:
( 1 review ) Hong Kong, Hong Kong

Project ID: #16070366

34 freelancers are bidding on average $188 for this job


Hi, I am highly interested in your project. I can assist you to update inventory file in Google Sheets. Let's discuss and start. Thanks

$240 HKD in 2 days
(603 Reviews)

Hello sir, we have 8 member team and we can do this job plz send more details so we can start work right [login to view URL]

$200 HKD in 1 day
(463 Reviews)

Hi there. As a professional freelancer I read your full descriptions and willing to updates Google sheet with inventory lists. Plz send your Master file and clean flags and make proper sheet. Looking forward to work More

$130 HKD in 1 day
(68 Reviews)

Hello, Good day! I can complete the project within your specified deadline. You are rest assured of the quality of my work. You can check my profile for review. Thank you.

$200 HKD in 1 day
(57 Reviews)
$340 HKD in 1 day
(64 Reviews)

Hi there, I believe to be a perfect fit to help you Update your inventory file in Google Sheets if you are looking for professional work. Please find below my relevant experience and qualifications for your revie More

$200 HKD in 1 day
(4 Reviews)

I just check the description would be a pleasure to assist you on your project. looking forward to discuss in the chat.

$140 HKD in 1 day
(29 Reviews)

hello. how are you? i am expert of Microsoft Excel, excel VBA and data analyst. i have many years of experience on like these job. i can satisfy every thing what you want in short time. best regard.

$200 HKD in 1 day
(16 Reviews)

Hello Sir, I am a professional web researcher and data processing expert. I will perform accurate data entries and processing to update the inventory file with your specifications and requirements. I will deliver 1 More

$200 HKD in 1 day
(2 Reviews)

i have good command over Ms excel especially pivot table, charts, advance formulas , google spreadsheet as well. Thanks

$200 HKD in 1 day
(6 Reviews)

Available Immediately | Understand ecommerce and inventory | MS Excel Expert | Google spreadsheet master | Working on similar project already | Proven track record | Assured quality of the work

$200 HKD in 1 day
(3 Reviews)

Hi, I have read your job description properly. So I am confident; I can take up your project and do it with perfection. And Please provide me the Example file. Please feel free to contact me for any questions.

$200 HKD in 2 days
(3 Reviews)

A proposal has not yet been provided

$140 HKD in 1 day
(2 Reviews)

I am using ActiveData for excel which is a powerful tool that is why I can make the merge for you. Moreover, I can do a formula for you to bring the data if you don't want me to use the tool

$180 HKD in 1 day
(4 Reviews)

A proposal has not yet been provided

$220 HKD in 7 days
(1 Review)

Expert in SQL, report writing, Database design in Access, Excel, Word, Oracle, My SQL. I did a lot of project on data entry, data processing, data conversion and data convert. I think it is good project for me. If you More

$140 HKD in 10 days
(1 Review)

Hello i’m panji. I was work in IT since 4 years ago. I’m good at excel, fast typer, and data entry. I was intern as data entry in one company. I’ll do my best to exceeds your expectation. Thank you

$290 HKD in 1 day
(1 Review)

Hi (Google Sheets) I read your job carefully.I think I can do this [login to view URL] trust [login to view URL] me a chance to prove myself.

$80 HKD in 3 days
(2 Reviews)

If Experience is the golden factor for this type of project then undoubtedly I am a better fit than others for this job because I have all the qualities which are required by you and most importantly I have a minimum 3 More

$80 HKD in 1 day
(0 Reviews)

I have 3 years in inventory online and offline inventory. I make it sure that physical sales match the sales inventory to system sales. To have an on tract monitoring on stocks

$120 HKD in 1 day
(0 Reviews)