S
sallyz98
Excel Experts,
I have a workbook with several sheets named 2008, 2009, 2010 etc
Each sheet contains names and addresses.
I have another sheet called RepeatVic
I would like for the repeats to give me names that are duplicated in th
sheets named 2008 - 2012 so I can just enter new data in 2012 and hav
the first sheet (repeat) automatically update IF a duplicate name i
entered.
I would also like for the sheet to give me the duplicate addresses a
well along with the other information in that table. All of m
information are in table format so I can use TABLE[@Date] etc.
The tables are structured as such:
CaseRpt Date Mth IncidentLocation Neighborhood VictimName VictimOf Sx Rc DOB Age AgGrp
So every worksheet from 2008 - 2012 has those table column titles. I
would be nice to have that same information copied over to the RepeatVi
sheet. Right now, I copy paste everything into that sheet and have th
duplicate value under conditional formatting enabled and then I sort b
repeats. But that means that every single incident in the past 5 year
is in that single worksheet, and every time I enter a new name, I hav
to reenter it in the repeats worksheet as well. I need not only th
repeat names but the repeat locations as well.
I am sure there is an easier way, and I ask you, excel experts, for you
help!
Thanks in advanc
I have a workbook with several sheets named 2008, 2009, 2010 etc
Each sheet contains names and addresses.
I have another sheet called RepeatVic
I would like for the repeats to give me names that are duplicated in th
sheets named 2008 - 2012 so I can just enter new data in 2012 and hav
the first sheet (repeat) automatically update IF a duplicate name i
entered.
I would also like for the sheet to give me the duplicate addresses a
well along with the other information in that table. All of m
information are in table format so I can use TABLE[@Date] etc.
The tables are structured as such:
CaseRpt Date Mth IncidentLocation Neighborhood VictimName VictimOf Sx Rc DOB Age AgGrp
So every worksheet from 2008 - 2012 has those table column titles. I
would be nice to have that same information copied over to the RepeatVi
sheet. Right now, I copy paste everything into that sheet and have th
duplicate value under conditional formatting enabled and then I sort b
repeats. But that means that every single incident in the past 5 year
is in that single worksheet, and every time I enter a new name, I hav
to reenter it in the repeats worksheet as well. I need not only th
repeat names but the repeat locations as well.
I am sure there is an easier way, and I ask you, excel experts, for you
help!
Thanks in advanc