Hi all,

I have quiet a few dropdown boxes on my w/s (combo boxes, 56 in all!), i have assigned named ranges for the data in each box but i have not done anything with linked cell (as i dont know what this does) what i would like to do is click my command button and have all dropdown box data copied down from the next availabe cell where i will use the ActiveCell.Offset(x,x) to place the data where i want after that........so i need help with the dropdown copy contents and paste to lets say sheet3, but after contents have been pasted i would like all the NEW data to be a named range using the text in the TextBox2 on the w/s...........is this possible?

Hope you can help!

Regards,
Simon