| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
populate one worksheet from another
I have a reference number on one worksheet. I then want to search another
worksheet (Shet1) in the ssme workbook for that reference number. When found I want to copy all the info from the other columns (B, C) into similar columns on the new work sheet (Sheet2) Eg sheet 1 has the data and ColA is the ref number ColA ColB ColC 123 date amount Sheet2. I enter ColA data and want to then get data from Sheet1, Cols B C ColA 123 regards Chris |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copyright and worksheet protection | Excel Discussion (Misc queries) | |||
| Executing macro for all worksheet from a different worksheet | New Users to Excel | |||
| Reference Data in Moved Worksheet | Setting up and Configuration of Excel | |||
| Linking items GREATER THAN O on another worksheet in the same Work | Excel Discussion (Misc queries) | |||
| Worksheet name and Backward compatibility | Excel Discussion (Misc queries) | |||
Threaded Mode
