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.

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

John
-----Original Message-----
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.
.

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.


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

John
-----Original Message-----
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.
.
Reply