98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Forms linked to excel spreadsheets
Forms linked to excel spreadsheets
Resolved · Medium Priority · Version 365
Wed 10 Apr 2024, 11:15Delegate Nicola said...
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.
Fri 12 Apr 2024, 09:38Trainer Marius said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Using Alt in Save Dialog BoxWhen you are saving (or opening) a file, try these; |
