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 th
following in Excel:

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

Each month there will be the need for a few of these new worksheets an
it would be infinitely less time-consuming if I were able to use som
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 an
highlighting each row could I just type in the shortname (e.g. NDB
into the new worksheet and the programme automatically transfer all th
data across?

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

Thank you very much,

Jame

--
JamesMantl
-----------------------------------------------------------------------
JamesMantle's Profile: http://www.excelforum.com/member.php...fo&userid=2663
View this thread: http://www.excelforum.com/showthread.php?threadid=39904