I was hoping to have them individually fill cells on sheet 1. Galway On Jan 1, 7:16 pm, Paul Schreiner <schreiner_p...@att.net> wrote: > How do you want to return the results? > It's a simple matter to create a loop that looks through column A and > for matching values, add the column B data to sheet 1. > Or. you could use filters on sheet 2, > activate the filter on column A, then copy/paste column B. > > let me know what approach you'd like and I'll try to help. > > Paul > > ----- Original Message ---- > > From: Maddy <ma10ku...@gmail.com> > > To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> > > Sent: Thursday, January 1, 2009 8:35:15 PM > > Subject: $$Excel-Macros$$ Re: FIND MACRO > > > You can get it done with the help of pivot table. > > > Please refer to our earlier thread in the below link: > > http://groups.google.com/group/excel-macros/t/abb778320b48ea8a?hl=en > > > Still, if you have any queries, please post them. > > > Happy New Year 2009 !!! > > > Maddy > > > On Jan 1, 2:41 pm,Galwaywrote: > > > I need a macro. I have two columns. One with various text (column A, > > > worksheet 2). One with a unique text (column B, worksheet 2). I need a > > > macro that will search column A and give me the text in column B. Then > > > Find Next. The same search can find multiple choices from column B. I > > > want all my Column B choices as my result. > > > > I am starting with (on worksheet 1, a cell with a small string of > > > text) to be found in Column A on worksheet 2, on worksheet 1 I have a > > > range of cells set aside for the top ## of results from column B on > > > worksheet 2. > > > > I hope this is clear. > > > >Galway
--~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~----------~----~----~----~------~----~------~--~---
