I need some help with excel,

Question

I have some data (b1-o1)&nbsp; &nbsp;that I need to copy to a duplicate row on another sheet.&nbsp; The trick is A1 has a dropdown with 12 options&nbsp; ( a1,a2,a3,a4,a5,b1,b2,b3,b4,b5,c1,c2)&nbsp; I need to autofill rows on page 2 depending on the dropdown selection.&nbsp; &nbsp; The data on page 2 is the same for b1-o1&nbsp; but has a row for each&nbsp; &nbsp;A1 on 1, A2 0n 2, A3on3, a4 on 4, etc&nbsp; then down to c2&nbsp; &nbsp;,&nbsp; also as this log on page one grows&nbsp; &nbsp;it has to evewrite the previous entry fo say A1 row when another one is selected.&nbsp; &nbsp; PLEASE ADVISE

harun24hr · Answer

We can't replicate your problem. Would you please explain little more? Attach a sample file. Show your input data and desired output. You may need FILTER() function.

Forum Discussion

I need some help with excel,

1 Reply

Resources