Data Validation within Conditional Statement

Hi,

I have created an excel worksheet that has a certain table (including formats) copied and pasted 25 times to represent 25 time points within an experiment. Each row in a particular table (15 rows total) represents the status of a tumor over the 25 successive time points. I have used data validation in columns A and B to create a drop-down list that describes the location and status of a tumor for that particular time point.

My question regards auto-populating corresponding cells in each sequential time point trial. Suppose a value is selected from the drop-down and entered in cells A1 and B1. Is there a way to either autopopulate the corresponding cells in each table thereafter if a value exists or apply the same drop-down list if a value doesn't exist?

Please let me know if I should elaborate further or provide the sheet itself.

Thanks in advance

Hi khandiman490,

Please attach a sample spreadsheet... along with sample results (with explanation)... this would help us with your question...

Thanks,
Dennis

Hi Dennis,

Thanks for the prompt response. I have attached the worksheet for your convenience. what I'm trying to do is somehow create a macro/conditional statement for columns B and C. As seen in the sheet, if you select an option from the dropdown in cells B6 and C6 (doesn't matter what the value is), I would like excel to auto populate each subsequent row that corresponds to L01 (value in A6) with that given value. In other words, I would want the value in cells B6 and C6 to be copy and pasted into (B25, C25), (B47, C47), (B69, C69), etc. If there is no value in B6 and C6, I would want the subsequent cells to provide the user with the same drop down options listed in B6 and C6.

Hope that's clear enough.

Thanks

Hi khandiman,

Sorry, my work got in the way... anyway, it's lunch time and I'll see what we can do...

I have a couple of questions...
1. I'm assuming when you put a timepoint in cell B2, then you want the Baseline Scan section to paste in the proper Time Point sections in blue.
2. If 1 is correct, then do you want the "scan date" to show up in the header? "Time Point 1 scan date: 1/1/2013"
3. Why do you want the drop down options to disappear from the newly hard-coded values in the corresponding sections? You don't want them to overrride them?
4. What about "re-writing" in a particular section? Any ideas?

Thanks,
Dennis