| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying a row to new sheet based on column value
Hi I have a worksheet that where I need to copy some of the rows to a new
sheet based on the value in a column. Basically the sheet has 15 columns, and if the value in column H is either ADD, ALA ALP, AMM or BEY I want to copy the entire row to a new worksheet so I am left with two worksheets. One containing all rows of data and one containg just those rows where column H contains one of the values above. Any help would be much appreciated. I'm totally lost with this. Regards John |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying whole row to another sheet based on criteria on cell | Excel Discussion (Misc queries) | |||
| Copying columns from multiple sheets in a single sheet based on a column value. | Excel Programming | |||
| Copying line from one sheet to another based on given criteria | Excel Worksheet Functions | |||
| Dynamic column chart - copying from Sheet to Sheet. | Excel Discussion (Misc queries) | |||
| Maintaining column formatting when copying a row to another sheet based on a value | Excel Programming | |||
Threaded Mode
