Hello again,
i hope everyone had a great weekend I am back for some much needed help, so far everybody who has helped me has been brilliant.
What i would like to achieve on the attached spreadsheet is
If Column BQ = FIXED then Column BR(Cell BR9) = Column BA (Cell BA9) But if Column BQ = Adjustable then Column BV(Cell BV9) = Column BA (Cell BA9)-2, then if BQ is blank no data to show. in either column BQ or BV
That means that currently they should read 562 and 560 respectively in the appropriate column (fixed shelves or Shelves)
Tank you in advance for the help.
Bookmarks