Thread: Replacing data in a row of sheet1 with data in a row of sheet 2 based on a field in both sheets being the same?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] banderson@nwws.biz is offline
external usenet poster
  
Posts: 8
Default Replacing data in a row of sheet1 with data in a row of sheet 2 based on a field in both sheets being the same?
Here is what I have:
I have 2 sheets named:
(APCURRENT),(CORPCONTACT)

In both sheets I have vendor names as Column A.
I want to look at APCURRENT "vendor names" and if CORPCONTACT "vendor
names" is
the same, I want to replace the APCURRENT B-H(Columns) with the
B-H(Columns) of CORPCONTACT. But only if they are equal if not ignore.

Any help would be greatly appreciated.
Thanks

Reply With QuoteReply With Quote