| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy certain cells from one sheet to another with a condition
I have 2 tabs. One tabs lists the names and the dates and other
onformation about the names in 600 rows. Column N has the type of the entry. If its "X " then i need to copy few entreees of the data from that row to another sheet . The the next entry and so on till the 600 rows are completed. If the entry in column N is "Y" then do not copy the information. I would really appreciate any help. thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy certain cells from one sheet to another with a condition
How about DataAutofilter and filter on column N for "X"
Select the data to copy then copy and paste to target sheet. Gord Dibben MS Excel MVP On 3 Jan 2007 12:16:35 -0800, " wrote: I have 2 tabs. One tabs lists the names and the dates and other onformation about the names in 600 rows. Column N has the type of the entry. If its "X " then i need to copy few entreees of the data from that row to another sheet . The the next entry and so on till the 600 rows are completed. If the entry in column N is "Y" then do not copy the information. I would really appreciate any help. thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| How do I copy a set of cells based on a logical condition | Excel Discussion (Misc queries) | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Copy 1 Sheet to Another | Excel Worksheet Functions | |||
| relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
Hybrid Mode
