| 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 NOTBLANK and Column J is NOT= 1, then I want to copy cells in column A, B, C and D to another worksheet. All of these cells from the same row. If either condition doesn't match, then skip to the next row. The result would be a compact report of about 40 rows with entry in column A ,B, C and D. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy cells in a row to another sheet | Excel Worksheet Functions | |||
| 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 sheet 1 data to sheet 2 cells. | Excel Worksheet Functions | |||
| Copy row sheet-sheet skipping unqualified cells | Excel Worksheet Functions | |||
Threaded Mode
