Populate spreadsheet from another spreadsheet

[jh3016]

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!

 

[ploeryan]

You can try this - RowZ is the rowreference.

=if(‘Sheet1’!rowZColumnB=X,’sheet2’!rowZColumnA=’c:\location\worksheetB.xls!rowZColumnA,””)

=if(‘Sheet1’!rowZColumnC=”MON”,’sheet2’!rowZColumnC=”NS”,””)

Hope this helps

[Afro2]