In article , Claus Busch
writes
Hi Colin,

Am Wed, 11 Jun 2014 23:50:29 +0100 schrieb Colin Hayes:

BTW - is there a way to make the code act the first or second sheet
without the code referencing specific names for the sheets a specific
name?

change Sheets("Before") to Sheets(1) and Sheets("After") To Sheets(2)
or look again in OneDrive (It is changed there)


Regards
Claus B.


Hi Claus

OK I did this , but the code is giving Value! Errors in the formula in
the quantity column.

I think this is because Before! Is still mentioned twice in the last
part of the code. What would this need to be changed to?



Best Wishes


Colin