Excel Merge

$30-250 USD

已完成

已发布

大约 12 年前

$30-250 USD

货到付款

I have inventory data being pulled from Quicken Enterprise into three spreadsheets, 1st sheet "Inventory" contains the inventory item (unique key field), inventory location, qty of on hand inventory. 2nd sheet "Sales" contains inventory item (unique key field), sales qty by month subtotaled by location. 3rd sheet "Purchase Orders" contains inventory item (unique key field), qty of item on order, vendor name, and date of ETA. I need to combine data into one spreadsheet that combines all information for each inventory item with two calculated columns that take an start date and end date, calculate the number of weekdays including holidays between the start and end date, and then to calculate the average daily sale of each item and the days of inventory on hand.

Excel

项目 ID: 1486278

关于此项目

52提案

远程项目

活跃12 年前

想赚点钱吗？

电子邮箱地址

在Freelancer上竞价的好处

设定您的预算和时间范围

为您的工作获得报酬

简要概述您的提案

免费注册和竞标工作

颁发给：

@shagoon2u

Please see inbox.

$40 USD 在3天之内

4.5

(5条评论)

4.0

52威客以平均价$68 USD来参与此工作竞价

@best4best

I am an Excel expert. I have gone through the 3 files and can merge the data as required.

$50 USD 在2天之内

5.0

(148条评论)

6.4

@pandeypriya2003

hello sir, lets contact on pm

$110 USD 在2天之内

4.8

(50条评论)

6.1

@nagybatonyi

Such jobs are my daily practice. Fixing of bugs and minor changes are included in the bid without any additional fees. Regards!

$90 USD 在2天之内

4.9

(64条评论)

5.7

@Krusche

Hello. We are a team of professionals developing Excel applications based on the VBA programming. Please check your inbox for examples

$120 USD 在1天之内

4.9

(21条评论)

5.0

@faialeem

Please check your PM for Sample and other detail

$70 USD 在2天之内

4.8

(26条评论)

4.6

@Nhcuong

i can do it!

$50 USD 在1天之内

4.7

(21条评论)

4.8

@psprongs

I have extensive experience in data processing using excel. I can start immediately.

$65 USD 在1天之内

5.0

(11条评论)

4.5

@kulhanekd

I have 15 years exp in excel. I can merge all the spreadsheets for you and create the formulas you need. Thanks Donna

$75 USD 在1天之内

4.7

(10条评论)

4.3

@pyazlm

I can provide a script in Excel VBA.

$45 USD 在3天之内

4.8

(30条评论)

4.4

@JJdatajobs

Hello 'yrofdragon', I am submitting my detailed bid, along with Sample-Work. Kindly review the same. Thank you very much.

$90 USD 在3天之内

5.0

(16条评论)

4.0

@Midlander

The samples in the Excel file in my portfolio on this site shows I have the skillset to provide the solution you need. You will get twenty years' expertise in using databases and designing spreadsheets to summarise and analyse the data. There is no VAT on my bid, I am happy to sign a Confidentiality and Non Disclosure Agreement if required and can start immediately. Most of my career has been in 'stand alone' roles and I have both worked in and led virtual teams. I am therefore used to remote reporting lines and delivering objectives on time and within budget. Hope you find this of interest and look forward to hearing from you. Bob Allen-Turl

$81.48 USD 在1天之内

4.6

(11条评论)

4.5

@microk

VBA expert here.. Please check PM..

$60 USD 在1天之内

4.9

(27条评论)

4.3

@FLtowhid

Please see my PM.

$40 USD 在5天之内

4.8

(4条评论)

3.8

@srdas2012

We are Experts in Data Entry,We can do very Accurate work,Please see Private Message.

$40 USD 在3天之内

5.0

(6条评论)

3.2

@ifaisal

Hello I can do this for you. I have expertise in MS Excel and Macros. I have done many similar projects in the past. I can do it quickly and accurately and you do not have to make any payment until you are completely satisfied. Please see my feedback and profile. Regards Faisal

$150 USD 在2天之内

5.0

(2条评论)

2.9

@dilshz

Hi consider the job is done

$100 USD 在2天之内

5.0

(3条评论)

2.5

@Suri1

Dear DRAGON, As I have gained much knowledge about EXCEL formulas and functions I would like to bid on your project. Please check PM for further details. Regards

$50 USD 在2天之内