Prev: Are there any Excel macros for a simple countdown timer?
Next: AVERAGEIF FORMULA EXCEL 2007
From: juanpablo on 12 Apr 2010 16:30
ok fixed it, thanks.

"juanpablo" wrote:

> Yes, but the cell text I have here is:
>
> "ARES PERÚ SAC.
> Avnda. Victor Malazquez
> Manzana A1,Lote 4 Santa Rosa de Manchay
> Lima, Perú
>
> Tel:+511-345-5049 Fax#108
> RUC: 20504169848"
>
> and after selecting that info it does not find it and does not copy the cell
> adjacent, i dont know why.
>
>
>
>
>
> "trip_to_tokyo" wrote:
>
> > Juan, it still works for alpha as well.
> >
> > Quick example.
> >
> > Sheet2 A2 put A
> >
> > Sheet2 B2 put Apple
> >
> > Now in Sheet1 A2 put A and it will pull back Apple in cell B2.
> >
> > Just play with the rest of the data and you should find it gives you what
> > you want.
> >
> > If my comments have helped please hit Yes.
> >
> > Thanks.
> >
> >
> >
> >
> >
> > "juanpablo" wrote:
> >
> > > Thanks but this is for numbers, the values im looking are text on both columns.
> > >
> > > "trip_to_tokyo" wrote:
> > >
> > > > EXCEL 2007
> > > >
> > > > Juan, please check out:-
> > > >
> > > > http://www.pierrefondes.com/
> > > >
> > > > Item number 93.
> > > >
> > > > 1. If you copy the formula in cell Sheet1 cell B6 down a few cells (say B7
> > > > to B10).
> > > >
> > > > 2. Now put 200 or 500 or 600 or 400 in any of cells A 7 to A 10 and the
> > > > corresponding cells in column B will be completed.
> > > >
> > > > The, "conversion table" is found in Sheet 2.
> > > >
> > > > If my comments have helped please hit Yes.
> > > >
> > > > Thanks.
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > "juanpablo" wrote:
> > > >
> > > > > Hello,
> > > > >
> > > > > Im using data validation to enter information from a list of company
> > > > > addresses.
> > > > > Can someone associate a name for example for a certain address and copy it
> > > > > to the next cell, everytime someone selects that specific company address???
From: wild turkey no9 on 12 Apr 2010 17:29

Worked like a charm. Many thanks, Micky

"מיכאל (מיקי) אבידן" wrote:

> Assuming you want to have the letters a --> e.
> As the Source type: X,a,b,c,d,e - where instead of the X you will press the
> key combination: ALT+0160
> [use the small numeric pad to for the digits].
> Micky
>
>
> "wild turkey no9" wrote:
>
> > Guys
> >
> > Using version 2003. I'm enterng a comma separated text list in the data
> > validation source dialog box. Is there a way to make the first list entry
> > blank?
> >
> > Thanks in anticipation
> >
> > Kevin
First  |  Prev  | 
Pages: 1 2
Prev: Are there any Excel macros for a simple countdown timer?
Next: AVERAGEIF FORMULA EXCEL 2007