Not exactly. The problem I'm having is I'm doing everything by person's
names. Taking a line of code under one person's name and copying it to
another workbook uner that same person's name. I can have the sheets named
after a person or just search down a sheet to find the name and then insert
it in the next blank space.

The biggest problem is storing the person's name, then referring to it in
the next workbook, either in a singal worksheet or a sheet by that name.

Not sure I'm going to be ab;e to make it work.

Thanks,

Ron

"Don Guillett" wrote:

Did Jacob answer all your question

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ron" wrote in message
...
Nah...work work I do at home....and sometimes at work, if I have time...

Actually tried to explain what I needed before, but explanation was too
complicated...no one answered...LOL

My main problem is syntax....once I have that down, I can write the
cludgiest code around....but it (usually) works...LOL

Ron

"Don Guillett" wrote:

Homework?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ron" wrote in message
...
Can someone provide:

1. the syntax for copying a complete line from one spreadsheet to
another?
Does the second one have to be open?

2. syntax for inserting a complete line in a different spreadsheet, on
the
next blank line of a sheet, moving the rest on the lines down?

3. the syntax for copying a complete line at the end of a sheet on a
different spreadsheetspreadsheet.

I'm going to try to use that to put together a complicated macro.

Thanks,

Ron