Thanks for responding.
We do copy the same column every time, lets say by copying over the column we end up with 100 cells containing information, 5 cells will be blank as an example and some cells will hold incorrect data so by pasting that information into the User Edit field we have the majority of the information we need but can then start to work on those cells that need further investigation, once investigated we add the missing information into the blank cells within the User Edit field, this then allow the summaries we have created to start extracting the information they need ready for the final export into excel.
Any tips on how we can still do this would be greatly appreciated as it was just a quick copy column and paste so 2 seconds max, now each cell needs to be worked on individually all requiring around 4-5 keystrokes each.
While it wouldn't be as convenient as the copy and paste you were able to do in V10.5, you should get close with a lookup. Most of these steps only have to be done once and are saved in the model.
Create a calculated field called [RecNoID] using the formula ‘str(Recno(),5,0,"0") + "^" +[OriginalField]’.
Where original field is the column you would have copied.
Choose a character like ^ that you won’t get in your data.
Create a lookup calculated field. Use the [RecNoID] as the input and click the ‘Import Filtered Values’ option
Edit the lookup by typing the corrections that you would have entered in to the Runtime field and leave the fields that are OK blank.
Make sure the option on the right to use value from input when no match is found is selected and click the ‘remove rows with empty output vales’ button at the bottom of the screen and Accept the changes
Create another calculate field to split your result out.
Use the same character, ^ for example, that you used in step 1
Next time you want to do it, just edit the PseudoRT Lookup field, remove all the rows, Import them again and make your edits.
I hope that helps a little – but not as easy as 10.5, I know! I used - instead of ^ in the screen shot below: