Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
dan dan is offline
external usenet poster
 
Posts: 15
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
vb code to copy and list selected row to diff sheets pvkutty Excel Discussion (Misc queries) 1 February 17th 10 12:05 PM
how you make links between diff. cells on diff. work sheets NYC-MIKE Excel Worksheet Functions 3 February 11th 08 05:05 PM
How can I match up values from 2 sheets and info in adjoining cell naclu Excel Discussion (Misc queries) 4 February 3rd 06 10:50 PM
how to add many cells on diff. sheets and put in 1 cell in excel Maintman763 Excel Worksheet Functions 0 January 11th 06 03:33 PM
Copy data from diff workbooks but without opening sheets raja Excel Programming 1 September 21st 05 02:21 PM


All times are GMT +1. The time now is 10:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"