Chris Slater
New Member
- Joined
- Dec 30, 2003
- Messages
- 21
Dear All,
I'm trying to create a workbook that splits out data to different sheets based on values in a specific column in a main "Data" sheet.
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 sheets will already be set up but I want the addition of new lines to be dynamic based on new values in the "Data" sheet. Every few days I download a 'csv' file with new transactions in it. I then simply copy and paste the new ones into the top rows of the "Data" sheet on the spreadsheet.
At present I have to go through a process of filtering by Terminal ID and then copying and pasting the resulting data into the relevant Terminal 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 range in the "Data" sheet with the latest data and have each Terminal sheet auto update without having the faff of 'filtering, copying and pasting' the data for each Terminal separately.
The scenario is then further complicated by the fact that I then want have Sub-Totals on each of the "Terminal" sheets. In the attached sample, however, I have removed the "Sub-Totalling" in order to simplify things 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.
Any help gratefully received.
Thanks in advance.
FYI: The Terminal Sheets are "06321792" and "06524883" which relate to the values in "Column D" on the Data Sheet.
Sheet 1: Data
Sheet 2: 06321792
Sheet 3: 06524883
I'm trying to create a workbook that splits out data to different sheets based on values in a specific column in a main "Data" sheet.
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 sheets will already be set up but I want the addition of new lines to be dynamic based on new values in the "Data" sheet. Every few days I download a 'csv' file with new transactions in it. I then simply copy and paste the new ones into the top rows of the "Data" sheet on the spreadsheet.
At present I have to go through a process of filtering by Terminal ID and then copying and pasting the resulting data into the relevant Terminal 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 range in the "Data" sheet with the latest data and have each Terminal sheet auto update without having the faff of 'filtering, copying and pasting' the data for each Terminal separately.
The scenario is then further complicated by the fact that I then want have Sub-Totals on each of the "Terminal" sheets. In the attached sample, however, I have removed the "Sub-Totalling" in order to simplify things 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.
Any help gratefully received.
Thanks in advance.
FYI: The Terminal Sheets are "06321792" and "06524883" which relate to the values in "Column D" on the Data Sheet.
Sheet 1: Data
Sheet 2: 06321792
Sheet 3: 06524883