P Paul Morgan Dec 1, 2010 #1 Hello, How can I search for an item in columnA and copy and paste A and B to new location?
C CurlyDave Dec 1, 2010 #2 Hello, How can I search for an item in columnA and copy and paste A and B to new location? Click to expand... Check this out http://www.davesexcel.com/apps/blog...umn-then-copy-and-paste-it-to-a-new-location-
Hello, How can I search for an item in columnA and copy and paste A and B to new location? Click to expand... Check this out http://www.davesexcel.com/apps/blog...umn-then-copy-and-paste-it-to-a-new-location-
D Don Guillett Excel MVP Dec 1, 2010 #3 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>>>>
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>>>>
