| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to copy rows that meet criteria to another sheet in Excel
In one worksheet, I have a set of about 15 columns. For those rows that have
a value of 1 in column 3, I want to copy those to another worksheet. Both worksheets are in the same workbook. My current # of rows is only 170. I want sheet #2 to automatically grow as things are added to sheet 1. How? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy rows of one sheet into mutiple sheets based on column value | Excel Discussion (Misc queries) | |||
| Excel: have add'l rows entered in sheet 1 always show up in sheet | Excel Worksheet Functions | |||
| paste excel sheet excluding hidden rows | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| How can we delete rows permanently from excel sheet | Excel Discussion (Misc queries) | |||
Threaded Mode
