Hi Folks;

I am trying to figure out a way to sort some information from data that
appears in a worksheet via an import. The import works like a
straightforward paste function from another program (in this case,
Quickbooks). The information pastes the same every time, i.e. data
appears in the same columns every time. These columns have a name in a
column (ex. A1)and a monetary value in another column (ex. D1). What
I'm having to try and do is make a formula that will sort similar names
and sum up the monetary values that match up with them. The "similar
names" are actually numeric codes (ex. 1200, 1300, 1400). The big catch
is that, due to the way this program "takes over" with the import/paste,
the codes do not land in a cell alone. It also pastes along with the
code a description. The descriptions can vary (ex. one can say
"1200-labor" the other "1200-materials"). My question is: can you do a
sort that asks to look at a list of data and have it count only cells
that INCLUDE a "similar name" (ex. 1200-hammer is included, 1300-pin
not included, 1200-nail included), and have it sum the amounts?
My thanks in advance, and please let me know if I'm not being clear
enough.
-Scott


--
Heyna
------------------------------------------------------------------------
Heyna's Profile: http://www.excelforum.com/member.php...fo&userid=8148
View this thread: http://www.excelforum.com/showthread...hreadid=278359

On Mon, 15 Nov 2004 13:04:56 -0600, Heyna
wrote:


Hi Folks;

I am trying to figure out a way to sort some information from data that
appears in a worksheet via an import. The import works like a
straightforward paste function from another program (in this case,
Quickbooks). The information pastes the same every time, i.e. data
appears in the same columns every time. These columns have a name in a
column (ex. A1)and a monetary value in another column (ex. D1). What
I'm having to try and do is make a formula that will sort similar names
and sum up the monetary values that match up with them. The "similar
names" are actually numeric codes (ex. 1200, 1300, 1400). The big catch
is that, due to the way this program "takes over" with the import/paste,
the codes do not land in a cell alone. It also pastes along with the
code a description. The descriptions can vary (ex. one can say
"1200-labor" the other "1200-materials"). My question is: can you do a
sort that asks to look at a list of data and have it count only cells
that INCLUDE a "similar name" (ex. 1200-hammer is included, 1300-pin
not included, 1200-nail included), and have it sum the amounts?
My thanks in advance, and please let me know if I'm not being clear
enough.
-Scott

See your response in other NG. Multiposting is discouraged.

--ron