Hi all,
best way i could describe it.
My problem is :
sheet 1 has a drop down (months)
now on sheet 2 A1's value is whatever it gets from the drop down.
my goal is:
I would like to use the drop down on sheet1 to fill the "A" column on sheet2 consecutively
for example:
drop down = march
sheet2 A1=march
drop down = december
sheet2 A2=december
and so on.
right now as I have it, A1 on sheet2 just keeps replacing the value with whatever value is set in the drop down.
is this possible to do?
thank you.
Tin
Bookmarks