is there a function that will call to a cell of a certain numeric value?

[macrohelpplz]

hey there and hello! thanks in advance for any help that can be offered.

so im all of a sudden needing to learn about excel macros for my job, and i've gotten some of the basics down, but find myself stuck with this new task I have.


basically, I need to take text, open it in excel, and run some formatting on it to get a series of specific numbers in a column to occur. once i have that data, i need to pull just that data from the sheet and add it to a new sheet.

the thing is, there is going to be a variable total number of cells of this data. So, what I think i need to do in my macro is once I have the data formatted, is have excel find the first cell with that specific # of digits (for example sake, lets says I need it to find the first cell with a number that has 11 digits in it), and then look at the cell underneath it, see if the data in the cell has the same number of digits, and if it does, extend the range downward one cell, and then repeat that until the check fails and then copy and paste to the new sheet

so, yeah, I guess thats my first question: is there anyway to make excel go to a cell containing a specific number value? if there is, i'd love to know how.

[Kaper]

at this level of generalisation, several answers could ge given.
but let me try to show one (simple but not very efficient, especially if your datsets are several thousand items or bigger).
lets assume you look into column A

Please Login or Register  to view this content.

Of course this is just a sample and it assumes there is at least one such value in your dataset.

[macrohelpplz]

Hello and thanks for the reply! Sorry for the general details. Let me use some images to get into specifics. After the formatting, here's what the start of the data range is:

rangestart.png

And it terminates here:

range ends.png

In this instance, the range would be 50 cells, but it will be variable from file to file.

At this point, I think I have the loop necessary, but what I am unsure of is when I achieve termination of the loop, the next step needs to be copying the values in the range to the clipboard so they can be pasted elsewhere. I'm going to make some attempts here and give my results.

[macrohelpplz]

oh, I forgot to add: this is the code so far:

Please Login or Register  to view this content.

[macrohelpplz]

please ignore