Detailed Automated Excel file

进行中 已发布的 Aug 8, 2013 货到付款
进行中

I would like to have a file that allows me to enter sales data on a daily basis. This file should be as automated as possible with limited to no typing involved. Drop down menus, and check mark boxes should be available as an alternative to manual data entry.

Tab 1: Sales entry point

Tab 2: Real Time inventory Updates

Tab 3: Detailed, granular sales data - ultra sortable day/week/month by product or by account etc etc

Tab 4: Bar graph illustrating sales history/profit. ultra sortable to view sales trends by product, account, or by date (week/month/year).

File should have a user friendly graphical interface where I can enter in products, dates, value associations with each pull down option. Product/pricing change so I should be able to change values easily.

Build from scratch is not required.

If you have an existing template that you can modify to include my requirements I am open to that as well.

Excel 微软Access MySQL

项目ID: #4807223

关于项目

5个方案 远程项目 活跃的Aug 8, 2013

有5名威客正在参与此工作的竞标,均价$6/小时

maverick44000

Hi there. Being highly proficient in Excel, I should be able to get it done as you desire. Regards

$11 USD / 小时
(76条评论)
6.9
DeepSyaal

Lets Start. Having a team of Professionals.

$5 USD / 小时
(204条评论)
6.5
farr4u

Hi, VBA expert here ready to start, plz see pm for DEMO.

$6 USD / 小时
(44条评论)
5.5
nikitasvw

Hello, I can make such template.

$5 USD / 小时
(58条评论)
4.2
roxavishka123

I do this project correctly

$5 USD / 小时
(0条评论)
0.0