Suljettu

google sheets create lookup sheet for imported excel files

Project name:

google sheets create lookup sheet for imported excel files

Important note **We don't want this in excel, work must be done in google sheet**

This is the process we need to follow

** please note points 1,2 are just for your understanding of how it works in our system**

>

1. PDF is converted to excel file on iMac

2. excel file is uploaded to google sheet - we use apple excel

This is the part you (freelancer) needs to create in google sheets only

>

3. google sheet need to read the excel file we import

4. google sheet needs to read the product ID ie SBALB5 (I can provide a list of all products IDS if needed for a lookup sheet) SBALB5 in stock or out of stock (we have a seperate google sheet to show in stock and out of stock product ID)

- if in stock leave > if out of stock, drop down box shows suggested product substitutes from the other colours available in product style ie red out of stock, dropdown shows blue, black, grey

> select product ID from drop box to populate / replace imported out of stock product id

5. Need to add total sales and how many pcs sold > records totals on other google sheet

6. New sheet to record which product ID have sold > everytime a new excel sheet is imported it records the product ids after above process has occurred on a new google sheet

> for example 55pcs of SBALB5 since date 1st JAN 2019

> Need products to be in order example BS1, BS2, BS2, RE1, XT2, XT9

7. Once all above is finalised in the process, it will then save in a folder on google drive and we will be able to search for customer order by name, order number

> This can be saved on one page or seperate sheets in google saved file

I have attached current out of stock google sheet row example - this is for point 5 above

- Green box is for total sales for the day

- pink box is for total products sold for the day

Second file attached showing our in stock and out of stock

- Green cell in stock

- Red cell out of stock

Taidot: Excel, tiedonsyöttö, tietojenkäsittely, Google Sheets, Excel Macros

Näytä lisää: create excel files mysql, can excel files project works, create data sheet web excel, link excel sheet to google sheets, google sheets importrange, google sheets lookup from another workbook, how can i get google sheets to auto update a reference to another sheet?, google sheets reference another workbook, google sheets import data from another sheet, google sheet link, how do i pull data from another sheet in google sheets?, create data sheet supply excel, create access database using excel files, create access database multiple excel files, how to autofill same cell from different sheets to a sheet in excel?, how to copy data from multiple sheets to one sheet in excel, vlookup in google sheets from another sheet, google sheets lookup another sheet, google sheets api create new sheet, vlookup google sheets reference another sheet

Tietoa työnantajasta:
( 5 arvostelua ) Bangkok, Thailand

Projektin tunnus: #21735087

23 freelanceria on tarjonnut keskimäärin 76$ tähän työhön

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl Lisää

$90 AUD 2 päivässä
(331 arvostelua)
8.0
c4cuteconain

I am a professional with a decade of experience working in a US based NASDAQ registered company with all the skills and knowledge required for your project. Please send me a message and we can move forward with your pr Lisää

$50 AUD 1 päivässä
(69 arvostelua)
5.8
sonarkaushik

Sir,      I am well versed in these kind of jobs and can do your project as per requirement. **I am ready to start Waiting to hear from you. Regards

$88 AUD 3 päivässä
(101 arvostelua)
6.2
$60 AUD 1 päivässä
(52 arvostelua)
5.5
razvancotofana

Hello, I am google sheets professional and I would be happy to assist you with your project. Please send me a message so that we can discuss in details your requirements. Looking forward to hearing from you, BR, Razva Lisää

$90 AUD 7 päivässä
(18 arvostelua)
5.3
Logo199

I have total 7 years of working experience in process mapping , process documentation , data entry , data analysis and expert in MS office application including MS word , MS powerpoint , MS excel , Photoshop , Adobe Lisää

$70 AUD 1 päivässä
(35 arvostelua)
5.0
wkcompany

Hi, I am ready to start right away. I'm an expert in Data Entry. I have reviewed your job description as well and very confident to handle this project perfectly. I understood your all requirements. I have done many p Lisää

$70 AUD 1 päivässä
(50 arvostelua)
4.8
writingapp

Hi. I am ready to write your project Write apps on your demand in many languages (Visual Basic, VBA, VBS, .NET, C#, JS, Python, Java, PowerShell) Write database apps including many db formats: MS Access, MS SQL, SQL Lisää

$85 AUD 2 päivässä
(17 arvostelua)
4.4
vssolinc

Hello sir, hope you are doing good. i have a great experience in google sheet by putting the stock data and arranged in different columns by product id. I would like to start your task right now and finish it as soon a Lisää

$60 AUD 2 päivässä
(3 arvostelua)
2.8
RavenSolutions

I checked your project: google sheets create lookup sheet for imported excel files and I am totally sure that I am able to accomplish it ! I am very good at Data Entry, Data Processing, Excel, Excel Macros, Google Shee Lisää

$80 AUD 1 päivässä
(2 arvostelua)
2.9
ravinderkumar248

Hi there, I read your requirements and understand very-well and ready to start work from now. Hope you give me a chance to do work with you. I hope you will be kind enough to consider me for your [login to view URL] forw Lisää

$50 AUD 1 päivässä
(3 arvostelua)
1.8
mohanasundarik24

Dear, I am ready to start right away. I'm an expert in Data Entry. I have reviewed your job description as well and very confident to handle this project perfectly. I understood your all requirements. I have done many Lisää

$70 AUD 2 päivässä
(3 arvostelua)
1.5
umairali8062

I have read your project and I am expert in this field. I can do this for you within due time and honestly. I also have a few questions to discuss. Kindly contact me and we will discuss time and budget. Thanks

$70 AUD 7 päivässä
(2 arvostelua)
1.6
dervish11

Hello I am highly interested to work with you on this project and can assure you quality results. Thank you

$50 AUD 1 päivässä
(2 arvostelua)
0.3
plabonlancer

Hello there I am interested to do this project for you, Let's discuss about it. I can start now. Thank you.

$70 AUD 7 päivässä
(0 arvostelua)
0.0
Amrinder07

Let's work

$55 AUD 10 päivässä
(0 arvostelua)
0.0
jinjinwu

( ͡ᵔ ͜ʖ ͡ᵔ ) Hi, Dear. I saw your posting with interesting. I have experience with your request skills. So I think I can solve your project asap I will wait for your response. Kindly regards.

$200 AUD 3 päivässä
(0 arvostelua)
0.0
khlfaisalabedin

Warm Greetings, Thank you very much for reading my cover letter. I am ready to do this now, Best Regards Faisal

$50 AUD 30 päivässä
(0 arvostelua)
0.0
TshebedisoM

Hi I have read the requirements and I will be delighted to be given the honor to deliver your work not only on time but will be accompanied by accuracy and professionalism.I have great-vast knowledge with Excel and goo Lisää

$75 AUD 4 päivässä
(0 arvostelua)
0.0
widepattern

( ͡ᵔ ͜ʖ ͡ᵔ ) Hi, Dear. I saw your posting with interesting. I have experience with your request skills. So I think I can solve your project asap I will wait for your response. Kindly regards.

$90 AUD 4 päivässä
(0 arvostelua)
0.0