Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 54
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 10,124
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 70
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
transfer entire row to another sheet aditya Excel Discussion (Misc queries) 2 May 25th 09 01:35 PM
transfer contents from a cell in previous sheet if the sheet is a DarkNight New Users to Excel 1 September 9th 08 01:04 AM
How can I transfer a required data from sheet 1 to sheet 2 automat Malik Nadeem Excel Discussion (Misc queries) 6 October 24th 07 11:48 AM
How to Automatically transfer specific Data from Sheet 1 to Sheet Jman Excel Worksheet Functions 12 May 10th 07 05:35 AM
Transfer/Copy Sheet, Dynamically linked Sheet 0-0 Wai Wai ^-^ Excel Discussion (Misc queries) 2 December 23rd 05 11:04 PM


All times are GMT +1. The time now is 03:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"