cant we do other way around!! I guess you must be having list of alpha numeric word, you can put that in works sheet & next to each ref to sheets where it appears will get populated!!
Cheers!! +++++ *I did not do this for you. God is here working through me for you.* On Tue, Sep 16, 2014 at 6:45 PM, KAUSHIK SAVLA <savla.kaus...@gmail.com> wrote: > Hi team, > > Pls help on below. > > Kaushik > ---------- Forwarded message ---------- > From: "KAUSHIK SAVLA" <savla.kaus...@gmail.com> > Date: Sep 14, 2014 7:26 AM > Subject: Fwd: VBA required - Finding duplicates and adding all in one new > worksheet > To: <excel-macros@googlegroups.com> > Cc: > > Hi team, > > Awaiting response on below email. > > Request all to look into it. > > Thanks, > Kaushik > ---------- Forwarded message ---------- > From: "KAUSHIK SAVLA" <savla.kaus...@gmail.com> > Date: Sep 13, 2014 9:10 PM > Subject: Fwd: VBA required - Finding duplicates and adding all in one new > worksheet > To: <excel-macros@googlegroups.com> > Cc: > > ---------- Forwarded message ---------- > From: "KAUSHIK SAVLA" <savla.kaus...@gmail.com> > Date: Sep 13, 2014 8:09 PM > Subject: VBA required - Finding duplicates and adding all in one new > worksheet > To: <excel-macros@googlegroups.com> > Cc: > > Hi Team, > > In the attached file I would like to do the following:- > > Find alphanumeric cell of each worksheet in whole workbook, and to insert > a worksheet which will let me know the codes which are repeating several > times in which sheet name and cell location in the worksheet. > > Eg CS23741 on GRF_110_1 worksheet appearing only once in whole workbook > (to be ignored). Whereas CS23171 on GRF_110_1 tab worksheet cell no. c28 > appearing in GRF_117_0 worksheet as well at cell no. H83. This need to be > updated in the additional sheet which will show CS23741 appearing on > GRF_110_1 tab at cell C28 and at GRF_117_0 at cell H83 of GRF_117_0 tab. > > This exercise of finding and updating on the new worksheet need to be done > for all the 28 worksheets and I want a consolidated sheet which mentions > which code appears more than once in whole workbook and at which location. > > Many thanks in advance for your help. > > Thanks, > Kaushik > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
