VBA

[mjserio]

Hi,

At work I have to organize data from time to time and I have the same
problem each time. I would like to write a VBA code to solve it. I
have a list of transactions with accounts listed and a number next to
each account. Virtually every account is repeated. I subtotal the
data to get the total for each account, but using the subtotal
function, I can't delete all of the other irrelevant single
transactions below. Basically I want to be left with each account
name listed once with the total volume in the cell next to it instead
of a string of transactions with the accounts listed multiple times.
Can anybody help? It seems like it shouldn't be all that hard and it
would save me a TON of time. Thanks!

 

[Graham Mayor]

I have read your requirement several times and it is still incomprehensible.
Can you describe *exactly* what you have now and *exactly* what you want to
do with it.

I suppose we are talking about a table? Which Word version is this? Or is it
an Excel table and you are in the wrong forum?

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[StevenM]

I would suggest creating a mock-up of your document (no one wants to see
sensitive information) and post it somewhere on the web. And then post a
follow-up message with your document's web-address on this forum. If we can
see the actual document, it might be easier to give you some help.

Steven Craig Miller

 

[Doug Robbins - Word MVP]

Copy the data into a table in Access, then create a query based on that
table and select the Account Number and the Amount fields to be displayed by
the Query, then from the view menu, select View Total and in the Account
column of the Query designer, change the "Group by" to "Sum". When you
view the result of the Query, it will display what you want.
--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP