S
Sh0t2bts
Hi All,
I have two worksheets, one with around 10,000 lines of data Which contact
user names, dates, products, states, and a few other things, the other with
sumproduct formulas in which they total user name by date.
The first sheet is grouped by user name and then by date, what I want to do
is on the totals page in the same row as the user name is to display a link
to that persons user name on the first sheet, as the data on the first sheet
is drawn from a database and changes every 4 hours I need the links to
change them selves.
I am not sure if I can do this with a formula or if I will have to write a
bit of code to do the changes
Please advise of any options
Thanks
Mark
I have two worksheets, one with around 10,000 lines of data Which contact
user names, dates, products, states, and a few other things, the other with
sumproduct formulas in which they total user name by date.
The first sheet is grouped by user name and then by date, what I want to do
is on the totals page in the same row as the user name is to display a link
to that persons user name on the first sheet, as the data on the first sheet
is drawn from a database and changes every 4 hours I need the links to
change them selves.
I am not sure if I can do this with a formula or if I will have to write a
bit of code to do the changes
Please advise of any options
Thanks
Mark