1.

Solve : Excel Help!!!!!?

Answer»

I need to create a search field for my work spread sheet.

Spread sheet one i have a few different fields that if you type in 010 (a store #) or Door (the product) all info in SPREADSHEET 2 (info i have put in) will show up in spreadsheet 1.  anyone know what im TALKING about or how to do this.

PLEASE HELP!!I know exactly what you mean. I had to do this myself not too long ago, but I forgot how. Let me look it up.

You need to start the formula with the name of the spreadsheet you want to copy from.

For EXAMPLE: =Tab2!G17:I17.

Where Tab2 is the name of the spreadsheet (Assuming you are working in a spreadsheet called something else than Tab2) and G17:I17 are self explanatory.

Does this make sense?

Awesome!and then how do i link it to the specifc data Quote

For example: =Tab2!G17:I17.  


Quote
=Tab2 this is the spreadsheet you want to link to


Quote
!G17:I17 this is the info you want to link to


If you are in need of anything else, I can not help you. It has been too long ago.Thanks it helped a bitUnfortunate that I could not be of more assistance.

We need an OFFICE expert around here. Stick around?


Discussion

No Comment Found

Related InterviewSolutions