Hi all,
So I have a raw data table on one tab in a worksheet. Its got about 30,000 rows
- Column 1: 50 Unique values (US States)
- Column 2: X Unique values (Counties with those States)
- Column 3: Short amount of text entered into a cell (I know, but its done now).
I want to create 5 reports based on 5 US States which uses the 'relevant' counties (column 2) and relevant text (column 3). In other words, if I select New York, then I want relevant column 2 and column 3 to populate in a table.
So I've set up 5 new tabs in this worksheet. Now I know I can just filter the raw data file by state, then copy and paste what I need into each of the 5 tabs. But, there will be more raw data added to the original raw data file and I would like to automate this process.
All advice very much welcomed. Thank you
So I have a raw data table on one tab in a worksheet. Its got about 30,000 rows
- Column 1: 50 Unique values (US States)
- Column 2: X Unique values (Counties with those States)
- Column 3: Short amount of text entered into a cell (I know, but its done now).
I want to create 5 reports based on 5 US States which uses the 'relevant' counties (column 2) and relevant text (column 3). In other words, if I select New York, then I want relevant column 2 and column 3 to populate in a table.
So I've set up 5 new tabs in this worksheet. Now I know I can just filter the raw data file by state, then copy and paste what I need into each of the 5 tabs. But, there will be more raw data added to the original raw data file and I would like to automate this process.
All advice very much welcomed. Thank you