Macros to search cell & copy value next to that cell..paste this value in new excel

harinder_harinder

New Member
Joined
Oct 2, 2014
Messages
1
Hi

I want to make macros which gives me box to enter value (e.g. "set") and search "set" in whole sheet than paste value(e.g."groups" next to "set" in another sheet in my defined column/Row.

Tool should have below option to manually filling

1.Text/number to Search
2. Location to paste (e.g. Row/Column & sheet name on which to be pasted)


Row1 Column A Column B Column C
Row2 Header 1 Header 2 Header 3
Row3 set version 11.4R6.6
Row4 set groups re0
Row5 set groups re1
Row6 set apply-groups re0
Row7 set apply-groups re1
Row8 set system host-name
Row9 set system domain-name
Row10 set system backup-router

Regards,
Harinder
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Watch MrExcel Video

Forum statistics

Threads
1,109,054
Messages
5,526,512
Members
409,706
Latest member
Tom98

This Week's Hot Topics

Top