Help for a VBA rookie

F

Frank C

I have a work sheet, that is titled "DATA", there are 6 Columns,
consisting of Name, Mon, Tues, Wed, Thurs, Fri.. I have a second
sheet titled "Submit".

I would like a Macro that would match the name from "DATA" and take
the Contents of the cells in that row, and move them to "Submit"
worksheet.

Any suggestions, help, or direction would be appreciated.
 
J

John

Is the idea to enter a name on "submit", and press a
button to move the data onto that sheet?

John
 
F

Frank C

The sheet containing data is already completed. Using VBA with a
match function. Fill in the rows on the sheet "Submit" with the data
from the sheet "DATA" for each indivdual listed. the listing on each
worksheet, do not match perfectly, row to row, that is the reason for
using a match type approach.
 
Top