Multiple Worksheets

[Malcolmm]

Hello,

I couldn't find this question anywhere else but I certainly apologize if it's redundant. I'll try to be a succinct as possible...

I have a tracking document (1) for people and their contact information. Within the same workbook, I have another sheet that tracks their involvement (2).

I have a form set up on the 1 to enter the information.

What I want...

Every time I enter a new person to 1, I want their name to be automatically entered onto 2.

2 is organized alphabetically and I would really like the person's name that is being added to the list to be slotted into the correct location, though I can handle having to sort manually if need be.

Any suggestions?

 

[wsjackman]

is the name in one cell or multiple cells?

which column and what row starts the names in sheet 1

 

[Malcolmm]

Thanks for your response.

The names start at B8 on the first sheet.

Something else I should mention...I don't want a link as I often sort the information on the first sheet by various means and so a link to a certain cell is not going to work.

I need the tool to take what I've entered and enter it on the second sheet and then be done with it, no other ties should exist. The more I type this the more it seems a tall request, but excel seems to be all-mighty, so I'm sure there is a way.

 

[wsjackman]

There are multiple macros to do what you want

Do you enter new names at any given spot or just at the end of the list?

But
an index(match())on sheet 2 might work

if you want names to start in cell a2

in a2

=if(counta('Sheet1'!B8:B2000<?xml:namespace prefix = rows(a$2 /><rows(a$2:A2),"",INDEX('Sheet1'!$B$8:$B$200,MATCH(ROWS(A$2:A2)-1,COUNTIF('Sheet'!$B$8:$B$200,"<"&'Sheet1'!B$8:$BG$200),0)),0))< p> confirm with Control shift Enter
copy and paste down

I'm not really a macro oriented person
</rows(a$2:A2),"",INDEX('Sheet1'!$B$8:$B$200,MATCH(ROWS(A$2:A2)-1,COUNTIF('Sheet'!$B$8:$B$200,"<"&'Sheet1'!B$8:$BG$200),0)),0))<>

 

[wsjackman]

the formula did not transmit I will regenerate it

 

[wsjackman]

In sheet 2 A3

=INDEX('Sheet1'!$b$8:$b$200,MATCH(ROWS(a$3:a3)-1,COUNTIF('Sheet1'!$b$8:$b$200," < "&'Sheet1'!b$8:$b$200),0))

again confirm with Control shift enter