![]() |
Copy cell values if cells match on two diff sheets
I have a question, and I thank you ahead of time for any help.
Sheet1 has ColA with formula number, ColB has ID number of formula, ColC has Description of the action using the formula. ColB is unique, ColA is not. An example might be like this: ColA ColB ColC 80 100 This fixed boxZA 80 101 This fixed Box ZB 80 102 This fixed Box z9 94 103 This was maintenance. 94 104 Server Maintenance Sheet2 has a pivot chart, looking like this: ColA ColB Formula Number Count of Form# 80 3 94 2 I would like to add column C next to the pivot chart on Sheet2 with a description. It would be like if a cell in Sheet1 colA matched a cell in sheet2 colA, it would make sheet2 ColC = sheet1 colC where ColA matched. So if Sheet1 ColA had 80 and Sheet2 ColA had 80, Sheet2 would pull the description from Sheet1 on the row with 80. This can be done by formula or macro. I appreciate any help you can give me, thank you!! Dan |
All times are GMT +1. The time now is 11:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com