Completed

Create an Advanced Excel Spreadsheet Using Info From Another Sheet

Hi,

I am looking for someone with plenty of Excel experience to create a working spreadsheet for me.

Currently my warehouse logs each days sales of each product (both website sale and retail) in a new column.

In order to help me predict my stock levels and furture manufacture orders I would like to use this info to create a new spread sheet that does the following:

- Tally’s up how many of each product is sold each week (both website sales and retail, plus over all total)

- Looks at the current total stock to hand – divides it by the average number of product sold per week (agrigated) and estimates how many weeks stock we have to hand.

- Takes into account Cost of Goods – subtracts from both website sales and retail sales, so I can easily see how much each weeks sales have cost me and what the gross profit is on those sales.

I would love to be able to easily see those 3 bits of information, across 3 different sheets on a separate spreadsheet.

As the original data spreadsheet is predominantly for the warehouse, I don’t want them to have access to the extra info. Therefore I would like to pull the info from their working spreadsheet and create a new one.

The spreadsheet is currently shared via Dropbox. Happy to request the info be stored on Google or One Drive if it needs to be??

Let me know if you think you can help, and how many hours this creation will take.

Warmly

Sarah – [url removed, login to view]

sarah@[url removed, login to view]

Skills: Business Analysis, Data Entry, Data Processing, Excel, Visual Basic

See more: excel pull data from another worksheet, excel copy filtered data to another sheet automatically, how can i link data from one excel spreadsheet to another?, how to link sheets in excel to another sheet, how to automatically update one excel worksheet from another sheet, transfer data from one excel worksheet to another automatically, filter excel data to a different sheet, how to link cells in different excel spreadsheets, Create a Bookkeeping Spreadsheet using Microsoft Excel, create report excel spreadsheet, create simple excel spreadsheet template macros, create standalone excel spreadsheet, download web page existing excel spreadsheet using vbscript, create app excel spreadsheet, create custom excel spreadsheet, create letter excel spreadsheet, create form excel spreadsheet, create export excel php using codeigniter, create csv excel spreadsheet, create lotto excel using vba

About the Employer:
( 4 reviews ) Austinmer, Australia

Project ID: #16727052

Awarded to:

P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$200 AUD in 3 days
(256 Reviews)
0.0

7 freelancers are bidding on average $173 for this job

$155 AUD in 1 day
(40 Reviews)
0.0
rinabuoy13

Hi Sarah, I am experienced excel developer. I can assist your with this task. Looking to hearing from you soon. Regards

$222 AUD in 3 days
(30 Reviews)
0.0
Ashisjena2015

Hi, I'm an advanced excel expert. Please discuss in detail over chat now so that I can start your work. Thank you!

$100 AUD in 0 days
(30 Reviews)
0.0
schoudhary1553

Hello, I have the good knowledge of Create an Advanced Excel Spreadsheet Using Info From Another Sheet. I have more than 5 years of experience in Business Analysis, Data Entry, Data Processing, Excel, Visual Basic. More

$180 AUD in 3 days
(244 Reviews)
0.0
kaajitkumar

Hi, This is with regard to your job posting, I find myself matching your requirements. To briefly introduce myself, I’m a Business Strategist with over 18+ years of corporate experience in the role of Strategy Planni More

$200 AUD in 3 days
(0 Reviews)
0.0
ryandizon

I have been in the BPO industry for 9 years as a WorkForce Manager. I have a very strong foundation in reporting and workforce management. I am the guy you're looking for. My expertise in forecasting and data analys More

$155 AUD in 3 days
(0 Reviews)
0.0