VBA: Search Word Chrome and Mozilla, Copy, Merge Cells and Paste.

**sroysroy** · 10-18-2015, 12:16 PM

VBA: Need help with two macros
1. Search Word Chrome and Copy its data in A18. Chome merged cell range in column A will be considered chrome data in column B. And need the output in a single cell is B18
2. Search Word Mozilla and copy and paste its data (B to E) in A20. Mozilla: merged cell range in column A will be considered Mozilla: data in column B to E. And need the copied output in a cell is B20 (column A to D)

Example input and output data appears in attached excel file. Hope its clear now.

**sroysroy** · 10-18-2015, 03:31 PM

It must be easy !

**alansidman** · 10-18-2015, 05:34 PM

Suggest you be more specific in your request. I have no idea what you want to happen. A clear explanation is always helpful. You have not provided any details to help understand your issue. Your attached worksheet is just as baffling.

**sroysroy** · 10-18-2015, 05:35 PM

example Input and output is there in attached excel sheet.

**alansidman** · 10-18-2015, 05:42 PM

Sorry, but your worksheet makes no sense to me. Perhaps a detailed explanation as I flunked mind reading.

**sroysroy** · 10-18-2015, 05:53 PM

Now alansidman!

**jaslake** · 10-18-2015, 06:23 PM

@Alan

I've looked at the Thread 3-4 times today...have to admit, each time I looked I received no additional insight.

**humdingaling** · 10-18-2015, 07:52 PM

based on what the outputs are on your example

Please Login or Register  to view this content.

**sroysroy** · 10-18-2015, 07:58 PM

Thanks humdingaling. It worked on only Sheet 3 and not in sheet 1 and 2

**humdingaling** · 10-18-2015, 08:01 PM

oh
that's bizarre i programmed the thing solely based on sheet 1 but now i know what you mean by search for word

ok give me a sec ill be back with your new code

**sroysroy** · 10-18-2015, 08:04 PM

the two words chrome and mozilla may or may not exist in sheets ! so both words should be considered for search to be found by VBA code !

**sroysroy** · 10-18-2015, 08:05 PM

Chrome and mozilla can appear any where in row !

**tax112** · 10-18-2015, 09:11 PM

Originally Posted by sroysroy

Thanks humdingaling. It worked on only Sheet 3 and not in sheet 1 and 2

VBA Code for the right result.It's okay?
To run properly with Sheet3 Code, you replace B3 = B4 in Code

**humdingaling** · 10-18-2015, 09:18 PM

see below code with find to look for where Chrome and Mozilla starts

Please Login or Register  to view this content.

**sroysroy** · 10-19-2015, 10:31 AM

Thank you very much humdingaling.

**sroysroy** · 10-19-2015, 12:02 PM

I want to run the code in all sheets of excel workbook humdingaling except in "sheet X" and "sheet Y". Thanks in advance.
first I put mozilla first its not working sir. The code is bit slow.

**humdingaling** · 10-19-2015, 07:00 PM

create a loop for the sheets

Please Login or Register  to view this content.

i dont know what you mean but put mozilla first?

**sroysroy** · 10-19-2015, 07:09 PM

For example when I have interchanged sheet1 search term mozilla data (8A:13E) above chome data 3A: 7E it is working partially only. Thats the problem I am talking about.

**sroysroy** · 10-19-2015, 07:11 PM

THIS LINE IS GIVING PROBLEM: For k = rng.Row To rng.End(xlDown).Row - 1

**humdingaling** · 10-19-2015, 07:27 PM

works fine for me
see attached

you arent changing the structure are you?

**sroysroy** · 10-19-2015, 07:37 PM

Many many thanks !

**sroysroy** · 10-23-2015, 04:40 PM

HUMDINGALING chrome is coping below cells as well upto the blank cells. because below keyword chome there is other data. and it is coping that aswell.

**humdingaling** · 10-25-2015, 07:43 PM

you really should explain the "real" scenario on your first post instead of adding extra things to add into your code
i've changed the code to work on your mergedcells instead of CTRL Down method

Please Login or Register  to view this content.

VBA: Search Word Chrome and Mozilla, Copy, Merge Cells and Paste.

Re: VBA: Search Word Chrome and Mozilla, Copy, Merge Cells and Paste.

Re: VBA: Search Word Chrome and Mozilla, Copy, Merge Cells and Paste.

Re: VBA: Search Word Chrome and Mozilla, Copy, Merge Cells and Paste.

Re: VBA: Search Word Chrome and Mozilla, Copy, Merge Cells and Paste.

Re: VBA: Search Word Chrome and Mozilla, Copy, Merge Cells and Paste.

Re: VBA: Search Word Chrome and Mozilla, Copy, Merge Cells and Paste.

Re: VBA: Search Word Chrome and Mozilla, Copy, Merge Cells and Paste.

Re: VBA: Search Word Chrome and Mozilla, Copy, Merge Cells and Paste.

Re: VBA: Search Word Chrome and Mozilla, Copy, Merge Cells and Paste.

Re: VBA: Search Word Chrome and Mozilla, Copy, Merge Cells and Paste.

Re: VBA: Search Word Chrome and Mozilla, Copy, Merge Cells and Paste.

Re: VBA: Search Word Chrome and Mozilla, Copy, Merge Cells and Paste.

Re: VBA: Search Word Chrome and Mozilla, Copy, Merge Cells and Paste.

Re: VBA: Search Word Chrome and Mozilla, Copy, Merge Cells and Paste.

Re: VBA: Search Word Chrome and Mozilla, Copy, Merge Cells and Paste.

Re: VBA: Search Word Chrome and Mozilla, Copy, Merge Cells and Paste.

Re: VBA: Search Word Chrome and Mozilla, Copy, Merge Cells and Paste.

Re: VBA: Search Word Chrome and Mozilla, Copy, Merge Cells and Paste.

Re: VBA: Search Word Chrome and Mozilla, Copy, Merge Cells and Paste.

Re: VBA: Search Word Chrome and Mozilla, Copy, Merge Cells and Paste.

Re: VBA: Search Word Chrome and Mozilla, Copy, Merge Cells and Paste.

Re: VBA: Search Word Chrome and Mozilla, Copy, Merge Cells and Paste.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Macro for opening hyperlinks present in excel sheet in Mozilla or Chrome.

[SOLVED] Copy paste data from excel to word. Copy paste from different cells.

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions