Advanced Copy????

[wintye]

Hello

I would really appreciate any help you can offer.

							1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20
3	5	14	22	30	44				3		5									14
6	12	15	16	31	44				6		12	6						12		15	15	16
11	17	21	29	30	44							11					11	17			21	29	17
26	35	38	43	47	49												26						35
3	5	9	13	14	38				3		5				9				13	14
2	3	27	29	39	44			2	3		2				27				29	39
9	17	32	36	42	44			9	17						9								17
2	5	21	22	25	32			2			5				2								5
7	17	23	32	38	42			7			17		7										17

<tbody>
</tbody>

Along the top, I have the numbers 1 through to 20.
On the left I have 6 cells I will be entering any of the numbers from 1-20 and I want the number I type there to copy over to the correct cell on the same row.

For example, looking at top row, I entered 3, 5, 14, 22, 30 & 44. As you can see from the first part of the table the number 3 has been entered under the header 3, the number 5 has been entered under the header 5 and so on (I've only copied a snippet of the spreadsheet over).

I want to be able to enter in the 6 numbers on the left and then have it automatically copy over to the correct cell under the correct heading. I don't know how to do this other than copying and pasting and this takes forever. Is there a way I can set something so it will automatically enter the same information under the correct heading???

I'm very new to Excel but am desperate to figure this out. I'm sure it's something easy but for me difficult to explain. I really appreciate any advice given.

Thank you

 

[kevatarvind]

try below

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR
1								1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	32	33	34	35	36	37
2	3	5	14	22	30	44				3		5									14								22								30
3	6	12	15	16	31	44							6						12			15	16															31
4	11	17	21	29	30	44												11						17				21								29	30
5	26	35	38	43	47	49																											26									35
6	3	5	9	13	14	38				3		5				9				13	14
7	2	3	27	29	39	44			2	3																								27		29
8	9	17	32	36	42	44										9								17															32				36
9	2	5	21	22	25	32			2			5																21	22			25							32
10	7	17	23	32	38	42								7										17						23									32
Start

 

[wintye]

Spreadsheet Formulas

Cell Formula H2 =IF(ISERROR(MATCH(H$1,$A2:$F2,0)),"",H$1) <tbody> </tbody>

<tbody>
</tbody>

[/QUOTE]


Hi

Thank you for your help. I copied the above formula in the cell H2 and tried removing the numbers on the left to the re-enter them differently. It didn't seem to do anything?

Would it be a macro I need to do?

 

[kevatarvind]

H2 is for only one cell formula you have drag right and down the formula

or you can upload your excel file sample data any sharing site i will put formula and give to you

 

[wintye]

Oh thank you so much. I love it. Didn't think to copy it over. I'm so used to doing just the basics.

I would also like to fill the cell background yellow for those numbers. Does that mean changing the formula?

 

[kevatarvind]

No you no need to fill color those i just colored its if you like you can otherwise no need to color

 

[wintye]

I would also like for the cell to have all borders and a yellow fill??

 

[kevatarvind]

I would also like for the cell to have all borders and a yellow fill??

No there is between formula and Data Format no Connection formula will work if you want you can format it other wise no need just put the formula it will work

 

[wintye]

Hi

I'm not sure I understand your reply. I can make the borders appear with the same formula but I'm not sure how to make the background of the cell the yellow colour unless I actually select it afterwards. I only want the number under the heading showing the yellow background. Example: the 3, 5, 14, 22, 30 & 44 I would like the background of just those cells, yellow. I don't want to change the background colour separately.

Is there anything I can do for that?
Thank you so much again for your help

 

[kevatarvind]

then those All Range you need to use conditional formating want to know about that let me know ?

and which version of Excel are you using ?