Messages

1

General Software Discussion / Re: Need a little help with an Excel file please

« on: May 29, 2020, 01:02 PM »

Yeah, I have a habit of making changes incorrectly 

It works though and I guess I could save regularly as I go.

Also far more user friendly when cell D is hidden.

When I close the document I get a warning "The picture is too large and will be truncated" Whatever that means!

Thanks.

2

General Software Discussion / Re: Need a little help with an Excel file please

« on: May 29, 2020, 05:24 AM »

Hi Target,

in principle it works yes, although I can't seem to get the Undo function to work.

You have definitely grasped the concept I had 

Many thanks.

Stephen.

3

General Software Discussion / Re: Need a little help with an Excel file please

« on: May 12, 2020, 08:09 AM »

Thanks guys, really appreciate any help 

4

General Software Discussion / Re: Need a little help with an Excel file please

« on: May 10, 2020, 11:04 AM »

Hi,

I have zipped the Excel file (unable to save it to XL format, could be an Office 365 thing!)

In a nutshell, each time I manually deduct from cell B, I would like cell D to automatically increase by the same amount.

I hope this makes sense.


Thanks all and stay safe.

5

General Software Discussion / Re: Need a little help with an Excel file please

« on: May 09, 2020, 01:08 PM »

Thanks Tom, I will give that a go 

6

General Software Discussion / Re: Need a little help with an Excel file please

« on: May 09, 2020, 10:30 AM »

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.

7

General Software Discussion / Need a little help with an Excel file please

« on: May 08, 2020, 03:54 PM »

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.