PDA

View Full Version : Message box display if data not matching



BENSON
03-03-2008, 03:18 AM
I would like to compare two rows of data "C59:059" against row "C60:C60" if any of the cells in row "59" do not match the cell below in row "60" a message box should appear indicting which cells do not match . Collum "B" lists the items that the data pertains to in this case "bread rolls " so if cell "C59 " = 70 and cell "C60" = 75 the message box would show a message some thing like Bread Rolls collum " C " dont not match.

Thanks

Bob Phillips
03-03-2008, 03:22 AM
I don't quite understand. If C59 <> C60, C60 V<> C59 either, so do we pull the data from B59 or B60 to indictae which row? Or do you mean that te items are in C58:O58?

BENSON
03-05-2008, 02:05 AM
Sorry for not being more clear.I have inserted a snap shot of the work sheet below. The items are listed in collum "B" and the rows are "B59:O59" and "B60:O60" as you can see in the example below cell "C59" shows a differant amount than cell "C60" ie 700 vs 750.I would like if possible for a message box to appear on opening the worksheet to indicate that the bread roll entry for TUES on the stock sheet does not agree with the daily report entry

THANKS

TUES WED THURS

BREAD ROLLS PER DAILY REPORT700 BREAD ROLLS PER STOCK SHEET750

BENSON
03-05-2008, 02:09 AM
Sorry for not being more clear.I have inserted a snap shot of the work sheet below. The items are listed in collum "B" and the rows are "B59:O59" and "B60:O60" as you can see in the example below cell "C59" shows a differant amount than cell "C60" ie 700 vs 750.I would like if possible for a message box to appear on opening the worksheet to indicate that the bread roll entry for TUES on the stock sheet does not agree with the daily report entry

THANKS

TUES WED THURS

BREAD ROLLS PER DAILY REPORT700 BREAD ROLLS PER STOCK SHEET750