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

Tietoa työnantajasta:
( 27 arvostelua ) Lewisville, United States

Projektin tunnus: #1689826

Myönnetty käyttäjälle:


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

$30 USD 3 päivässä
(20 Arvostelua)

11 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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)

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ä
(4 arvostelua)

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)

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ä
(144 arvostelua)

send the file, i will see it first

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

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

$200 USD 5 päivässä
(182 arvostelua)

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

$80 USD 7 päivässä
(102 arvostelua)

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)

Dear Sir, Please read my PM.

$50 USD 1 päivässä
(6 arvostelua)

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ä
(62 arvostelua)