Keyword search, and insert row.

**seanobrathvilly** · 01-20-2014, 05:40 PM

Hi,

I am not sure if this is possible but if it is then I should kiss whoever created it. I have a giant spreadsheet where I need to split out cost 50/50 depending on a key word which is the description of a computer and then I need the a row or 2 rows inserted underneath this row that has the key word.

For example I have the below example. I would like the macro to look for the keyword "computer" and then insert the 2 rows under it and divide the cost by half.

even if anyone knows a macro to insert the rows via keyword it would be class

Again I am probably shooting a blank gun here but if anyone has any help/ suggestions it would be great

Thanks

**AB33** · 01-20-2014, 05:55 PM

You seemed to have attached the same sample as the previous thread.

**seanobrathvilly** · 01-20-2014, 06:03 PM

I edited my first post. Thanks again for all your help. Blond moment at its best

**AB33** · 01-20-2014, 06:14 PM

Insert rows.

**xladept** · 01-20-2014, 06:32 PM

Another option:

Please Login or Register  to view this content.

**seanobrathvilly** · 01-20-2014, 06:52 PM

Thanks, the first option appears to have worked. Just as a learning question, if I want to search by keyword in col. "H" and there is data in col. I, J and K how would I write this?

Thanks

**AB33** · 01-20-2014, 07:06 PM

For a single column Insrt function works well, but if you are trying to search more than 2 columns, instead of many ifs in the code, the find function used by XlAdept would be suitable.
Change the 3 in cells(I,3) to cells(I,8)

**xladept** · 01-20-2014, 07:29 PM

Please Login or Register  to view this content.

Keyword search, and insert row.

LinkBack

Thread Tools

Rate This Thread

Display

Keyword search, and insert row.

Re: Keyword search, and insert row.

Re: Keyword search, and insert row.

Re: Keyword search, and insert row.

Re: Keyword search, and insert row.

Re: Keyword search, and insert row.

Re: Keyword search, and insert row.

Re: Keyword search, and insert row.

Thread Information

Users Browsing this Thread

Similar Threads

Search multiple worksheets for keyword and return all rows with that keyword to new sheet

Search keyword in a column & if any keyword match then cut that full row & paste it

Keyword search

keyword search

search by keyword

Bookmarks

Bookmarks

Posting Permissions