| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
data between sheets
I have a three worksheets in this problem However I only need to get
work with two of them. Here is what I want to do. Sheet1 ColA ColB ColC Sheet2 ColA ColB ColC I want to match the data on Sheet2 ColA with the data on Sheet1 ColA However the information to match could show up multiple times on Sheet2 ColA so it could be in row 1, 2, 3 but only in row 1 on Sheet1 ColA So if Sheet1 ColA matches Sheet2 ColA (anyrow) I want to add the data in Sheet2 ColB (whatever row matches) to Sheet1 Col C Row1 Does that make sense? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to update data from multiple sheets to one specific sheets | Excel Discussion (Misc queries) | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| In 3 active sheets in wkbk, determine& display the # of sheets that have data | Excel Discussion (Misc queries) | |||
| Chart sheets cause data sheets to be blank | Charts and Charting in Excel | |||
| populating sheets based on data from parent sheets | Excel Discussion (Misc queries) | |||
![Dale[_9_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
