FonzAre138
12-14-2016, 09:24 AM
I did a search through the forum and did not easily run into what I am trying to do, which I think is hopefully simple but I haven't done anything on multiple worksheets with qualifying statements that only return certain values.
Here is the idea behind what I am trying to do (See Attachment):
Sheet 1: Data
Sheet 2: Looking at a column STATE on Sheet 1 for 'NY' and only bringing in only unique records and specific fields into selected columns.
Sheet 3: Looking at same STATE column on Sheet 1 for 'CA' this time and bringing in only unique records and specific fields into different columns.
I am not getting past where I am only returning one of the records that may have been duplicated into the separate Sheets.
The blank fields with no data from Sheet 1 will be manually entered on both Sheets 2 and 3.
17838
Any suggestions?
Thanks!
Here is the idea behind what I am trying to do (See Attachment):
Sheet 1: Data
Sheet 2: Looking at a column STATE on Sheet 1 for 'NY' and only bringing in only unique records and specific fields into selected columns.
Sheet 3: Looking at same STATE column on Sheet 1 for 'CA' this time and bringing in only unique records and specific fields into different columns.
I am not getting past where I am only returning one of the records that may have been duplicated into the separate Sheets.
The blank fields with no data from Sheet 1 will be manually entered on both Sheets 2 and 3.
17838
Any suggestions?
Thanks!