| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data in sheet1 to be put into sheets 2, 3, 4, 5, etc | Excel Discussion (Misc queries) | |||
| Seperate data from one sheet to multiple sheets based on a column | Excel Discussion (Misc queries) | |||
| Help: formula=auto copy from sheet1, A1 only if data in field E1 . | Excel Programming | |||
| Repost:replacing data on a non focused worksheet with calculated data from the same sheet | Excel Programming | |||
| replacing data on a non focused worksheet with calculated data from the same sheet | Excel Programming | |||
Threaded Mode
