| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Link row of data from one worksheet to another based on column criteria
I have excel sheet with 4 worksheets tabs(Master, Won, Lost, No Bid). All data entered on Master. I want each row to automatically link/appear on 2nd, 3rd or 4th worksheet tab based on info in column Q (Result) which would be either 'Pending' - in which case it would stay on Master, 'Won' - would stay and copy to Won worksheet, 'Lost' - would stay andcopy to Lost worksheet, 'No Bid' - would stay and copy to No Bid worksheet. All rows would always show up on Master worksheet.
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying data from one worksheet to several based on criteria | Excel Programming | |||
| Help getting first column data based on criteria? | Excel Worksheet Functions | |||
| Transferring data from one worksheet to another based on criteria | Excel Discussion (Misc queries) | |||
| Copying data from one worksheet to another based on criteria | Excel Discussion (Misc queries) | |||
| How to add data to a column based on criteria from another | Excel Discussion (Misc queries) | |||
Threaded Mode
