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