| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If a cell is checked take words from a pivot table and place in a
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. -- Bwick |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If a cell is checked take words from a pivot table and place in a
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" wrote in message ... 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. -- Bwick |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If a cell is checked take words from a pivot table and place i
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. -- Bwick "John" wrote: 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" wrote in message ... 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. -- Bwick |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If a cell is checked take words from a pivot table and place i
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" wrote in message ... 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. -- Bwick "John" wrote: 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" wrote in message ... 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. -- Bwick |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If a cell is checked take words from a pivot table and place i
It's very kind of you to help. Thanks a lot.
-- Bwick "John" wrote: 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" wrote in message ... 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. -- Bwick "John" wrote: 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" wrote in message ... 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. -- Bwick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I display comments (words) as my data in a pivot table? | Excel Discussion (Misc queries) | |||
| Pivot Table Toolbar Checked, but Still Missing | Excel Discussion (Misc queries) | |||
| Place all subtotals at bottom of pivot table? | Excel Discussion (Misc queries) | |||
| How can I place a table in ONE cell (ex A1) | Excel Discussion (Misc queries) | |||
| Pivot Table - using Countif in place of Count,Sum, etc. | Excel Discussion (Misc queries) | |||
Linear Mode
