I excel, I want many other sheets and also a new sheet cell c1 is appear in sheet1 a1. Please tell me the formula.

Quote:

---

Originally Posted by M-Junaid

i excel, i want many other sheets and also a new sheet cell c1 is appear in sheet1 a1. please tell me the formula.

---

It is not clear what you want. You can add sheets using the "Insert" tab and clicking "Worksheet." If you want b1 from sheet X to appear in a1 on sheet Y, just copy and paste. Or type = in a1 on sheet Y, then move to sheet X and click on cell b1. Hit enter and you will get what you want.

You can't have a sheet appear in another sheet. What you CAN do is reference a value from another sheet. The formula is =Sheetname!celladdress

Quote:

---

Originally Posted by ScottGem

You can't have a sheet appear in another sheet.

---

Is that what the OP wanted to do? You can insert all the contents of another sheet using "Import External Data" on the data tab. The imported data will take up the same table space at it did in the original sheet. So if sheet1 was to show data from other sheets, the Import External Data procedure could be used to add them sequentially to the next available column. I don't why OP would do this since it is much easier just to copy and paste.

Quote:

---

Originally Posted by Chic_Bowdrie

Is that what the OP wanted to do? You can insert all the contents of another sheet using "Import External Data" on the data tab. The imported data will take up the same table space at it did in the original sheet. So if sheet1 was to show data from other sheets, the Import External Data procedure could be used to add them sequentially to the next available column. I don't why OP would do this since it is much easier just to copy and paste.

---

I was assuming the OP wanted it to appear as if the other sheet was embedded with its own column and rows.