Repeating Data from One Cell in Another

[beastlet]

This has got to be the easiest question, but I can't figure this out.

I want the data from column A1 to be repeated in A10, B1 to be repeated in B10, etc. Is there a formula I can put in the top of the column to make this true for all columns? I've tried searching to find the answer, but probably haven't hit upon the right search terms.

Thanks,
~beastlet~

 

[schielrn]

Welcome to the Board!

In A10 put in =A1 and then drag the formula to the right and it should keep updating the column.

Hope that helps.

 

[edokhotnik]

This has got to be the easiest question, but I can't figure this out.

I want the data from column A1 to be repeated in A10, B1 to be repeated in B10, etc. Is there a formula I can put in the top of the column to make this true for all columns? I've tried searching to find the answer, but probably haven't hit upon the right search terms.

Thanks,
~beastlet~

Enter in A10
<code> =A1 </code> and then copy it across the columns you want.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K
1	5	10	15	20	25	30	35	40	45	50	55
2	*	*	*	*	*	*	*	*	*	*	*
3	*	*	*	*	*	*	*	*	*	*	*
4	*	*	*	*	*	*	*	*	*	*	*
5	*	*	*	*	*	*	*	*	*	*	*
6	*	*	*	*	*	*	*	*	*	*	*
7	*	*	*	*	*	*	*	*	*	*	*
8	*	*	*	*	*	*	*	*	*	*	*
9	*	*	*	*	*	*	*	*	*	*	*
10	5	10	15	20	25	30	35	40	45	50	55
Sheet1

 

[beastlet]

Now, how do I make this be effective for new data?

I succesfully did this and for all my current data it worked. In all unoccupied cells it put a 0. If I add new entries, I want those zeros in column P to become what I entered in column B. Is there a way to do that?

Thanks again,
~beastlet~