Prev: Copying from one worksheet to multiple worksheets
Next: rounding currency amounts
From: Riptide on 13 Jan 2010 15:59
I need to create a master file which lists all projects an employee is
working on all in one tab. It also has to automatically update as the
employees enter their information in order to keep track of employees who
might be looking for work or not.

So I need in Master File cells from A1 to D6 reference a file from employee
#1.

Than in the master file have cells from A8 to D13 reference a file from
employee #2 and so on.

I know it can be done, but just don't know where to start.
From: Don Guillett on 13 Jan 2010 16:23
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"Riptide" <Riptide(a)discussions.microsoft.com> wrote in message
news:54AFF26F-9714-4BEF-BE61-B3E0B9A96AED(a)microsoft.com...
>I need to create a master file which lists all projects an employee is
> working on all in one tab. It also has to automatically update as the
> employees enter their information in order to keep track of employees who
> might be looking for work or not.
>
> So I need in Master File cells from A1 to D6 reference a file from
> employee
> #1.
>
> Than in the master file have cells from A8 to D13 reference a file from
> employee #2 and so on.
>
> I know it can be done, but just don't know where to start.

 | 
Pages: 1
Prev: Copying from one worksheet to multiple worksheets
Next: rounding currency amounts