Excel Spreadsheet Help Requested

I couldn't really see what your formula did for me Michael .... but then I readily admit to being as thick as three short planks when it comes to spreadsheets.

I really thought there would be a simpler answer. There is an existing function (on the right click button) which says "Delete entire row" .... it's what I use to do it manually - either one row at at time or CTRL or SHIFT select for multiple rows. (And in all honesty, it doesn't take that long - it's just tedious).

I thought there might be a way of checking a cell and invoking the aforementioned function if the cell is empty.

| Edited to kill the stupid smiley things   "

(Wouldn't it be nice if we could do inline responses? Real ones I mean.)

Edited By Peter Greene on 02/12/2021 01:57:34

.

Column B shows your current stock-count

Column C is the quantity that you like to have in stock

Column D makes the decision whether you should buy more

Column E tells you how many to buy [to restore your preferred stock-level]

.

If you print it out, complete with the blanks, then ; when the Supermarket has a special offer … you can easily make an informed decision ‘on the hoof’

MichaelG.

Edited By Michael Gilligan on 02/12/2021 07:07:14

And if really keen, Michael's approach can be extended by adding more columns, such as:

Column F - Due-Out (quantity booked for later consumption, such as tomorrows dinner.)

Column G - Future Requirement (quantity known to be required in future, such as Xmas Turkey)

Column H - Due-In (quantity ordered in advance but not delivered yet)

Column I - Lead Time (time taken between reordering and actual delivery)

Column J - Shelf Life (time after which the item goes bad, such as Milk)

and many more...

I write lists on the back of an envelope and forget to take them with me...

Dave