Find item in column Copy to new location

P

Paul Morgan

Hello,
How can I search for an item in columnA and copy and paste A and B to
new location?
 
D

Don Guillett Excel MVP

Hello,
How can I search for an item in columnA and copy and paste A and B to
new location?
Click to expand...

Look in the vba help index for FIND and also for OFFSET. and/or try
recording a macro while manually
select col a HEADER letter>edit>find>your item>>>>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help to fix vlookup function in macro 1
Macro to copy table of contents to a new doc 0
Macro to copy top 3 value in column 1
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
Space at end of multi page list to accommodate new entries 1
Trying to create custom labels from an csv file + Need items numerically counted out 0
Change a great number of words in word files, with a macro as short as possible. 5
Create a dynamic master file 1

Top