Thread: Help with find and replace macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
bhofsetz[_78_] bhofsetz[_78_] is offline
external usenet poster
  
Posts: 1
Default Help with find and replace macro

Try using a VLOOKUP worksheet function it may be quicker and easier than
coding a macro.

You'll have to put the VLOOKUP in the a cell next to the old header and
then you can cut and replace the Old Header with the New Header.

=VLOOKUP(A6,[sourceworkbook.xls]Sheet3!$A$1:$B$25,2,FALSE)

change the reference in red to the sourceworkbook, sheet and range
where the new headers need to be pulled from.


--
bhofsetz
------------------------------------------------------------------------
bhofsetz's Profile: http://www.excelforum.com/member.php...o&userid=18807
View this thread: http://www.excelforum.com/showthread...hreadid=381426

Reply With QuoteReply With Quote