| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Display selected rows from one worksheet to another
Worksheet 1 has values in cells B1:G1 and down to B20:G20. I would like
worksheet 2 to display the values of each row of worksheet 1 only if the value of cell D1,D2,D3 etc. of worksheet 1 is between 20 and 29. I would also prefer not to have spaces between the rows in worksheet 2 when the selected rows are displayed. I would appreciate assistance with a formula to do this. Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display specific rows from table on other worksheet | Excel Discussion (Misc queries) | |||
| empty rows at bottom of worksheet | Excel Discussion (Misc queries) | |||
| How to use outline data (grouped rows) in a protected worksheet? | Excel Discussion (Misc queries) | |||
| How to use outline data (grouped rows) in a protected worksheet? | Excel Discussion (Misc queries) | |||
| Deselect one of many non-adjacent rows selected | Excel Discussion (Misc queries) | |||
Threaded Mode
