Forum Discussion
Post ProdigyPower query automatically refresh
Saxon10
Please check the attached Excel File. When you update data in sale sheet, the table in sale1 will be refreshed. I also provided a button to refresh if you need to use it.
https://1drv.ms/x/s!AmoScH5srsIYgZItGfJ7MdKoZVtEEw?e=UxbiRO
Post ProdigyHi,
Thanks for your reply.
Yes, that's right.
Note: In sales sheet I have 3 columns and sales1 sheet I have two columns. In sales sheet Item columns has always blanks.
The macro will take care of auto refresh or need to be perform any addtional steps in query setting/properties in order to complete auto refresh?
Thank you.
Herewith attached the Excel file for your reference.
Super UserSaxon10
Please check the attached Excel File. When you update data in sale sheet, the table in sale1 will be refreshed. I also provided a button to refresh if you need to use it.
https://1drv.ms/x/s!AmoScH5srsIYgZItGfJ7MdKoZVtEEw?e=UxbiRO
- Saxon10
thank you so much for your help and solution. It's working well.