Posted by: hitmeonce October 14, 2009
excel help
Login in to Rate this Post:     0       ?        
You mean if you type "wheels" in column A1 it should appear in B1?

like:






    A    B
wheels wheels

Go to column B and type =A1 (what ever you have on column A1 will appear there)

Or if you want  to import sheet1(table) to sheet 2 table anywhere
copy the table (data) from Sheet1 and paste in Sheet2 and make sure you use link on the drop down..

it will look like this....      =Sheet1!$A$2

Unless I am not understanding your statement....


Read Full Discussion Thread for this article