Pulling specific lines from a list based on a cell value

[chris.slater]

Dear All,
I'm trying to create a report that splits out data based on values in a specific column in the main data list.
I have one sheet in my workbook which has multiple rows of data relating to POS Card Terminal Receipts. There are 2 Terminals, each with their own ID, and the rows have a 'Terminal ID' column that I wish to use to create data on 2 additional sheets - 1 for each Terminal.
I need to be able to interrogate the main data sheet and automatically create rows in each on the new sheets based on the value in the 'Terminal ID' column.
So on the sheet for Terminal 1, it should look down the data - checking the 'Terminal ID' column for the value '1' and then, for each case of when it finds it, create a new row on the Sheet for Terminal 1.
The scenario is then further complicated by the fact that I then want have Sub-Totals on each of the new sheets.
Any help gratefully received.
Thanks in advance.

[AliGW]

Sounds like a job for FILTER, unless you want the new sheets generated, in which case maybe PowerQuery.

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

[chris.slater]

Thanks Ali,
the sheets will already be set up but i want the addition of data to be dynamic. Every few days I download a new 'csv' file with new transactions in it. I then simply copy and paste the new ones into the data sheet on the spreadsheet. At present I'm going through a process of filtering by Terminal ID and then copying and pasting the data into each sheet. This is a little bit long winded but manageable however, the plan is to add more terminals over time which will start becoming a huge pain.
I would like to be able to just paste over the entire data cells with the new ones and have each Terminal sheet auto update without having the faff of 'filtering, copying and pasting' the data for each Terminal separately.
In the attached sample I have removed the "Sub-Totalling" on the Terminal sheets to ease the process but I would need to be able to turn it back on at the end.
I did consider recording a Macro to go through the process of "Filtering, Copying and Pasting" but I'm sure there must be a better way.Terminal ID Sample.xlsx

[AliGW]

I think you'll need VBA for this - shall I move the thread for you?

[chris.slater]

Hi Ali
If you mean a Macro then I can probably manage that myself.
Thanks for your help.

[JEC.]

here your macro

Please Login or Register  to view this content.

[AliGW]

Yes, indeed macros are created using VBA.