Copy Columns and Paste into Rows

[nerojr]

Hi everyone,

I have a spreadsheet titled Associate Skill Set that I need to copy row 5, Columns J through BA and then paste into sheet titled 1. The Assoicate Skill Set sheet could show upto 4 different values per column: either blank, S, T or O. The sheet that I need to paste to "1", lists everything in Column C, row 38 through 85. So, is there a way to copy columns, and then input the value into a row on a different sheet? I hope this makes sense.

Thanks

 

[texasalynn]

sounds more like you need to paste into a column based off the value? Is that right? Post a small sample of the details and the expected results

 

[nerojr]

Since I cannot download the html program to my work laptop, I'll try to explain a little better.

So all work type names are in Columns J:BA in row 4 of Sheet1. Starting in row 5, I have listed out each individuals name and what work types they know. For each individual Columns J:BA would show either blank (if they don't know this work type), S (for skilled in this work type), O (if training is outdated) or T (if training is in progress). I need to have these letters moved to sheet2. Their destination will be the corresponding work type (Column A), but the letter will need to be placed in Column C. I hope this is more helpful.

 

[texasalynn]

you can copy and paste from excel to your post. Just have borders put around all of your cells in excel, then they will show here. Example

<TABLE style="WIDTH: 96pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=128 x:str><COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT: 12.75pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl22 height=17 width=64>Title</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl22 width=64>Post</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl22 height=17>Job1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl22>S</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl22 height=17>Job3</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl22>P</TD></TR></TBODY></TABLE>

 

[nerojr]

Awesome, thanks for the tip. Here are my screenshots: Here are the worktypes, these names remain the same on sheet1 and sheet2, though in a different order. I have added column #'s for sheet1

J4 K4 L4 M4 N4 O4

<TABLE style="WIDTH: 114pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=150 x:str><COLGROUP><COL style="WIDTH: 19pt; mso-width-source: userset; mso-width-alt: 914" span=4 width=25><COL style="WIDTH: 19pt; mso-width-source: userset; mso-width-alt: 914" span=2 width=25><TBODY><TR style="HEIGHT: 202.5pt; mso-height-source: userset" height=270><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: red; WIDTH: 19pt; HEIGHT: 202.5pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl27 height=270 width=25>Mailbox IM's only</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: red; WIDTH: 19pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl28 width=25>Notes to Coding</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: red; WIDTH: 19pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl28 width=25>PRS</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: red; WIDTH: 19pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl28 width=25>Refunds (validation)</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #99ccff; WIDTH: 19pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 width=25>Reinstatements</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #99ccff; WIDTH: 19pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 width=25>Aged List</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND: #cc99ff; HEIGHT: 12.75pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" class=xl30 height=17>S</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND: #cc99ff; BORDER-TOP: #e0dfe3; BORDER-RIGHT: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" class=xl31>S</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND: #cc99ff; BORDER-TOP: #e0dfe3; BORDER-RIGHT: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" class=xl31>S</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND: #cc99ff; BORDER-TOP: #e0dfe3; BORDER-RIGHT: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" class=xl31>S</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND: #99cc00; BORDER-TOP: #e0dfe3; BORDER-RIGHT: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" class=xl26 width=25>T</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 19pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: windowtext 0.5pt solid" class=xl26 width=25> </TD></TR></TBODY></TABLE>


I need a macro that will collect all the S's, T's for each worktype in Row5 and move them to the corresponding work types in sheet2.

<TABLE style="WIDTH: 357pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=476 x:str><COLGROUP><COL style="WIDTH: 228pt; mso-width-source: userset; mso-width-alt: 11117" width=304><COL style="WIDTH: 66pt; mso-width-source: userset; mso-width-alt: 3218" width=88><COL style="WIDTH: 63pt; mso-width-source: userset; mso-width-alt: 3072" width=84><TBODY><TR style="HEIGHT: 13.5pt; mso-outline-level: 1" height=18><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #ccffcc; WIDTH: 228pt; HEIGHT: 13.5pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: windowtext 1pt solid" class=xl28 height=18 width=304>Aged List</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ccffcc; WIDTH: 66pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: windowtext 1pt solid" class=xl30 width=88> </TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl31 width=84> </TD></TR><TR style="HEIGHT: 13.5pt; mso-outline-level: 1" height=18><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 228pt; HEIGHT: 13.5pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl27 height=18 width=304>Breakdowns</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 66pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl26 width=88> </TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl31 width=84> </TD></TR><TR style="HEIGHT: 13.5pt; mso-outline-level: 1" height=18><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #ccffcc; WIDTH: 228pt; HEIGHT: 13.5pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: windowtext 1pt solid" class=xl28 height=18 width=304>Reinstatements</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ccffcc; WIDTH: 66pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl29 width=88> </TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl31 width=84> </TD></TR></TBODY></TABLE>

Ex: If there is a T in Column N Row 4 on sheet1, the macro will move the T to Column A Row 81 on sheet2

 

[texasalynn]

is this what you need?

Excel Workbook
	A	B
1	Aged List	0
2	Breakdowns	#N/A
3	Reinstatements	T
4	Mailbox IM's only	S
5	Notes to Coding	S
6	PRS	S
7	Refunds (validation)	S
Sheet2

Excel 2003

Cell Formulas
Range	Formula
B1	=INDEX(Sheet1!$J$2:$O$2,,MATCH(Sheet2!A1,Sheet1!$J$1:$O$1,0))
B2	=INDEX(Sheet1!$J$2:$O$2,,MATCH(Sheet2!A2,Sheet1!$J$1:$O$1,0))
B3	=INDEX(Sheet1!$J$2:$O$2,,MATCH(Sheet2!A3,Sheet1!$J$1:$O$1,0))
B4	=INDEX(Sheet1!$J$2:$O$2,,MATCH(Sheet2!A4,Sheet1!$J$1:$O$1,0))
B5	=INDEX(Sheet1!$J$2:$O$2,,MATCH(Sheet2!A5,Sheet1!$J$1:$O$1,0))
B6	=INDEX(Sheet1!$J$2:$O$2,,MATCH(Sheet2!A6,Sheet1!$J$1:$O$1,0))
B7	=INDEX(Sheet1!$J$2:$O$2,,MATCH(Sheet2!A7,Sheet1!$J$1:$O$1,0))