Yes, that can be done. Can you tell me first, though, how many columns
you use in your Sheet1 (i.e. what is the next free column), do you
have a header row so that the data starts on row 2, and do you have
any objections to putting some formulae in Sheet1 which will enable
the formulae in the new Sheet2 to work? Also, what is the maximum
number of entries you are likely to expect for any G/L prefix?

Pete

On Jul 23, 3:06*pm, Julia wrote:
I'm the first to admit I'm not the best Excel user, so I'm coming to you guys
for help. Here's what I have:

Sheet 1, Column E contains a G/L number, like this: 12345-1001 or
12345-0057; the cells are formatted as text. Column G contains the
Description of that G/L number (text) and Column M contains a cost (formatted
as Accounting w/ 2 decimal places).

Here's what I've been asked to do:

Create a formula so that the user can (on Sheet 2), type in cell A1 the G/L
prefix, which is the first 5 digits of the G/L number (e.g., 12345) and the
formula finds all the G/L numbers on Sheet 1 that begin with those 5
characters and copies the information from Column E (the G/L number), Column
G (the description) and Column M (the cost).

Then, below that, the user will type in the next G/L prefix (ie, 22345) and
the formula would find the matches and paste the data, etc.

I hope I'm explaining this clearly. I've read so many articles this morning
trying to figure out what this formula looks like that I think I'm more
confused now than when I started. I'm using Excel 2003.

ANY help would be GREATLY appreciated!