Help needed for a newbie!

[anowan]

Hi,

I have an excel sheet (1) where the first column (A) is the age, name of the person and the subsequent colums are the data needed. I'm looking for a code where I could copy-paste the first column (A) and the first three columns of data to a new sheet (2) , and then it would loop back copying the same first column but with the next 3 columns beneath the first set of data on the same sheet....

I've tried to used macro but it didn't worked really well...

thanks in advance !

 

[hiker95]

anowan,

Welcome to the MrExcel forum.

What version of Excel are you using?

You will generally get much more help (and faster) in this forum if you can post your small samples (what you have and what you expect to achieve) directly in the forum.

To attach screenshots, see below in my Signature block: Post a screen shot with one of these:

 

[anowan]

Excel Workbook
	D	E	F	G	H	I	J	K	L	M	N	O	P
13	Annett Sue	Annett Sue	Annett Sue	Andrea Stelmach	Andrea Stelmach	Andrea Stelmach
14	The client of the person named above	The manager of the person named above	The person named above	The client of the person named above	The manager of the person named above	The person named above			Self-Confidence
15	5	5	1	5	3	1			I am comfortable with who I am
16	5	5	2	4	3	1			I am aware of which emotions cause me the most trouble
17	5	5	2	4	3	1			I am aware of the areas I need to work on
18	5	5	2	4	2	1			I am able to laugh at my mistakes
19	4	4	2	4	2	1			I believe to be capable for a job
20	4	4	2	4	2	2			I doubt my own ability
21	4	4	2	4	3	2			I present myself in an assured manner
22	3	4	2	4	3	2			I have '' presence ''
23	3	4	2	4	3	2
24	3	4	2	4	3	3			Adaptability
25	2	4	3	4	3	3			I am able to accept events I cannot control
26	2	4	3	4	2	3			I am able to put my failures behind me
27	2	3	3	4	2	3			I maintain a positive and optimistic attitude
28	2	3	3	4	2	3			I am able to persevere when treated unfairly
29	2	3	3	3	2	3			I can be flexible with standard procedures
30	2	3	3	3	2	3			I am able to adapt ideas based on new information
31	2	3	3	3	2	3			I am able to handle unexpected demands well
32	3	3	3	3	2	3			I am able to change overall strategy, goals, or projects to fit the situation
Sheet1

Excel 2007

It's only a sample of the data i need to work with, but basically, I need to be able to take the data that belongs to the same person, paste it to a new sheet with the titles in column L, then go to the next person, take the data that belongs to that person and copy-paste it to a new sheet.

 

[hiker95]

anowan,

Can we have a screenshot of the new worksheet for Annett Sue, manually formatted by you.