Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Complicated formatting, help!
I've worked myself into a corner and could really use help with 2
separate problems - this will probably require programming that is beyond my skills - but expert advise would be appreciated to determine how I should approach this: I have a master spreadsheet used both as a data entry sheet and also for tracking documents associated collected for each individual (per row). I have a worksheet with names and addresses typed in simple rows and columns (simplified): Site # Name Role Facililty Review Board 101 Joe Brown PI <name&address <name&address 101 Jane Blue CO <left empty <left empty 101 Jack Smith SUB <left empty <left empty 102 Bob Black PI <name&address <name&address PROBLEM #1 I have another worksheet that pulls the information into a formatted report that only lists the site # and Review Board information. It works great as long as there is a single row of information per site #, but when I add names with the CO role, i end up with Site # Review Board 101 <Review Board Name and address 101 BLANK 101 BLANK 102 <Review Board Name and address I want to NOT display those blank lines IF they are duplicate site numbers AND IF the role is NOT PI. (if the role is PI, I need the line displayed with a blank cell if empty). I will never know how many CO or Subs will be listed per site, if any. PROBLEM #2 (more complicated I think!) I have another worksheet that pulls information from the same master sheet. This report looks like this right now: Site # Name Role Facililty ----------------------------------------------------------------- 101 Joe Brown PI <name&address ----------------------------------------------------------------- 101 Jane Blue CO <left empty ----------------------------------------------------------------- 101 Jack Smith SUB <left empty ----------------------------------------------------------------- 102 Bob Black PI <name&address ----------------------------------------------------------------- What I need it to display is: Site # Name Role Facililty ----------------------------------------------------------------- 101 Joe Brown PI <name&address <blank Jane Blue CO <blank <blank Jack Smith SUB <blank ----------------------------------------------------------------- 102 Bob Black PI <name&address ----------------------------------------------------------------- I require the site number to be printed only once, and not for every individual. And you can see, I need a line displayed between sites instead of btween every individual. There will ALWAYS be a PI listed. Sometimes there are COs and SUBs, but again, there is no way to determine if or how many there will be for any given site. I may be way in over my head here - I'd appreciate any feedback! Thanks in advance for bearing with me. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Complicated formatting, help!
So whats the deal?
Is there something wrong with what I am asking? Should I ask somewhere else or is it just too complicated or maybe I *can't* do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complicated conditional formatting | Excel Discussion (Misc queries) | |||
Complicated!! - Conditional formatting with nested function | Excel Worksheet Functions | |||
Complicated formatting | Excel Discussion (Misc queries) | |||
Complicated conditional formatting if numbers match across a data set..How? | Excel Worksheet Functions | |||
Complicated VBA Conditional Formatting | Excel Programming |