Consulting

Results 1 to 4 of 4

Thread: Message box display if data not matching

  1. #1
    VBAX Contributor
    Joined
    Dec 2006
    Posts
    193
    Location

    Message box display if data not matching

    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

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    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?
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    VBAX Contributor
    Joined
    Dec 2006
    Posts
    193
    Location
    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 REPORT700BREAD ROLLS PER STOCK SHEET750

  4. #4
    VBAX Contributor
    Joined
    Dec 2006
    Posts
    193
    Location
    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
    [VBA]
    TUES WED THURS

    BREAD ROLLS PER DAILY REPORT700 BREAD ROLLS PER STOCK SHEET750
    [/VBA]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •