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 ProdigyThnaks for your reply and advise. Yes, I am connecting single in same file with two different sheet. The difference in-between two sheet (sales and sales1) is blanks column (Item).
In order to get the automatic refresh in sales1 sheet based on the sales sheet without opening Excel file or time setting. What kind of connection or setting need to be setup in order to get the automatic refresh.
Example: If I add data in sales sheet then it's automatically need to be replicate in Sales1 sheet.
Could you please provide artical or snapshot more understanding the logic.
Sales1
Sales
Post ProdigyI am using old Excel version so unable to attached file.
Sales1
COUNTRYDATE
UAE 05/05/2021 00:00
AUS 02/04/2021 00:00
INDIA 02/04/2021 00:00
TML 05/05/2021 00:00
SRI 02/04/2021 00:00
PAK 02/04/2021 00:00
INDIA 23/03/2021 00:00
CAND 02/04/2021 00:00
US 02/04/2021 00:00
NEWL 02/04/2021 00:00
UK 02/04/2021 00:00
Sales
ITEMCOUNTRYDATE
INDIA 02/04/2021
PAK 02/04/2021
US 02/04/2021
UK 02/04/2021
AUS 02/04/2021
SRI 02/04/2021
CAND 02/04/2021
NEWL 02/04/2021
INDIA 23/03/2021
UAE 05/05/2021
TML 05/05/2021