Hi, James. I'm not a big expert by any means, but I've stumbled my way
through a few projects. One question that immediately comes to my mind is:
where is the "master" file located? and associated question: who is going to
do this?

If the "master" file and all the created "child" files will be resident on
your computer only, and only you are going to run the macro to extract data
and populate the new workbooks, that's one scenario. If the master is on a
network and you are creating these on your machine, you may have some issues
to deal with. If the master is on a network and anyone may need the ability
to run a macro and do this, it can get a bit hairy. (Well, for me, any way.
There are guys here who do this without losing any sleep!"

Reading your scenario, it kind of sounds like you're wanting to run this
from a blank workbook template that would reach out and grab data from the
master. My approach to this would probably be to run a macro from the
master file, or from your Personal.xls with the master file open (assuming
you are the only user to create the new workbooks). When the short name is
typed into an input box, the list is filtered, the filtered data copied, a
new workbook created, the data pasted, and the workbook saved.

HTH
Ed

"JamesMantle"
wrote in message
...

Dear Users,
If anyone can help with this programming issue I'd be hugely grateful!


I am on work experience and have been asked if it is possible to do the
following in Excel:

Using a pre-existing worksheet of approx. 1500 rows of data, each with
a 2 or 3 letter "shortname" (e.g. NDB) in column one, is it possible to
extract required rows of data into a new worksheet, merely by writing
the "shortname" into column 1 of the new worksheet.

Each month there will be the need for a few of these new worksheets and
it would be infinitely less time-consuming if I were able to use some
sort of macro to aid me in this process.

For example:
Row 1: NDB 23444 223444 112445 223555 22234 558890

To move all the data into a new worksheet without searching and
highlighting each row could I just type in the shortname (e.g. NDB)
into the new worksheet and the programme automatically transfer all the
data across?

I look forward to hearing from anyone that thinks they may be able to
help!

Thank you very much,

James


--
JamesMantle
------------------------------------------------------------------------
JamesMantle's Profile:
http://www.excelforum.com/member.php...o&userid=26632
View this thread: http://www.excelforum.com/showthread...hreadid=399046