Update cell information from a different cell

[Guest]

Does anyone know if it is possible to manipulate data in individule cells of an array from a different (source) cell without losing that data once the source cell value is changed. I'm trying to make it possible to add and/or change data in an aray from a single input location in a spreadsheet. (Hope this makes sense?)

 

[Frank Kabel]

Hi
not sure if I understood you correctly but this sounds like you need
VBA (an event macro). You may give a specific example for what you're
trying to achieve

--
Regards
Frank Kabel
Frankfurt, Germany

Does anyone know if it is possible to manipulate data in individule

cells of an array from a different (source) cell without losing that
data once the source cell value is changed. I'm trying to make it
possible to add and/or change data in an aray from a single input
location in a spreadsheet. (Hope this makes sense?)

 

[Guest]

Thanks Frank...

As an example, I have an array in a hidden worksheet that is used to load user specific information into cells in what I'll call the Client worksheet. This info is used to load perameters and perform various calculations. This user information is also sensative, and only the users themselves can edit it. I use VLOOKUP from the Client worksheet to pull this data in and would like to be able to edit the array from the Client worksheet when necessary without allowing the users direct access to the hidden worksheet. I'm not highly familiar with VB, and it sounds like I need to be, but if you have a solution you think will work, I'd love to hear it.