Pull Specific Data from one Sheet to Another using Macro

[MarkHutch]

Hi

I was wondering if anyone was able to help. I have a set of data in one Sheet and I need specific Data from that sheet moved to a second sheet and a comment added. So For example Sheet 1 has Columns A through E with all employees data. I would need this data moved to sheet 2, which has those columns plus extras through to column K. But I would need only specific employee’s info. This I’m hoping could be done by say ID and for instance take only 50012345 John Smith and 50098765 Adam Apples (along with the rest of the relevant info for dates, start time and finish time. Column F is then normally blank. For those same specific employees, I would need this to be populated with the word ‘Travel’. Then again in the comments section, a comment would need to be added, which is again specific to the employee (ID number). Is this possible to do with a macro? Right now we are having to manually do this and it takes ages.
Some data may also already exist in Sheet 2, Would it be possible for any new data being brought into this to be applied under the data already in there. Or would it need to be a completely different sheet and then a copy and paste done?

Any assistance you can provide would be greatly appreciated. This is doing my head in
Thanks

Safe journeys

Mark

A	B	C	D	E	F	G	H	I	J	K
Name	ID	NA Date	StartTime	FinishTime	NonAvailability	CommentText	Street	City	PostCode	CountryID
John Smith	50012345	15/07/2016	00:00	08:59	Travel	Gone Shopping
John Smith	50012345	16/07/2016	00:00	23:59	Travel	Gone Shopping
John Smith	50012345	17/07/2016	00:00	23:59	Travel	Gone Shopping
John Smith	50012345	18/07/2016	00:00	08:59	Travel	Gone Shopping
Bob Brown	50076543	01/08/2016	17:00	23:59	Travel	Visiting Parents
Bob Brown	50076543	02/08/2016	00:00	08:59	Travel	Visiting Parents
Bob Brown	50076543	02/08/2016	17:00	23:59	Travel	Visiting Parents
Bob Brown	50076543	03/08/2016	00:00	08:59	Travel	Visiting Parents
Adam Apples	50098765	27/07/2016	17:00	23:59	Travel	Gone Fishing
Adam Apples	50098765	28/07/2016	00:00	08:59	Travel	Gone Fishing
Adam Apples	50098765	28/07/2016	17:00	23:59	Travel	Gone Fishing
Adam Apples	50098765	29/07/2016	00:00	08:59	Travel	Gone Fishing
Adam Apples	50098765	29/07/2016	17:00	23:59	Travel	Gone Fishing

<tbody>
</tbody>

 

[MarkHutch]

Thanks I'll give that a try. Legend!!!
It said it was yourself. Maybe it was just delayed.

 

[Fluff]

Must have been, I didn't post anything between post#6 & post#10

 

[MarkHutch]

Hi

That worked perfectly for copying all data, inputting the 'Travel' text and applying the relevant comment as per the ID. thank you very much

 

[Fluff]

Glad to help & thanks for the feedback