Hi All,

Is it possible to populate the same row twice? Same row but different columns.

For eg. Lets say A,B,C,D,E are the columns and 1, 2, 3, 4 are the rows.
Is it possible to populate A1, B1 and C1 when we click "Accept" button and
later when we click "Accept: D" or "Accept: E" it somehow populates in the
corresponding row but in column D and E respectively.
I think what I am looking for is a way to identify a row and input the data
in D and E. How can I design a script that prompts me a window to ask me
which row I want to populate in? Lets say I have a Unique ID in Column A and
I want a window to be displayed asking me the "Unique ID" to identify the
row. So Once I input the Unique ID it identifies the corrensponding row and
populates in Column D and E accordingly.

Hope I made it clear

Thanks in advance

I bet it is.

But before you do, you may want to look at excel's built in version:
Data|Form (in xl2003 menus)

If that's not enough...
You could look at John Walkenbach's enhanced data form:
http://j-walk.com/ss/dataform/index.htm

The source code is available for a small fee ($20 USA, IIRC). So you can modify
it as much as you want.

=========

Are you building a userform to get the responses from the user? If yes, as a
user, I would think that it would be simpler for you to have a combobox/listbox
that displayed all the values from column A. Then textboxes or comboboxes or
some meaningful control for each of the fields.

And then I could complete each field and hit the Ok button and all the fields
would be plopped back into the worksheet.

If you've never created a userform...

Debra Dalgleish has some nice notes about userforms:
http://contextures.com/xlUserForm01.html
(video: http://contextures.com/xlVideos05.html#UserForm01)
and
http://contextures.com/xlUserForm02.html

ps. Debra's code just adds the input to the bottom of the data. The code would
have to be modified to look for a match (or modified to look for a match and if
one isn't found, then add it to the bottom).



sam wrote:

Hi All,

Is it possible to populate the same row twice? Same row but different columns.

For eg. Lets say A,B,C,D,E are the columns and 1, 2, 3, 4 are the rows.
Is it possible to populate A1, B1 and C1 when we click "Accept" button and
later when we click "Accept: D" or "Accept: E" it somehow populates in the
corresponding row but in column D and E respectively.
I think what I am looking for is a way to identify a row and input the data
in D and E. How can I design a script that prompts me a window to ask me
which row I want to populate in? Lets say I have a Unique ID in Column A and
I want a window to be displayed asking me the "Unique ID" to identify the
row. So Once I input the Unique ID it identifies the corrensponding row and
populates in Column D and E accordingly.

Hope I made it clear

Thanks in advance

--

Dave Peterson