I am using combox box with cell link as A1. I then make a copy of the row.
The new combox box's cell link still is A1. How do I change it to where the
new row is?
thank

You'd either have to do it manually or have a macro do the work (maybe the
insert, too??).

But it might be easier using Data|Validation. It kind of works like that
combobox and it's lots easier to implement.

Debra Dalgleish has tons of tips and hints at:
http://www.contextures.com/xlDataVal01.html

Kate Yang wrote:

I am using combox box with cell link as A1. I then make a copy of the row.
The new combox box's cell link still is A1. How do I change it to where the
new row is?
thank

--

Dave Peterson

Hi Dave,

Thank you very much for your help. I am very grateful.
You have saved my day.

"Dave Peterson" wrote:

You'd either have to do it manually or have a macro do the work (maybe the
insert, too??).

But it might be easier using Data|Validation. It kind of works like that
combobox and it's lots easier to implement.

Debra Dalgleish has tons of tips and hints at:
http://www.contextures.com/xlDataVal01.html

Kate Yang wrote:

I am using combox box with cell link as A1. I then make a copy of the row.
The new combox box's cell link still is A1. How do I change it to where the
new row is?
thank

--

Dave Peterson