Käynnissä

Vlookup Excel Sheet Update Weekly

Need an excel expert to finish build vlookup function on an existing file (75% done) that I can update weekly.

What's done on the sheet (75%):

1st tab: Magento sku master sheet (will send through email first and then be updated weekly)

2nd tab: Store inventory master sheet (will send through email first and then be updated weekly)

3rd tab: Sales report by week (will send through email first and then be updated weekly)

4thd-20th tab: Already built with headers of "sales rank, unit rank, sku id, stock code, bar code, sku description, retail, cost, margin%, manufacturer, status, inventory qtys& follow by 52 columns of 52 weeks of 2012)

This person will use the first two master sheets and continue building all vlookup function on to make sure all cells can be updated from these two sheets weekly.

What's not done (25%):

Using the 3rd tab to update "qtys sold by week" under the 52 weekly column by sku.

Lastly, update sales rank, unit rank under each tab.

All applicants must attach an existing excel file with vlookup function to be reviewed before being consider.

I will pay 50% upfront and 50% after receiving the final files.

After I select the winner, I will send all files via email. Please complete this task within 7 days.

Taidot: Excel

Näytä lisää: vlookup excel, vlookup weekly update, finish master, file status 22, file excel expert, excel weekly update, excel sales report vlookup, master excel, excel sheet expert, weekly, Vlookup, update store, stock update, sku inventory, sheet, send email excel, sales sheet, sales excel, report from excel, excel vlookup, excel sheet an, Excel report, excel inventory, excel function, excel expert

About the Employer:
( 27 reviews ) Lewisville, United States

Projektin tunnus: #1689826

Myönnetty käyttäjälle:

selopezr

Hello there! Nice project! Count on me! All the best to you.

30 $ USD 3 päivässä
(14 arvostelua)
4.1

12 freelanceria on tarjonnut keskimäärin 85 $ tähän työhön

FINGERRPRINT

Excel Expert here. We are interest in your project. Ready to Start. Please Check the Inbox.

200 $ USD 5 päivässä
(56 arvostelua)
6.3
nagybatonyi

Such jobs are my daily practice. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Fixing of bugs and minor changes Lisää

120 $ USD 5 päivässä
(40 arvostelua)
5.6
himanshuhc

Hi, I have a 100% completion rate & would love to provide you with a WORKING SAMPLE for you to evaluate, perhaps making it easier for you to decide between bids. I would like to request for some details in order to do Lisää

75 $ USD 2 päivässä
(13 arvostelua)
4.3
expertatwork

We are a team of 2 having a vast experience on excel VBA scripting. Looking forward to work with you. thanks !!! Please have a look at our message in your PMB.

30 $ USD 5 päivässä
(16 arvostelua)
3.6
rohitpithisaria

Hi.... I would like to apply for the job.

80 $ USD 7 päivässä
(7 arvostelua)
3.5
momo2619

Dear Sir, Please read my PM.

50 $ USD 1 päivässä
(5 arvostelua)
2.8
Dilipjaipur

Hi, pls check PMB, thanks.

30 $ USD 1 päivässä
(5 arvostelua)
2.7
askPaul

Look no further - I'm THE EXCEL WIZARD! I can do VLookups in my sleep. I will finish the 25% fast. But more...I will encode the lookups to be dynamic so that the weekly updates can be done automatically. VLookup Exampl Lisää

150 $ USD 6 päivässä
(2 arvostelua)
2.2
williamoston

this project it is very important for me..please hire me and i finished this for only 36 hours..

30 $ USD 2 päivässä
(0 arvostelua)
0.0
chooy

I am very familiar with excel. I have always worked with Excel for over 2 years in government projects. And now I want to work independently. Regards

200 $ USD 6 päivässä
(0 arvostelua)
0.0
henrykristian

send the file, i will see it first

30 $ USD 3 päivässä
(0 arvostelua)
0.0
permana78

Hello, I am very much interested on your project. I have read your requirements and I am quite confident that I will be able to get your work done within the given time.I am very keen to discuss further. You can reach Lisää

30 $ USD 1 päivässä
(0 arvostelua)
0.0