multiple sheet find finding

February 18, 2017 at 13:16:40
Specs: Windows 64
I have 280 sheets in one excel file. I want to search the the specific word that is defined in a new excel file.
so it search for example "CD0001" through all sheets, when it finds the CD001 then it find another word in the same sheet (ie word "DIAMETER")
When "diameter" has been found it find the value of in the next cell
I want that Diameter value in my new excel file and then loops continue'
next item to find is CD0002 again it go and search for the diameter and find the value in the next cell and return that value in my new excell sheet

See More: multiple sheet find finding

Report •

#1
February 25, 2017 at 03:18:37
You need to compile a script to do that.

Report •

#2
February 25, 2017 at 17:29:52
phill22: If by "compile a script" you mean that "a macro is required" then I agree.

SyedAzad: Just a tip a related to posting in a help forum like this one:

People are more apt to offer help if you actually ask for help as opposed to just telling us what you want/need. Even something as simple as adding a simple line at the end of your post such as "Can anyone help me with that? Thanks!" would make your post sound a lot more friendly.

That said, I have a few questions of my own.

You mentioned CD0001 and CD0002. Are those the only values that will be searched for or is it a longer list? If there is a longer list, where is the list found?

You also seem to indicate that you want find the word "diameter" for both CD0001 and CD0002. How are those diameters for those 2 search strings related to the string? In other words, we can't have the code find CD0001 and then find some random occurrence of "diameter". I assume that you only want the diameter value that is associated with CD0001. Is that diameter in the same row? The same column? Is the only diameter on any given sheet where CD0001 will be found?

Please keep in mind that we can't see your workbook from where we're sitting, so you need to explain the layout in enough detail that we can understand it enough to write code that will accomplish your goals.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question