Main Area and Open Discussion > General Software Discussion

Need a little help with an Excel file please

(1/3) > >>

Stephen McBride:
Hi all,

We have a small family run business (online retail)
Every week we do a stock update to make sure we are not running low on certain products.

I created an Excel file that I manually Update - I deduct the stock sold that week from one column and add it to the overall sales of that product in another column.

Sometimes the numbers are not easy to do the math in my head for the overall sales column, so I need to use a calculator.

It would be great if I had a formula that automatically updated the overall sales. ie- I sell 27 of product X and manually decrease the stock on hand by 27 and the overall sales goes UP by 27.

Apologies if this seems confusing or very simple to do, I just can't figure out how to do it myself.

I am unable to attach the original Excel Worksheet as only xml file updates are allowed.

I have attached an xml version and would very much appreciate if someone could take a look at it and give me some advice.

Many thanks,

Stephen.

Target:
question, and apologies if this seems inappropriate for your situation. 

Why 'assume' that the 2 correlate?  I don't know what your product base is but would assume that you might need some means of identifying lost items, ie just because the stock level has decreased a corresponding increase in sales shouldn't necessarily be assumed.

FWIW I'd be happy to have a look at it for you, but I will need a copy in xl format (I don't have access to excel at the moment, but I can work with spreadsheets...)

Stephen McBride:
Hi Target,

regarding identifying lost or defective items, I simply subtract these also from the Stock Sold each week. This file is not very important for overall sales figures, but more so to see how many items I have in stock at any time and a good, general idea of overall sales of each product variation.

Unfortunately I am unable to upload an XL file as it is not supported in Attachments, Allowed file types.

I very much appreciate your input, thanks.

Stephen.

tomos:
Unfortunately I am unable to upload an XL file as it is not supported in Attachments, Allowed file types.
-Stephen McBride (May 09, 2020, 10:30 AM)
--- End quote ---
Can you zip it? I think it should be okay then

Stephen McBride:
Thanks Tom, I will give that a go  :up:

Navigation

[0] Message Index

[#] Next page