Advanced Copy????

wintye

New Member
Joined
Apr 15, 2013
Messages
15
Hello

I would really appreciate any help you can offer.

1234567891011121314151617181920
35142230443514
61215163144612612151516
111721293044111117212917
2635384347492635
3591314383591314
2327293944232272939
91732364244917917
25212225322525
71723323842717717

<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
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

kevatarvind

Well-known Member
Joined
Mar 3, 2013
Messages
1,047
Office Version
  1. 365
Platform
  1. Windows
try below

Excel Workbook
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQAR
112345678910111213141516171819202122232425262728293031323334353637
23514223044 35142230
361215163144612151631
41117212930441117212930
52635384347492635
63591314383591314
72327293944232729
8917323642449173236
925212225322521222532
10717233238427172332
Start
 
Upvote 0

wintye

New Member
Joined
Apr 15, 2013
Messages
15
Spreadsheet Formulas
CellFormula
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?
 
Upvote 0

kevatarvind

Well-known Member
Joined
Mar 3, 2013
Messages
1,047
Office Version
  1. 365
Platform
  1. Windows
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
 
Upvote 0

wintye

New Member
Joined
Apr 15, 2013
Messages
15
ADVERTISEMENT
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?
 
Upvote 0

kevatarvind

Well-known Member
Joined
Mar 3, 2013
Messages
1,047
Office Version
  1. 365
Platform
  1. Windows
No you no need to fill color those i just colored its if you like you can otherwise no need to color
 
Last edited:
Upvote 0

wintye

New Member
Joined
Apr 15, 2013
Messages
15
ADVERTISEMENT
I would also like for the cell to have all borders and a yellow fill??
 
Upvote 0

kevatarvind

Well-known Member
Joined
Mar 3, 2013
Messages
1,047
Office Version
  1. 365
Platform
  1. Windows
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
 
Upvote 0

wintye

New Member
Joined
Apr 15, 2013
Messages
15
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
 
Upvote 0

kevatarvind

Well-known Member
Joined
Mar 3, 2013
Messages
1,047
Office Version
  1. 365
Platform
  1. Windows
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 ?
 
Last edited:
Upvote 0

Forum statistics

Threads
1,195,617
Messages
6,010,729
Members
441,565
Latest member
menangterus556

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top