Smart worksheets???

[mercedes king]

Sorry I couldn't come up with a better subject line but I
have no idea what this is...
We received an excel file from a company for whom we are
an agent. They sent the same file to hundreds of agents
around the world. The file contains details of all the
agents and was sent for each agents to updated their
details and send back.
The thing I found VERY bizarre is that in the sheet we
received (which is the same one that's been sent to
everyone else), the company details that the compny
currently has for us (the ones that we need to update)
show under the headings but no-one else's info shows.
How can this be done? How do you send a file to hundreds
of different companies and have it so when each company
opens the file, they only see their own info and not the
info of all the other companies???
I'd love to know as I'm trying to do something that would
be greatly simplified if I knew how to do this.
Thanks
mercedes

 

[Bernie Deitrick]

mercedes,

Are you sure that it is the _same_ file? Is all the other information in
the file?

One way that this could be done is a simple looping macro: filter the file
to show just some data, then save the file, and send it out as an email
attachment to the person whose data is showing. Repeat as many times as
needed. OR delete all but the appropriate data, save a copy of the file,
send the copy out, etc.

The other way that it could be done is to read the username from the
computer: if that is part of the database, a macro could filter the data
based on that value when the file is opened.

HTH,
Bernie
MS Excel MVP