Concatenating multiple cells to a single cell between 2 tabs

[Legacial]

Hey guys. I'm pretty new at VBA and macros as it is and I have a certain problem. The objective I’m aiming at is to copy the following information from the input excel sheet to the sheet 2 excel Tab in a specific format.
I have 5 columns (course, code, fee, year, avg) for 5 students in sheet 1. These are based on the enter and leave times. I want to to have either VBA code or macro that can concatenate the data in these columns into single cells in sheet 2 such that such that they are based on the time in the "enter" column in sheet 1 and arranged in this format: (course, code, avg, fee, year). I have attached the necessary document and provided an example for 1 cell in sheet 2.
Please assist me as I have no clue as to get around this. Thanks a bunch!

[antoka05]

See attached file where I added this macro:

Please Login or Register  to view this content.

Regards,
Antonio

[Legacial]

Thanks a bunch!! That was exactly what I needed!!
By the way, does the same code work for another tab if all I do is to change the column numbers denoted in the code and the tab number?? Lets say for sheet 3, I want to concatenate values from sheet 1 based on other additional columns with different column numbers.
Regards,
Harry

[antoka05]

Yes, if you change the row:

Please Login or Register  to view this content.

in

Please Login or Register  to view this content.

the variable sh2 will refer to sheet3.
Regards,
Antonio

[Legacial]

I've tried changing the sheet number but it brings me a run-time error 6:overflow. I think the problem lies with the data format since I want to use a time in this instance instead of an integer. But I don't know how to put that into code.
Please check the attached document to see where I could have gone wrong.

Regards,
Harry.

[antoka05]

In the file you attached the command box in sheet3 is linked at a macro 'aaa' that is not present in the workbook.
I copie my macro1 in macro2 (where I changed sh2 references to sheet3) and then I assigned macro2 at the command button.
Regards,
Antonio

[Legacial]

Sorry for bothering, but how do you space the concatenated results in the cell?

[Legacial]

Oh, I spaced them. Thanks so much for your help!

Regards,
Harry.