| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Population in separate Worksheets?
This may not be possible across worksheets. If worksheet 1 looks like:
A1 B1 C1 D1 Smith |Travel | 1 Jan 06|10 Jan 06 Jones |Rest | 1 Jan 06|10 Jan 06 What I need, is in Worksheet 2 if A1=SMITH and B1 is Travel then copy over...: Smith| Travel | 1 Jan 06| 10 Jan 06 I expect to have about 50 rows in Worksheet 1, but only about 4-5 rows in Worksheet 2. V/R KSL. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding same cells across multiple worksheets | Excel Worksheet Functions | |||
| How do I separate worksheets in a workbook into individual files? | Excel Worksheet Functions | |||
| Combine Workbooks as separate worksheets | Excel Discussion (Misc queries) | |||
| Spawning worksheets and a summary per worksheet | Excel Discussion (Misc queries) | |||
| slight variation when working with separate worksheets | Excel Discussion (Misc queries) | |||
Linear Mode
