I need troubleshooting for my excel sales sheet

  • Posted:
  • Proposals: 0
  • Remote
  • #401809
  • Archived
  • 0

Description

Experience Level: Intermediate
Estimated project duration: 1 - 2 weeks
General information for the business: We deliver balloons for parties.
Industry: Entertainment
Description of excel work:

I would require some help with a current Excel file which I have created for a small start-up business. (It basically records sales entries)
- It has multiple entries for 1 information, therefore if I change a price, I need to change it multiple times... (Would be great if I can change it once and references will work on its own.
- The major problem I have now is with multiple lookups... I managed to get it for the first input (but when I drag it to bottom cells/copy, it doesnt work; I suspect its a problem with the locked cells)
- I need to change the excel sheet into a "form" so that details can be keyed in without changing the formulas
- I would like every single sale to be recorded and have monthly sales record.
- Would like you to have a look if the file can be improved generally.
Please let me know your rates as I have a relatively tight budget if its by the hour... (How much time do you think such a work is needed?)

*Please view the attached file, there are some comments in cells which will aid in your understanding.

These are some questions which you may require answers to -
a) Your intention for each worksheet?
First sheet is for me to determine MOQ and cost details for each product.
Decoration Sales Template is for me to key in details of each sale... (Basically for each additional sale, I would copy the sheet and key in the details)
References is basically where all the formulas are getting its reference from.
And the last sheet is to generate monthly sales report.

b) How you want to record sales details? Would you key in details manually or do you want it driven automatically somehow through the form that you mention?
Because of the variety of products, and the speed which I need to retrieve information while being on the phone with customers, it's best to have the information keyed in before hand and then driven automatically when required.

c) You mention multiple lookups. Is this when you are trying to create another line item in the sales template?
Under decoration sales template, the cost details 'automatic retrieval of information' actually derives from the lookup value of column A and B.

d) In the sales template there is an item called profit/pc. Will you be filling that in manually or do you need it feeding from somewhere?
That is actually linked to cost details... Its feeds automatically with cost details after column A and B are filled in... The reference is from the references sheet under "IF FUNCTION"

e) Which information would you need to change multiple times?
The cost details per piece under the sheet of 'Decoration Pricing' is actually exactly the same as those under "IF FUNCTION" in the References sheet... So if any of that information needs to be changed, I got to change it twice.

f) What information would you like to record for every sales?
Basically the 'Decoration Sales Template' Sheet is the "form" which would record each sale, all information required is there. We just need to 'improve' it.


Extra notes: The key issue is to ensure that the multiple lookup function in Sheet 'Decoration Sales Template' column C&D works... It works now... But if I copy Rows 7-11 to have another product entry, it doesn't anymore.

The other issues are minor ones.

New Proposal

Create an account now and send a proposal now to get this project.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.