Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reference every 4th row from a master list of modifiable length
I'm creating an excel database for a clinical study on patients with migraine. Each patients will treat 4 attacks (episodes). This presents a bit of a problem, since there's some information I'm collecting that's specific to the patient (demographic information like sex, height, etc.), and some that is specific to each attack (like the pain level of that attack, the duration of that attack, etc.). To account for this, I decided to give each patient four rows--one for each attack--and I put their deomographic information in the second row, leaving the other three blank in those fields (see below). However, this lead to complications when I was programming the statistics, so I ended up making a new worksheet for each attack (worksheets "Attack 1", "Attack 2", "Attack 3", and "Attack 4", in addition to the original "All Data" worksheet). These worksheets have all the attack-specific information for each patient. For example, the attack 1 worksheet would be the first row of each patient (i.e. every 4th row, starting with row 2) from column 5 on (i.e. skipping the demographic stuff). I don't know how many patients there will be, so I'd like for the user to be able to add new patients (rows) to the All Data worksheet and have it automatically update the other worksheets. Is there a way to do this other than manually going to every single row in each Attack worksheet and typing "=" and the referenced cell number? Also, if I have to manually do this, I'll just have to pick a random number of patients to do it for (i.e. some large number that I don't they'll go over) instead of catering to the specific number of patients in the "All Data" worksheet. (Note: In the example worksheet below, a cell with just "----" indicates a blank cell. The "--" are just place holders for me to try to line things up) | Sex | Height | Age | Weight | Attack | Pain | Duration | Etc . . . . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotals in a list | Excel Discussion (Misc queries) | |||
How to Change List Based on Value Chosen in Another List | Excel Worksheet Functions | |||
Data Validation List Length | Excel Worksheet Functions | |||
loop trough e-mail address list to send task lists with outlook | Excel Discussion (Misc queries) | |||
list box length | Excel Worksheet Functions |