$$Excel-Macros$$ Re: Find and Replace with an entire line from a another worksheet

2010-04-05 Thread javaonline
Thanks Paul, I'm not sure I was being thorough enough with my explanation. In any case...Through trial and error today I kept working at it, and this is what I've come up with. It looks like it's providing me with what I need. Maybe it will be of help to someone else. Sub ESTSearch() Do Until

$$Excel-Macros$$ Re: Find and Replace with an entire line from a another worksheet

2010-04-05 Thread javaonline
, I just need it to advance one cell down, and continue through the page. On Apr 4, 2:31 am, paulwillekens wrote: > Hi JavaOnLine > > This method works always and you can insert any specific criteria > without limit... > > Good luck. Let me know if it was useful...

$$Excel-Macros$$ Find and Replace with an entire line from a another worksheet

2010-04-02 Thread javaonline
Need help with a find and replace type macro. I've tried VLOOKUP but I don't think it will provide what I'm looking for. I have a column of numbers in Sheet A that I correspond with a row of data in Sheet B. Sheet B has thousands of lines of data that I do not need, I only need the several dozen