| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy cells in a row to another sheet
I have a worksheet with twelve columns and 200 rows of data.
If column A is not(blank) and column J has a 1 [number one], then I want items in columns A,B, C and D to be copied to another sheet. Obviously if either condition doesn't match it would skip over and got ot the next row. When its all done, it would give me a compact list of data from only 40 to 50 rows. Thanks for any help, Atul |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy certain cells in a row to another sheet, based on certain val | Excel Worksheet Functions | |||
| Copy cells from one sheet to the next available row on another? | Excel Discussion (Misc queries) | |||
| Copy a value from one sheet if two cells match | Excel Discussion (Misc queries) | |||
| Copy sheet 1 data to sheet 2 cells. | Excel Worksheet Functions | |||
| Copy row sheet-sheet skipping unqualified cells | Excel Worksheet Functions | |||
Threaded Mode
