ANmarS - Search results

Excel/VBA expert since Sep 1997 (21 years 2 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

3 Q & A posts tagged with find

Apr 8

How do I find and list all values in Excel?

I have a workbook with many sheets listing all of the schools my org interacts with. Each sheet lists 1-5 email addresses, depending on how many contacts we have.

I want to have a summary sheet that lists all of the email addresses so it's easy to copy-paste them to send out newsletter.

I did a FIND/REPLACE for "@" and it found all of the email addresses, but it won't let me copy paste them from the search results.

I've also been trying to do reserach on how to do this with a formula, macro, or VB but haven't come across anything.



Here is a simple macro that will help you doing that…

Enjoy it,, it will copy all rows from all other sheets than the current one into it for manipulating easy


Wednesday 4/8/2009 1:16:26 AM
Feb 4

In excel, is it possible to find a string or data in a set of pdf files?

I Need to extract information automatically from a set of pdf,, lets say I have 3 pdf files named. f-1.pdf, f-2.pdf, f-3.pdf and I need to extract a value inside the f-2.pdf file. that string will be something like "force A =100lb"
I need to extract that 100.

any clue where I can start to look?


If you don't have Adobe Acrobat (and not Acrobat Reader)? then I guess the only solution is copy and paste

May be any pfd creator application can help you automate that


Wednesday 2/4/2009 6:33:25 PM
Jan 21

Searching across sheets in Excel?

How can I do a search for several items across sheets in Excel, whether using vlookup or any other function


This is the lesson for that

Enjoy it

VBAXLMan is here to feed your Excel needs

Wednesday 1/21/2009 6:54:45 PM