the data for a single user, and sending that to the end-user.
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Paul Schreiner
Sent: Monday, September 10, 2012 12:06 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ detecting
Hi,
You can try this.
=INDEX('YTD Output'!$F$2:$F$228,MATCH('YTD Performance'!C8,'YTD
Output'!$C$2:$C$228,0))
=INDEX('YTD Output'!$H$2:$H$228,MATCH('YTD Performance'!C9,'YTD
Output'!$F$2:$F$228,0))
Regards,
Kuldeep Singh
On Mon, Sep 10, 2012 at 10:34 PM, Midhun Thampan
Here's something I threw together from macros I already had.
I didn't spend too much time on it.
I hope they have what you're looking for.
There are several things you MENTIONED that I tried to include.
Since you want the user to view ONLY his performance,
I added filters to the YTD Output sheet
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ detecting loggedin user
Here's something I threw together from macros I already had.
I didn't spend too much time on it.
I hope they have what you're looking for.
There are several things you MENTIONED that I tried to include