Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have created an address book including family and friends.
At the right side of the sheet I have created 2 additional columns labeled "family", "friends". Within the cells of these columns I have placed an "x" as an identifier of that row having either "family" or "friend" address content. How do I use the IF command in this case. ie: IF cell value = x then send that row to another sheet in the workbook? I am assuming that I need to format the subsequent sheets to match that of the master sheet. My goal is to have created 2 additional worksheets. One for "Family" and one for "Friends". My first question on the post, Thanks for any help, Henry |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
cannot insert rows -error message "cannot shift object off sheet" | Excel Discussion (Misc queries) | |||
How to copy or share "Custom Views" from one sheet to another | Excel Discussion (Misc queries) | |||
problem with Linking workbooks via "copy" and "paste link" | Excel Discussion (Misc queries) | |||
Auto "copy and paste" individual cells from various sheets into one sheet ?? | Excel Discussion (Misc queries) | |||
name duplication via "Edit, Move or Copy Sheet" | Links and Linking in Excel |