Data validation

Hello Natalie,


Thank you for your question regarding macros and refresh.

The key for refresh is F9, so you could record a macro and press the F9 key. Playing back the macro will refresh.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer