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, Galway wrote: > > 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 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
