trigger MS Query Refresh on population of partic. cell

ajm

Well-known Member
Joined
Feb 5, 2003
Messages
1,853
Hi all (again),

I need a hand with a small hiccup. How do I get MS Query to refresh data in one workbook when a particular cell is populated in another workbook? It might make things more interesting to know that the "particular" cell will be different each new month.

The work in process revolves around a monthly report we receive that details and average fuel price for the month. We take that figure and put it into a workbook according to month. Movement in this price is then used to calculate increments or decrements to our clients fuel subsidies.

Any ideas?
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
L

Legacy 98055

Guest
Hi Ajm.

Can you? Probably yes. Can I or anybody else really tell you how? Not really without some more information. Logic will have to be designed to determine "which" cell has changed in the other workbook. If this query needs to be refreshed in real time, that adds further complication. I would imagine that simply checking this "other" cell upon opening the workbook that contains the query would suffice. However, I don't know because you have not told me. :)
 

ajm

Well-known Member
Joined
Feb 5, 2003
Messages
1,853
hey there right_click,

neither workbook is in real time. the cell to be populated will be on a monthly basis around the tenth of each month.

the process is thus: we receive the fuel report from an external agency. the figure for last month is copied and pasted into a spreadsheet next to the previous months. After this is done, the movement between the two months is calculated and applied to the previous month's fuel price for that operator. The MS Query simply brings in the number of litres used this month by that operator so that we can multiply the price by the volume.

its simple enough to do manually, except I am more than a little bored with others not checking they have the correct month's data before we make our payments.

would more specific details help? the trigger cell(s) are in a workbook called "Key Factors" on the "Indicies" tab. they occupy row 8 across the page, entitled "Fueltrac Index value".


<table border="1" bordercolor="#C0C0C0" bordercolordark="#FFFFFF" cellspacing="0" cellpadding="2">
<tr>
<td valign="top"><font face="Tahoma" size="2"><nobr>Month and Year - (white text)</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>July 2004</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>August 2004</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>September 2004</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>October 2004</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>November 2004</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>December 2004</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>January 2005</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>February 2005</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>March 2005</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>April 2005</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>May 2005</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>June 2005</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>July 2005</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>August 2005</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>September 2005</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>October 2005</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>November 2005</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>December 2005</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>January 2006</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>February 2006</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>March 2006</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>April 2006</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>May 2006</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>June 2006</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>July 2006</nobr></font></td>
</tr>
<tr>
<td bgcolor="#CCFFCC" valign="top"><font face="Tahoma" size="2"><nobr>Current Year</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td valign="top"><font face="Tahoma" size="2"><nobr>Fuel change- from previous month</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>0.0301%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>6.7528%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>3.0314%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>2.7601%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>0.0000%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>-6.9409%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>-1.0002%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>2.4247%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>7.9380%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>3.8381%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>-4.5512%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>5.0667%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>2.6243%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>0.7085%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>5.9114%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>0.3130%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>-7.0863%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>-0.8847%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>6.4799%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>2.2588%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>1.6624%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>4.7114%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>1.6115%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>-1.0105%</nobr></font></td>
</tr>
<tr>
<td valign="top"><font face="Tahoma" size="2"><nobr>Month number</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>13</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>14</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>15</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>16</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>17</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>18</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>19</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>20</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>21</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>22</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>23</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>24</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>25</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>26</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>27</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>28</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>29</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>30</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>31</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>32</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>33</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>34</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>35</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>36</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>37</nobr></font></td>
</tr>
<tr>
<td bgcolor="#800080" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>MONTH</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>July</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>August</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>September</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>October</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>November</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>December</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>January</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>February</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>March</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>April</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>May</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>June</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>July</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>August</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>September</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>October</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>November</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>December</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>January</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>February</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>March</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>April</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>May</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>June</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>July</nobr></font></td>
</tr>
<tr>
<td bgcolor="#C0C0C0" valign="bottom"><font face="Tahoma" size="2"><nobr>Year</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2004</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2004</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2004</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2004</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2004</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2004</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2005</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2005</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2005</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2005</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2005</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2005</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2005</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2005</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2005</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2005</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2005</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2005</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2006</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2006</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2006</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2006</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2006</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2006</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2006</nobr></font></td>
</tr>
<tr>
<td bgcolor="#FFFF99" valign="top"><font face="Tahoma" size="2"><nobr>FUELtrac index value</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>99.81</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>106.55</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>109.78</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>112.81</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>112.81</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>104.98</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>103.93</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>106.45</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>114.90</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>119.31</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>113.88</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>119.65</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>122.79</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>123.66</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>130.97</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>131.38</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>122.07</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>120.99</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>128.83</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>131.74</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>133.93</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>140.24</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>142.50</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>141.06</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>138.55</nobr></font></td>
</tr>
<tr>
<td bgcolor="#FFFF99" valign="top"><font face="Tahoma" size="2"><nobr>FUELtrac - % change from July 2004</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>0.00%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>0.03%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>6.78%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>10.02%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>13.06%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>13.06%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>5.21%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>4.16%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>6.68%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>15.15%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>19.57%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>14.13%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>19.91%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>23.06%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>23.93%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>31.26%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>31.67%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>22.34%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>21.26%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>29.11%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>32.03%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>34.23%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>40.55%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>42.81%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>41.37%</nobr></font></td>
</tr>
</table>

The query to be refreshed in the other workbook is called "Fuel Adjustment Total Litres - west"
 
L

Legacy 98055

Guest
Hi AJM. You are going to need a VBA code example to perform this. In order to get an example, you need to provide all of the details. I appreciate the time you have taken to describe what you need so far but I still have a couple of questions.

When is this automatic refresh going to take place? Every time the workbook performing the query is opened? When the user clicks on a button or runs a macro?

Do any of your queries parameters vary or are they always the same? If they change, please provide details.

Would it be ok to email me the two workbooks and/or post them here for others' input?
 

ajm

Well-known Member
Joined
Feb 5, 2003
Messages
1,853
have sent one workbook to your email address. Its a cut down version and actually incorporates the relevant sheets from my two main workbooks. Hope its clearer when you see it.
 

Forum statistics

Threads
1,136,349
Messages
5,675,243
Members
419,556
Latest member
rdecker12

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top