D
dan
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
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