I am trying to take information from 1 worksheet into another. Example of
what I want is- If in worksheet B P7-P8 is < than 0.75,then place into
worksheet C with the name of the person from worksheet b from cell A6.

I hope this makes sense! This is really hard for me to explain.

Thanks!

in a vba macro the full path for referring to a cell is the following

workbooks("XXXXX").worksheets("XXXXX").cells(XX, XX).XXXXX
the path can be truncated if you track where your at. IE if you leave off
the workbooks portion it will refer to that worksheet and cell in the
currently active workbook, the same is true for worksheets. For example using
a conditional if statement with cells in different workbooks

if workbooks("Cool1").worksheets("Sheet1").cells(5, 8).value =
workbooks("Cool2").worksheets("Sheet1").cells(5, 8).value then

hope this helps