for every infn. i key in a row in excel sheet automatically a sheet containing that infn.shud appear.possible?

Question

for example i key some data in a row in one excel sheet. that data shud automatically post itself in another sheet in a specified format. is that possible?

Answer 1

The key you made is in the left most column, Right?
So
Use this function in B1 in Sheet2
=VLOOKUP( A1, Sheet1!A:D, 2, FALSE)
This will brings the second field of the key you typed in A1 in Sheet2, searching for it in Column A in Sheet1

I still have alot lot of solutions using function

Enjoy my profile, I am the VBAXLMan

Answer 2

Just want to make sure this is what you want -
1. Let's say you have a sheet 1 & a sheet 2 in the same Excel workbook.

2. Every time you enter something into A1 in sheet1 (font = Arial, size = 10 Regular), you want the same value appears in B2 of sheet2 (font = Times New Roman, size = 14 Bold).

3. You should enter the following fomula in sheet 2 cell B2 -
"=Sheet1!A1"

4. Use "Format" > "Cells" to set the format for B2