Welcome to Windows Help!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Filter rows/transactions to another sheet.

  
   Windows Help (Home) -> Microsoft Excel RSS
Next:  Explorer crashes when deleting files  
Author Message
Tom Christensen

External


Since: Dec 21, 2008
Posts: 2



(Msg. 1) Posted: Sun Dec 21, 2008 5:25 pm
Post subject: Filter rows/transactions to another sheet.
Archived from groups: microsoft>public>excel (more info?)
Hi

I have a sheet with 6500 transactions in rows. Each row contains an account
no, amount, etc

I would like to have Excel automatically copy all the rows/transactions on
each account to a separate sheet in the same workbook (one account per
sheet). And I would like this to be done automatically for each account in
the original sheet. I have tried Vlookup, but it does not seem suitable.

Can anyone give me inspiration?

Best Regards

Tom Christensen
Copenhagen/Denmark

 >> Stay informed about: Filter rows/transactions to another sheet. 
Back to top
Login to vote
Ron de Bruin

External


Since: Dec 2, 2008
Posts: 17



(Msg. 2) Posted: Sun Dec 21, 2008 5:25 pm
Post subject: Re: Filter rows/transactions to another sheet.
Archived from groups: per prev. post (more info?)
Hi Tom

Start here
[URL="http://www.rondebruin.nl/copy5.htm"]http://www.rondebruin.nl/copy5.htm[/URL]

 >> Stay informed about: Filter rows/transactions to another sheet. 
Back to top
Login to vote
Chip Pearson

External


Since: Dec 21, 2008
Posts: 3



(Msg. 3) Posted: Sun Dec 21, 2008 5:28 pm
Post subject: Re: Filter rows/transactions to another sheet.
Archived from groups: per prev. post (more info?)
Try some code like the following. Change

Set SourceWS = Worksheets("Sheet1") 'wrote:

>Hi
>
>I have a sheet with 6500 transactions in rows. Each row contains an account
>no, amount, etc
>
>I would like to have Excel automatically copy all the rows/transactions on
>each account to a separate sheet in the same workbook (one account per
>sheet). And I would like this to be done automatically for each account in
>the original sheet. I have tried Vlookup, but it does not seem suitable.
>
>Can anyone give me inspiration?
>
>Best Regards
>
>Tom Christensen
> Copenhagen/Denmark
 >> Stay informed about: Filter rows/transactions to another sheet. 
Back to top
Login to vote
Tom Christensen

External


Since: Dec 21, 2008
Posts: 2



(Msg. 4) Posted: Mon Dec 22, 2008 1:25 pm
Post subject: Re: Filter rows/transactions to another sheet.
Archived from groups: per prev. post (more info?)
Hi Ron de Bruin

Thank you very much for your quick reply. And for the link.
Surprised)
I will search your "goldmine" of information for the best solution.

best regards
Tom
 >> Stay informed about: Filter rows/transactions to another sheet. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
trying to retrieve a cell from table in sheet 2 to sheet 1 - Hi, I am trying to create a management & billing stylesheet for a massage shop. I am using MS Excel 2003. It contains two sheets. SHEET1: A B C D ..

Excel 2008 hanges when deleting cells or rows -

Macro to insert rows based on user selection - I have a macro that allows a user to insert one or more rows based on a user input box. This allows me to control which formulae get copied into the new cells. The macro works fine UNLESS the user scrolls around the screen before making their selection...

summary sheet - I have made sheets for recommendation from incidents in a site. Each incident has many recommendations. I have used conditional formatting " and formula" to let me know if the due date is passed for the recommendation. Similarly in the sum...

Range of an Excel Sheet - I want to open a linked Excel Sheet with the appropriate range. The excel filename / range I have is the following: C:\Documents and Settings\aparmar\Desktop\Book1.xslx!Sheet!R1C1:R5C2 I'm opening the following by stripping of the extra information...
   Windows Help (Home) -> Microsoft Excel All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]