Row Association

[dataman22]

I am new to VBA and need a way to figure out how to manipulate some rows of data in one sheet based on
what happens in rows in another sheet. I need some kind of sorting function or button.
In the attached spreadsheet, when the Events Column A in the 'Input' tab change, the Events in Column A
in the 'Track' tab change as well, but I need the numbers associated with those events to track along
with the Events.

This might not make sense because I left out that this is based on a friend's spreadsheet that doesn't
exist on a public network and I can't reproduce all the code to show you. There is already a Sort button
that actually consolidates the Events in column A on the first tab and bunches them all up at the top of
the column when one gets deleted off the list. I hope to add some code to that button that will also
manage to associate these numbers to the events on the second tab.

Thanks for your help !

[dataman22]

Can anyone help me with this? I just need a way to keep the rows of numbers associated with the Events in Column A in the second tab. Anybody have any code to do this? Thanks!!

[StephenR]

You could store the values in a table and use a look up. But why do you need to duplicate this across two sheets anyway?

[JOHN H. DAVIS]

Try this too see if it does what you want.

[dataman22]

John,
I'm not sure what you did exactly but I don't think that's what I was looking for. I see some code but I don't see that it does anything. Is there a button or something I should be looking for? Does it sort the list? Does it associate the numbers with the event names? I don't get it. Thanks for your help!

[JOHN H. DAVIS]

As a change occurs in Sheets Input, it is also reflected in Sheets Track. No button. It doesn't sort. I thought that was what you were looking for.