Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto transfer data in sheet2 (selected data)
Hi all,
IN SHEET1 I HAVE DATA LIKE, A B C D 1 CODE NAME AMT STATUS 2 12 JOE 1000 HIGH VALUE 3 13 JOHN 500 LOW VALUE 4 14 DEEN 1500 HIGH VALUE 5 15 JAMES 5600 HIGH VALUE 6 16 ANBIE 200 LOW VALUE I NEED THE RESULT IN SHEET2, LIKE A B C D 1 CODE NAME AMT STATUS 3 12 JOE 1000 HIGH VALUE 4 14 DEEN 1500 HIGH VALUE 5 15 JAMES 5600 HIGH VALUE IN SHEET1 I WILL CLICK YHE COMMAND BUTTON(TRANSFER DATA TO SHEET2) IT WILL AUTOMATICALLY PASTE IN SHEET2 ONLY(HIGH VALUE DATA) WITH USE OF MACRO IS ANY POSSIBLE OR THERE IS ANY FORMULA PLS LET ME KNOW. REGARDS, DEEN |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto transfer data in sheet2 (selected data)
Sheet2:
Header in row 1 In A2: =IF(ISERR(SMALL(IF(STATUS="HIGH VALUE",ROW(INDIRECT("1:"&ROWS(STATUS)))),ROWS($1:1 ))),"",INDEX(INDIRECT(A$1),SMALL(IF(STATUS="HIGH VALUE",ROW(INDIRECT("1:"&ROWS(STATUS)))),ROWS($1:1 )))) ctrl+shift+enter, not just enter copy across and down as far as needed "deen" wrote: Hi all, IN SHEET1 I HAVE DATA LIKE, A B C D 1 CODE NAME AMT STATUS 2 12 JOE 1000 HIGH VALUE 3 13 JOHN 500 LOW VALUE 4 14 DEEN 1500 HIGH VALUE 5 15 JAMES 5600 HIGH VALUE 6 16 ANBIE 200 LOW VALUE I NEED THE RESULT IN SHEET2, LIKE A B C D 1 CODE NAME AMT STATUS 3 12 JOE 1000 HIGH VALUE 4 14 DEEN 1500 HIGH VALUE 5 15 JAMES 5600 HIGH VALUE IN SHEET1 I WILL CLICK YHE COMMAND BUTTON(TRANSFER DATA TO SHEET2) IT WILL AUTOMATICALLY PASTE IN SHEET2 ONLY(HIGH VALUE DATA) WITH USE OF MACRO IS ANY POSSIBLE OR THERE IS ANY FORMULA PLS LET ME KNOW. REGARDS, DEEN |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto transfer data from 1 sheet to another within same workbook | Excel Worksheet Functions | |||
How to find a data in Sheet1,automatic transfer to Sheet2(Excel) | Excel Discussion (Misc queries) | |||
Auto Data Transfer | Excel Worksheet Functions | |||
Auto Data Transfer | Excel Worksheet Functions | |||
can I transfer data from sheet 1 to sheet2? | Excel Discussion (Misc queries) |