K
KPM
Hi,
What I would like to do, is create a link from a 'hint' (or an error
message) to another worksheet that appears when the user focuses on the
particular cell or gets an error message. How do I create a link (or can I)
through the Message Input dialouge under Data > Validation??
More specifically, I am creating a workbook that contains different hardware
and software that is assigned to different people. I have one worksheet
titled 'Lists' and there, I am adding all the items that will be inventoried
or tracked. So, on the 'Lists' worksheet, there is a column titled
'Assinged', which is mostly employee names, but there are also a few room
numbers there as well, so, basically, a PC, laptop, projector or some other
hardware is 'assigned' to a place or thing, for the most part a human, but
not necessarily... then, for example, there is a worksheet titled 'Monitor'
and all of our monitors and the specific information is on that worksheet and
the first column is called 'assigned', this column is a drop down list that
gets its data from the 'Lists' table. On the 'Input Message' dialouge
created using Data>Validation, I type a message that explains people should
select from the list, but if the name they are seeking is not present, that
it should be added to the 'Lists' table, under the 'Assigned' colunm. I want
to make the work 'Lists' in the hint message a link to the 'Lists' worksheet.
Thanks for any help.
What I would like to do, is create a link from a 'hint' (or an error
message) to another worksheet that appears when the user focuses on the
particular cell or gets an error message. How do I create a link (or can I)
through the Message Input dialouge under Data > Validation??
More specifically, I am creating a workbook that contains different hardware
and software that is assigned to different people. I have one worksheet
titled 'Lists' and there, I am adding all the items that will be inventoried
or tracked. So, on the 'Lists' worksheet, there is a column titled
'Assinged', which is mostly employee names, but there are also a few room
numbers there as well, so, basically, a PC, laptop, projector or some other
hardware is 'assigned' to a place or thing, for the most part a human, but
not necessarily... then, for example, there is a worksheet titled 'Monitor'
and all of our monitors and the specific information is on that worksheet and
the first column is called 'assigned', this column is a drop down list that
gets its data from the 'Lists' table. On the 'Input Message' dialouge
created using Data>Validation, I type a message that explains people should
select from the list, but if the name they are seeking is not present, that
it should be added to the 'Lists' table, under the 'Assigned' colunm. I want
to make the work 'Lists' in the hint message a link to the 'Lists' worksheet.
Thanks for any help.