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 the sheets named 2008 - 2012 so I can just enter new data in 2012 and have the first sheet (repeat) automatically update IF a duplicate name is entered.

I would also like for the sheet to give me the duplicate addresses as well along with the other information in that table. All of my 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. It would be nice to have that same information copied over to the RepeatVic sheet. Right now, I copy paste everything into that sheet and have the duplicate value under conditional formatting enabled and then I sort by repeats. But that means that every single incident in the past 5 years is in that single worksheet, and every time I enter a new name, I have to reenter it in the repeats worksheet as well. I need not only the repeat names but the repeat locations as well.

I am sure there is an easier way, and I ask you, excel experts, for your help!

Thanks in advance

On 21/06/2012 3:13 AM, sallyz98 wrote:
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 the
sheets named 2008 - 2012 so I can just enter new data in 2012 and have
the first sheet (repeat) automatically update IF a duplicate name is
entered.

I would also like for the sheet to give me the duplicate addresses as
well along with the other information in that table. All of my
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. It
would be nice to have that same information copied over to the RepeatVic
sheet. Right now, I copy paste everything into that sheet and have the
duplicate value under conditional formatting enabled and then I sort by
repeats. But that means that every single incident in the past 5 years
is in that single worksheet, and every time I enter a new name, I have
to reenter it in the repeats worksheet as well. I need not only the
repeat names but the repeat locations as well.

I am sure there is an easier way, and I ask you, excel experts, for your
help!

Thanks in advance



Hi

I'm certain there is a reason for using Excel for this, and you're
right, "There is an easier way"- IMO you should be using a Database to
use as a central container where all victims info can be entered once
and you can have multiple entries of events rather than duplicating the
information over and over for each ensuing event....

I would strongly advise you have a chat to someone higher up pay scale
and get them to look at something like MS-Access which is interactive
with Excel and all other MS-Office applications.

There are many excellent and talented programmers who offer cheap
services in the MS-Access Newsgroups.

A few NG's to visit:

microsoft.public.access.gettingstarted
microsoft.public.access.tabledesign
microsoft.public.access.formscoding
microsoft.public.access.queries
microsoft.public.access.reports
microsoft.public.access.security

Some individual sites you can visit:

http://www.rogersaccesslibrary.com
http://www.lebans.com

Or should you feel you have the goods to go the distance and do it
yourself this is one of the best sites to use for all reference material
you will need...

http://access.mvps.org/access/

Apologies, I do some Access Programming but unfortunately I do not have
the spare time to look at it due to commitments

HTH
Good luck
Mick.

I do agree that ACCESS is a better way to keep track of it, but our IT department is ... well lets not go there.

I like Excel. I am comfortable with Excel. I would be intimidated using ACCESS. If there is no easy way with a formula, then I will just stick to the way I am doing it. I appreciate your help!