| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sheet 1 to sheet 2 conditional
Hi,on sheet 2 =if (sheet1!a3=USA) then i want to copy all data next to usa there is 5 colum b3,c3,d3,e3 or entire row on sheet 2. what kind of formula do i use.for this i used in cellc3 =IF(sheet1!A3="usa",sheet1!C3,"") in cell d3 =IF(sheet1!A3="usa",sheet1!d3) and in all next cell.Please find out there is any easy way. Thanks. -- adib ------------------------------------------------------------------------ adib's Profile: http://www.thecodecage.com/forumz/member.php?userid=165 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=73900 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel sheet bootom half sheet goes behind top part of sheet | Excel Worksheet Functions | |||
| Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
| Need conditional data from 1 sheet to populate another sheet | Excel Worksheet Functions | |||
| copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Worksheet Functions | |||
| copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Discussion (Misc queries) | |||
Threaded Mode
