searching

Hello, I would say I'm relatively new to VBA in particular, and this site as well (it's my first post!). I am working with Excel 2010. I need help designing a macro to search a range (B, C in the case of the table below) and based on if a cell in the range has text (B1, B3, B5, B7, C1, C4...

Hi All, In my current job most of the time I have to open several pdf files to look for page(s) containing particular tag (say 'XYZ'), and then save/print each of that page individually. Once I have all the pages with that tag saved in one folder, I normally use pdf merger to merge them in one...

Hello I am hopeful that someone can help me on this website. I have had great help in the past with other issues I have come across. What I have now is beyond me as I am a beginner level VBA. Currently I have to web based data sources that I need to access. Once accessed (this part I have...

Hello! I'm working on a project and have already learned a lot about Excel's options.. however there's one thing I can't figure out. I'm hyperlinking to a large car rental website that offers services for several cities. However, I want it to automatically link to the city that appears in...

I am currently using the below script which returns the location of a string. I need to change it to instead just search column b for string and give me the value of column A where its found instead of the location. Any ideas? Public Sub FindText() 'Run from standard module, like: Module1. Dim...

I am working on a small project and fairly new to vba, but managing alright with the guidance of many helpful people. Here's what I'm looking at. I have a workbook that saves a sheet to a new file for each client, the new filename contains the client name, a claim number, and the date it was...

Hi Folks, A while back, one of the forum people created a VBA script for a searchable library database I had. I would like to take the same concept and put it in another workbook, but I just don't know how to code it. Can anyone help? I have attached the original coded spreadsheet (sorted...

Hey all, pretty sure this is an FAQ, but I can't find it. I have a set of text labels in column A, and a series of numeric values in column B, thus: A B Alec 5 Bob 6 Carol 7 I want to find the text label from column a that corresponds to the lowest figure in column B, which...