Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
transfer entire row in sheet 2
i want to apply following condotion
IN SHEET1 if A2="ABC" Transfer all data in row 2 to row 2 in sheet 2 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
transfer entire row in sheet 2
Pls post in ONLY one group. See ans in other post
-- Don Guillett Microsoft MVP Excel SalesAid Software "aditya" wrote in message ... i want to apply following condotion IN SHEET1 if A2="ABC" Transfer all data in row 2 to row 2 in sheet 2 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
transfer entire row in sheet 2
Hi Aditya,
Type in the following formula in cell A2 of Sheet 2 and drag it towards right end. =IF(Sheet1!$A$2="ABC",Sheet1!A2,"") -- Click on Yes, if it is useful. Thanks & Best Regards, Dilip Kumar Pandey MBA, BCA, B.Com(Hons.) New Delhi, India "aditya" wrote: i want to apply following condotion IN SHEET1 if A2="ABC" Transfer all data in row 2 to row 2 in sheet 2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
transfer entire row to another sheet | Excel Discussion (Misc queries) | |||
transfer contents from a cell in previous sheet if the sheet is a | New Users to Excel | |||
How can I transfer a required data from sheet 1 to sheet 2 automat | Excel Discussion (Misc queries) | |||
How to Automatically transfer specific Data from Sheet 1 to Sheet | Excel Worksheet Functions | |||
Transfer/Copy Sheet, Dynamically linked Sheet | Excel Discussion (Misc queries) |