combining data from 2 sheets
Hi ..Thank you very much for responding .... Is there any way to pull the two
columns into 3rd sheet "NO" and "NAME1" ...resulting "NO" , "NAME1","NAME2"
in the third sheet ... Also all the serial numbers may not be same in the
first two sheets .... I am new to excel.... sorry to bother you .. Thank
you...
"KePaHa" wrote:
Under Name1 on sheet 3, something like this should work:
=IF(Sheet1!A1<"", Sheet1!A1, "")
If Sheet1 A1 is empty, then do nothing, otherwise put in here what is in
cell A1.
"Sri" wrote:
Hi..
I have data in 2 sheets which i want it to be displayed in the third sheet.
Please suggest me how to proceed with this...
------**------
Example :
Sheet 1: Sheet 2 :
No Name1 No Name2
1 abc 1 efg
2 eds 2 xyz
4 def 3 aaa
5 dss 6 ddd
The Result should be :
Sheet 3 :
No Name1 Name2
1 abc efg
2 eds xyz
3 aaa
4 def
5 dss
6 ddd
-------**--------
|