Column dependent on first row cell entry

Rosadocc

New Member
Joined
Mar 15, 2012
Messages
49
Hello,

I have a table with a column where all rows that will be populated based on the first rows data entry (based on a data validation list). Depending on that entry, all new rows after will have that same entry. Looking for a formula to help me do that.

Header (A1)
1234 (A2 Based on data validation drop down)
123 (A3 based on selection above)
123

<tbody>
</tbody>
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
In A2 something like =a1 then drag down. Need to give more directions to help further.
 
Upvote 0
Sorry I shouldve been more specific with what I am trying to do. It wouldve helped if I mentioned a new row is added based on values entered in the column next to it. For example if a value is entered in cell B3, A3 will automatically populate with the value selected in A2's drop down menu.
 
Upvote 0
Sorry cant find any other way to explain what im looking for so attaching this image. Any help is appreciated:

a8GEg0rE9uKwO2JntaO7h9mdTtJq0YyCi2COOu2r_oA
 
Upvote 0

Forum statistics

Threads
1,215,306
Messages
6,124,160
Members
449,146
Latest member
el_gazar

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top