Vlookup Excel Sheet Update Weekly
$30-250 USD
S-au achitat serviciile după ce au fost prestate
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.
ID Proiect: #1689826
Detalii despre proiect
Acordat lui:
11 freelanceri plasează o ofertă medie de 90$ pentru proiect
this project it is very important for me..please hire me and i finished this for only 36 hours..
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
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.
Excel Expert here. We are interest in your project. Ready to Start. Please Check the Inbox.
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 Mai multe
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 Mai multe