Need a Macro to pull data from one cell and place into another one time

[jgregory43]

My Macro abilities are very limited and outdated, so I am reaching out to the group for some guidance on what I want to do. See the attached png files for a couple screenshots.
database 1.png database 2.png

I have a summary tab and I want a cell to return the number in a cell (which there may be several with same number) on another tab. I want only one result for the first cell on my summary sheet, and I want the next cell down to return the next numerical number based on previous cell pulled from other tab.

EXAMPLE:

Summary tab - Cell B8 is empty but i want it to pull the first number in numerical order from the Data tab "E" Column.

Data tab - "E" Column will have a number in it like 1-1-01 (3-22 times) and so on and so on. There will be ones like 3-1-06, so I want the summary sheet to pull only one of those numbers and place it in a numerical fashion on summary sheet.

so numbers in column B8 will look something like this

1-1-01
1-1-02
1-2-01
2-3-01

Numbers are pulled from the Data tab that looks something like this

1-1-01
1-1-01
2-3-01
2-3-01
1-1-01
1-1-02
1-1-02
1-1-02
1-1-02
1-2-01
1-2-01
2-3-01
1-1-01

I hope I made some sense.

[GC Excel]

Hi jgregory43,
Can you try this code... you might need to change the tab names.

Please Login or Register  to view this content.

[jindon]

Do you have something like 11-11-01, 1-12-02 etc.

If so, it is not so simple.

And No idea why the index starts from 1 in code posted above.....

For i = 1 To .Count - 1

Try this

Please Login or Register  to view this content.

[GC Excel]

Jindon is correct is you have something like 11-11-01, 1-12-02 etc.
However, there seems to be a small error in one line of the code :

Please Login or Register  to view this content.

[jindon]

Actually, you should consider the data which doesn't meet the pattern, such like only non numeric characters only.

Please Login or Register  to view this content.

[jgregory43]

For what I needed, the first code worked perfectly, and I tried it with doing double digits in the information I wanted to pull, and still worked like I wanted.
The only issue I had was if I were to remove one of the numbers pulled from Room Data sheet, it wont remove it from the Summary sheet and move the other numbers up.
How do I make it remove that one and resort?

[GC Excel]

If you run the macro again, the list should be updated correctly.
Note : clear the list first (from B8 to B???)

[jgregory43]

the first code does not clear the cell

[GC Excel]

This should work :

Please Login or Register  to view this content.

[jgregory43]

that macro cleared out my formatting of those cells as well. I just need to remove the numbers that were placed there