Hey all,
I am playing with the following macro:
Nothing too crazy. It copies the comments in cells A1:A6 and pastes them into B1:B6. Taking the below scenerio, however:
A1: Gold
A2: Silver
A3: Platinum
A4: Diamond
A5: Bronze
A6: Rock
B1: Silver
B2: Platinum
B3: Rock
How can I make it so, rather than just duplicating the comments in A1:A6 and placing them into B1:B6, it will check to see what items are in B1:B6 and only give the respective comment from cells where a1 = b1, a2 = b2, etc. Example:
A1: Gold (Comment: "Yellow")
A2: Silver (Comment: "Silver")
A3: Platinum (Comment: "Hard")
A4: Diamond (Comment: "Pretty")
A5: Bronze (Comment: "Orange")
A6: Rock (Comment: "Brown")
After macro...
B1: Silver (Comment: "Silver")
B2: Platinum (Comment: "Hard")
B3: Rock (Comment: "Brown")
B4: "" (no comment)
B5: "" (no comment)
B6: "" (no comment)
Hopefully this makes sense! Any thoughts?
Bookmarks