Nicola has attended:
Excel For Scientists course
Forms linked to excel spreadsheets
The results from a form I have created go into an excel workbook. I have the original form1 worksheet and I have added other worksheets to the workbook. The second worksheet is taking data from the form1 worksheet and displaying only the information that I want. I have formatted some of the cells in this worksheet and when I copy the formula across into empty cells it display value in the cell as presumably the corresponding cell in form1 is not yet there . Is there a way to hide this? I would like my modified worksheet to update automatically when form1 updates, which is each time the form is filled in.
RE: Forms linked to excel spreadsheets
Hello Nicola,
Thank you for your question. If some of the formulas you have written show an error message, you can use IF to leave the result cell empty. E,g.:
=IF(A2="","",(your original formula))
If A2 is empty, IF will show an empty cell instead.
To update the second sheet more quickly with new results, it might help to turn the data in Sheet 2 into a formatted table, which updates more easily than a standard table.
I hope this helps.
Kind regards
Marius Barnard
STL
