I have an approximately 2000-line table with one one unique identifying
number on every line. I need to copy some of those lines to a new table very
often and until now i've copy-n-pasted the required lines by hand. Now my
employer wants me to make it easier. It should require the user to insert
only the identifying number and the program should then find the correct line
from the original table and copy it to the new table on the selected line.

As I am new to script Excel or pretty much anything, i dont really have even
a glue where to start. Anyone who can help with the structure and/or point to
some online resources that could be helpful?

Cheers, Ossi Hannula

To make things a bit more clear: I have create a template table in which i've
already set some functions etc. For every new job, we take the template and
add required lines there. The number of cells per line is equal (constant) in
both the original table and the template in which they are supposed to be
added.

My first attempt to make it easier would be to do some stuff manually to see if
that helps.

Try applying Data|filter|autofilter to that column of identifiers.

filter to show only the values you want.
copy the visible cells to a different worksheet.

If you really need a macro, try recording one when you do it manually.

Ossi Hannula wrote:

I have an approximately 2000-line table with one one unique identifying
number on every line. I need to copy some of those lines to a new table very
often and until now i've copy-n-pasted the required lines by hand. Now my
employer wants me to make it easier. It should require the user to insert
only the identifying number and the program should then find the correct line
from the original table and copy it to the new table on the selected line.

As I am new to script Excel or pretty much anything, i dont really have even
a glue where to start. Anyone who can help with the structure and/or point to
some online resources that could be helpful?

Cheers, Ossi Hannula

--

Dave Peterson