Forms linked to excel spreadsheets

Resolved · Medium Priority · Version 365

Wed 10 Apr 2024, 11:15 Delegate 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:38 Trainer 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 courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Using Alt in Save Dialog Box

When you are saving (or opening) a file, try these;
(Note the numbers are on the keyboard not the numeric keypad)
1. Go to previous folder Alt+1
2. Go up one folder level Alt+2
3. Search the Web Alt+3
4. Delete selected file Alt+4 or Delete
5. Create a new folder Alt+5
6. Cycle through all views Alt+6 repeatedly
7. Display the Tools menu Alt+7

View all Excel hints and tips