copy paste formula

  • Thread starter Thread starter penser
  • Start date Start date
P

penser

I'm trying to set up a formula that would automaticaly copy and paste
text from the cell it's being inputed into, to seprate lists on the
same spreadsheet; each list resulting an alphabetical range ( a-p, q-t,
etc. )

for exapmle, I input the text " Allan " in to cell O2 and it
automatically copies " Allen " to a seperate only reciving text
starting with the letter "A"; as so it would not copy and past text to
it if the orignal inputed text was " Brian "

I know... I'm crazy... but any help would be appriciated.

Thanks!
 
If all you want to do is copy one cell to another cell, depending on the
first number, do something like this:

=IF(LEFT(O2,1)="A",O2,"")

If the letter begins with "A", it will take what is in O2 and copy it to
where the formula is. To designate a different letter, change it in the
formula.

tim
 
Thank you very much Tim.. this works great..
can I do the same thing for multiple cells? For example, can select
range of cells to be checked and copied per the beginning letter, the
have them copyed to another range of cells to reslut in list?

Thank you again
 
I think I am unable to do it for multiple cells / or multiple
alphabetical choices... if I'm wrong.. please let me know... thanks!
 
Can you be a little more specific. I'm not sure, exactly, what you are
attempting to do.

Thanks,

tim
 
I have set up a " Calender" in excel, each date a seperate cell.
within each date I am inputing a proper name. I then want to creating a
running list of each name alphabeticlay.

I was curious if there was a formula i could apply to to either the
calender date cells or to the cells in the running list to have the
proper names autmaticly coppied alphabeticaly to the list.

I know this is a rather silly funtion to do in excel, but I thought it
might be with a shot.

Thanks for your time and help in my endevor..

:o)
 
Hi Penser,

I believe the best way would be to use a worksheet change even in VBA to
find the entry and add it to a sorted list, in alphabetical order. If you'll
send me the file, I'll insert the macro and give you an explanation of what
is going on (it's a slow day).

tim
 
Back
Top