How do I copy previously entered data

S

Snoopy

If I enter related data in A1 and C1 and then type the same data as A1 in A4,
how do I get the data in C1 to automaticallyh appear in C4?
 
S

Snoopy

Hi Frank,

Thanks for the information, I tried it and it works.
One further question if I may?
If I type the info in A1 in multiple places in columnA, can excel be
configured to
repeat the related info in c1 in the correct row in column c without typing
the formula in each cell that I want the info to appear in?

Regards,
 
F

Frank Kabel

Hi
can you give some example data. Also where do you want the output
displayed?
 
S

Snoopy

Hi Frank, What i am looking for is a way to make multiple copies of a row
(of nonadjacent cells) in different places where it appplies on my worksheet.
The need to duplicate the info may or may not be needed. Or it may be needed
multiple times for multiple source material.

Lets start out by saying I have information in row 5 and different
information in each of Rows 6, 7,8 etc. Each row has info in non adjacent
cells. As I need to enter info into say row 10, it may be exactly like the
info in row6. Since the info in the same column will repeat if the first few
letters are the same as that above. is there a way to setup some formula to
call the information in any lower number row, to a higher number row, just by
starting to type the info in the higher number row, besides using a copy and
paste method?

Regards,
 
S

Snoopy

An additional way to describe the inquiry is:

if data is entered anywhere in column a with referencing data in the same
row in column c, then when the same data is entered in any later row in coumn
a, I need the same reference data to show up in column c.

Hoping this helps,
 
F

Frank Kabel

Hi
not really possible as you can't have both: formulas and values in the
same cell.

You could of course try the following in cell C2:
=IF(A2<>"",VLOOKUP(A2,$A$1:$C1,3,0))
and copy this down.

Of course you have to overwrite this formula if you want to enter new
data
 
Top