S
SteveT
Hi,
I have 2 sheets; 1 = database, 2 = Look up sheet
Ea Value Column B Sheet 1 is hyperlinked to Sheet 2.
When user selects the hyperlinked cell the value of cell selected auto
populates
cell A9 Sheet 2. Once populated cell A9 Sheet 2 is the match value of index
formulas in cells E10, A11, E11, A13, E13, A15, C15, E15, & G15.
The Look up sheet body then is ready to be emailed internally within the
office
My problem is that these formulas are subject to mistaken
deletion/alteration if left un-protected but you can't email as body a
protected sheet.
I believe an event macro in Sheet 2 that copies the match value in Sheet 1,
BA1
is the route to go but I'm not versed in writing code. If any assistance
can be provided to help with this task would be most appreciative. Thx !!!
I have 2 sheets; 1 = database, 2 = Look up sheet
Ea Value Column B Sheet 1 is hyperlinked to Sheet 2.
When user selects the hyperlinked cell the value of cell selected auto
populates
cell A9 Sheet 2. Once populated cell A9 Sheet 2 is the match value of index
formulas in cells E10, A11, E11, A13, E13, A15, C15, E15, & G15.
The Look up sheet body then is ready to be emailed internally within the
office
My problem is that these formulas are subject to mistaken
deletion/alteration if left un-protected but you can't email as body a
protected sheet.
I believe an event macro in Sheet 2 that copies the match value in Sheet 1,
BA1
is the route to go but I'm not versed in writing code. If any assistance
can be provided to help with this task would be most appreciative. Thx !!!