Hi,

I'm developing a Workbook for non-Excellers to use. The mainstay of this is a table of records individual to each user. They input a record type and the remaining columns are completed with LOOKUP functions etc., returning text, often of considerable length. Over time the values for each record will deviate from the initial defaults. Users will have to manually edit the returned strings. At the moment, I have to instruct users to 'Paste values' before editing the text, or else the whole string is lost. This works, but confuses many users and is annoying for all. Is there a way to get the value to appear in the formula bar for editing and/or to automatically paste values across a row after one specified column is filled in? This would allow users to edit the records with ease.

I can provide a simplified mock-up if needed, but hope my explanation makes at least some sense.

Thanks.