View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ossi Hannula Ossi Hannula is offline
external usenet poster
 
Posts: 1
Default Automatically copying specified rows from a sheet to another

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