Boolean racking my brain

Ok guys i need someone that can think through this boolean logically. its been a long day at work and now I'm trying to walk through this boolean thing to make sure my data will post on the right pages.

I have an Excel Macro that will capture inputted customer/vehicle data from an input screen, at the end, based on questions answered, i need to place that data on 1 of 4 sheets in my excel document.

The questions are:
Is this a Nationwide claim? (Y.N) (boolean = nw)
Is the vehicle here? (Y/N) (boolean = vh)

So here's what i got
if NW = true and VH = True then place data on "sheet1"
if NW = true and VH = False then place data on "Sheet2"
if NW = False and VH = true then place data on "sheet 3"
if NW = false and VH = False then place data on "sheet4"

I can't think of how to write this IF statement for this to happen. can't get the logic going.

OR IS THERE A BETTER WAY?? i'm sure there is....

Thanks to those who took time to read all this post

Welcome to the forum. Your way is fine, and there are several others possible. Here's one.

Please Login or Register  to view this content.

Please take a few minutes to read the Forum Rules about thread titles before starting your next thread.

Or

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.