Sheet 1 cell value (text in cell j:j) copy to sheet 2 if cel

March 28, 2013 at 03:48:34
Specs: Windows 7
SHEET 1 CELL VALUE (TEXT IN CELL J:J) COPY TO SHEET 2 IF CELL IN SHEET 1 (TEXT IN CELL A:A) MATCHES CELL IN SHEET 2 (TEXT IN CELL A:A)

in english, i have 2 sheets (first sheet is named master - the second sheet is named load). both sheets contain a part number in cell A (sheet 1 contains 3000 part numbers but sheet 2 only contains 100). on sheet 1 is a column named source that contains a value. on sheet 2 is a column named source that does not have a value. i want the value in sheet 1 to be populated in sheet 2 (source column), if the part number on sheet 1 matches the part number in sheet 2.


See More: Sheet 1 cell value (text in cell j:j) copy to sheet 2 if cel

Report •

#1
March 28, 2013 at 08:34:04
Please do not create more than one thread for the same question. I have deleted your other post.

In addition, please do not post in all caps. All caps in the internet equivalent of yelling, and no one likes to be yelled at.

DerbyDad03
Office Forum Moderator

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question