I get spreadsheets sent from various departments like "accounts" or "personnel" and others.

I have no problem importing them into filemaker.

I would like import them knowing where they had come from.

If I got a sheet of 5000 names from "personnel" when i import them into filemaker i need to have some way

of knowing that 5000 was from "personnel"

The same with the other spreadsheets as well.

can this be done?

Yes. Make a "source" field in the table, and after performing the import, use the replace command to set an appropriate value. This can also be scripted.

can this be done?

Thanks, any chance of an example script?

Edited May 4, 201114 yr by Lee Smith
do not post the whole block of text, only the part that is relevant