| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to sheet1 data goes to sheet2 automaticaly ?
Hai all
I would like to know one excel sheet1 data to sheet2 automaticaly,which command use for it ,please.... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to sheet1 data goes to sheet2 automaticaly ?
It's a formula. If you're on sheet2, to reference sheet1, use something
like: =sheet1!a1 Regards, Fred "ABDUSSALAM" wrote in message ... Hai all I would like to know one excel sheet1 data to sheet2 automaticaly,which command use for it ,please.... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to sheet1 data goes to sheet2 automaticaly ?
If it's a one-off requirement you can just use copy/paste, but if you
want it to be dynamic then you can put this formula in A1 of sheet2: =IF(sheet1!A1="","",sheet1!A1) then just copy the formula across and down as required. Hope this helps. Pete On Mar 10, 4:03*pm, ABDUSSALAM wrote: Hai all *I would like to know one excel sheet1 data to sheet2 automaticaly,which command use for it ,please.... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy data from sheet2 to sheet1 when sheet2 has variable # of rows | Excel Discussion (Misc queries) | |||
| copying data from sheet1 to sheet2 | Excel Worksheet Functions | |||
| How to import data from Sheet1 to Sheet2 in the order I want | Excel Discussion (Misc queries) | |||
| How To Retrieve Data from Sheet2 into Sheet1 | Excel Worksheet Functions | |||
| Looking for comparable data records between Sheet1 and Sheet2 | Excel Discussion (Misc queries) | |||
Linear Mode
