Hello
I have been working with VBA for a short time and have accomplished part of what I wanted to do. The part that I am having difficulty with is copying and pasting 2 or more cells from a worksheet into a second worksheet.
The data is held in an employee training list. I would like to select the active cell of the equipment type and then have the information that relates to who has been trained on that equipment sent to the "equipment" worksheet. There will be multiple names from column a and corresponding active column dates for that piece of equipment copied.
Equipment 1
Employee Name
John Smith 01/01/2011
Jane Smith 01/02/2011
Mary Smith
The Equipment sheet would list the equipment at the top of the sheet and then list the employees and training dates for the employees who have completed the training.
Any help would be much appreciated.
Thanks
I have been working with VBA for a short time and have accomplished part of what I wanted to do. The part that I am having difficulty with is copying and pasting 2 or more cells from a worksheet into a second worksheet.
The data is held in an employee training list. I would like to select the active cell of the equipment type and then have the information that relates to who has been trained on that equipment sent to the "equipment" worksheet. There will be multiple names from column a and corresponding active column dates for that piece of equipment copied.
Equipment 1
Employee Name
John Smith 01/01/2011
Jane Smith 01/02/2011
Mary Smith
The Equipment sheet would list the equipment at the top of the sheet and then list the employees and training dates for the employees who have completed the training.
Any help would be much appreciated.
Thanks
