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

[harinder_harinder]

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