If a cell is checked take words from a pivot table and place in a

[Brian]

I have 2 worksheets in a file; the first is titled "Schedule", the second is
titled "Master". On the second work sheet I need a function that says, in
effect, "if cell B10 in worksheet Schedule is marked with an x then take the
words written in cell A10 and populate them into this field".

I appreciate any help you can offer.

 

[John]

Hi Brian
Would something like this work for you ?
=IF(Schedule!B10="X",Schedule!A10,"").
This will copy what is in Schedule!A10 if B10 has a X
HTH
John

 

[Brian]

John - that worked! Thanks you so much. However, when it transfered the
info it removed the borders on the cells in the "Master" sheet. Any thoughts
on that?

Thanks again.

 

[John]

Hi Brian
Sorry no idea, I tried it in excel and can't reproduce that problem.
Will leave the question to the expert.
What version of excel are you using?
Are those cells formatted in colour?
Just question that comes to mind.
Wait and see if someone else as the answer.
Good luck
John

 

[Brian]

It's very kind of you to help. Thanks a lot.