How to auto-filter rows from one sheet to another?

[Dom2012]

I have rows in Sheet 1 that I want to filter into two other Sheets.

Rows with the word "To" in Sheet 1 should be filtered into Sheet 2.

Rows with the word "From" in Sheet 1 should be filtered into Sheet 3.

Basically, Sheet 1 looks like a bank statement.

Sheet 2 is the Payments area for a Cash Flow chart.

Sheet 3 is the Receipts area for a Cash Flow chart.

So Sheets 2 and 3 must automatically break down Payments and Receipts so they can be calculated seperately.

My question is how do I create a sheet that filters select content from one sheet to another?

This is something I have never done before and I don't know where to start.

Thanks.

[martindwilson]

simplest would be to filter then copy/paste or do you want this to happen automatically with functions or possible vba code?

[Dom2012]

Copy/Paste would be very time-consuming and would increase the chance of mistakes. I want the process to be automatic.

[JBeaucaire]

'SHEET1 TO MANY SHEETS
I have a macro that may be "ready to use" for parsing rows of data from one sheet to many sheets named for the same values.

Sheet1 to Many Sheets

It not only can parse the rows, it can create the sheets if they are missing.

Once you've edit the macro to use the correct column, running the macro will put the "TO" rows on a sheet called "TO" and the "FROM" rows on a sheet called "FROM".

[Dom2012]

It looks impressive. I only wish I understood it all!

It looks like I might need a little bit of hands on help.

Would you be willing to look at what I've got and to tell me how to apply your macro more specifically?

Thanks,
Dom

[JBeaucaire]

I don't see a sample workbook in your post, put one up if the macro doesn't perform. There's only a couple of variables to "tweak" and the rest should work automatically for creating these subsheets for you. Give it a try before you give up.

[martindwilson]

Copy/Paste would be very time-consuming?????
2xcopy and 2xpaste how long does that take?

[Dom2012]

Copy/Paste would be very time-consuming?????
2xcopy and 2xpaste how long does that take?

I wouldn't be 2xcopy and 2xpaste. It would be one year's worth of transactions. Which could well be several thousand ... or more!

[Dom2012]

[QUOTE=JBeaucaire;2391051]'SHEET1 TO MANY SHEETS
I have a macro that may be "ready to use" for parsing rows of data from one sheet to many sheets named for the same values.

I tried it but it did not work. I got a debug message and didn't know what to do about it.

But I think my need is a little different to this.

To give you a better idea of what I want to do, I have attached two images.

Note that the end product is now one sheet with a left and right set of values. In other words, it is the same as a Cash Flow book. (not two seperate sheets).

"Accounts" shows the Accounts spreadsheet (S1). This is the sheet from which S2 should collect and filter rows.

Accounts.jpg

"Cash Flow" shows the Cash Flow spreadhseet (S2). It should organise the data automatically in the manner shown (but without the gaps).

Cash Flow.jpg

Thanks, Dom

[JBeaucaire]

Pictures of spreadsheets uploaded to other sites? Very ineffective.

Click GO ADVANCED and use the paperclip icon to post up a desensitized copy of your workbook. Make it easy to help.

[Dom2012]

Pictures of spreadsheets uploaded to other sites? Very ineffective.

Click GO ADVANCED and use the paperclip icon to post up a desensitized copy of your workbook. Make it easy to help.

Thanks for the tip.

[martindwilson]

once filtered you can copy paste visible cells in one go

[Dom2012]

once filtered you can copy paste visible cells in one go

Even so, I require an automated solution.