copy data from sheet to a table on another sheet...

Hello All,

I am having major difficulty figuring out the correct syntax to copy from cells in the "Input" sheet to the corresponding columns in the table on the "Tracking" sheet, adding a new row for the next input set and the coping only some of the data into the appropriate tables on the "Source" sheet then new rows added as well. I am pretty certain i need to have the new rows added after the data is copied. The purpose for the "Source" sheet is a refference. I will eventually have a macro run a check to be certain the resource has not already been ordered for that student, if It has it will warn the user. That is for later though. Any thoughts on how to attain this?

Thank you,

Ben Bristow

You could try something like this:

Please Login or Register  to view this content.

You will have to repeat the last line before "End Sub" for all fields, adapting the cell addresses.... Let me know if this works for you

Something like this.

Please Login or Register  to view this content.