I would like help in a formula.
In my master worksheet, I have columns that I want to flow over to another worksheet depending on its value.
Master worksheet has these columns
Column A = Lname
Column B = AfterTour
Column C = Day of week)
Column D = Day of week)
If Column B = X on Sheet1, then on the Sheet2:
Put what is in column A in Column A on Worksheet B
If Column C = Mon on Sheet1, then put an NS under Column C on Sheet2
This may be confusing, if so and I can explain more. Can anyone help me with this?
Thanks in advance!
In my master worksheet, I have columns that I want to flow over to another worksheet depending on its value.
Master worksheet has these columns
Column A = Lname
Column B = AfterTour
Column C = Day of week)
Column D = Day of week)
If Column B = X on Sheet1, then on the Sheet2:
Put what is in column A in Column A on Worksheet B
If Column C = Mon on Sheet1, then put an NS under Column C on Sheet2
This may be confusing, if so and I can explain more. Can anyone help me with this?
Thanks in advance!