Select Cells by Date Range

T

tsxi1

New Member
Joined
Jan 14, 2008
Messages
10
Hi All,

I have a large real estate database with a column for Transaction Date (TD) and a column directly adjacent which shows Days on Market (DOM). The TD column is already in chronological order.

For the avoidance of doubt, the portion of the database in question looks like this:
<table x:str="" style="border-collapse: collapse; width: 622pt;" border="0" cellpadding="0" cellspacing="0" width="828"><col style="width: 72pt;" span="2" width="96"> <col style="width: 26pt;" width="34"> <col style="width: 67pt;" width="89"> <col style="width: 48pt;" width="64"> <col style="width: 16pt;" width="21"> <col style="width: 48pt;" width="64"> <col style="width: 16pt;" width="21"> <col style="width: 48pt;" span="2" width="64"> <col style="width: 18pt;" width="24"> <col style="width: 54pt;" width="72"> <col style="width: 18pt;" width="24"> <col style="width: 53pt;" width="71"> <col style="width: 18pt;" width="24"> <tbody><tr style="height: 51pt;" height="68"> <td class="xl23" style="height: 51pt; width: 72pt;" height="68" width="96">SALES PRICE</td> <td class="xl23" style="width: 72pt;" width="96">LIST PRICE</td> <td class="xl23" style="width: 26pt;" width="34">CURR.</td> <td class="xl23" style="width: 67pt;" width="89">DATE SOLD</td> <td class="xl23" style="width: 48pt;" width="64">D.O.M.</td> <td class="xl24" style="width: 16pt;" width="21">
</td> <td class="xl24" style="width: 48pt;" width="64">Days between last sale</td> <td class="xl24" style="width: 16pt;" width="21">
</td> <td class="xl24" style="width: 48pt;" width="64">Avg. DOM by year</td> <td class="xl24" style="width: 18pt;" width="24">
</td> <td class="xl24" style="width: 54pt;" width="72">Sales Freq.per SP Range</td> <td class="xl24" style="width: 18pt;" width="24">
</td> <td class="xl24" style="width: 53pt;" width="71">Qty. of Sales 010104-310109</td> <td class="xl24" style="width: 18pt;" width="24">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" x:num="4800000" align="right" height="17">4,800,000</td> <td class="xl25" x:num="5975000" align="right">5,975,000</td> <td class="xl23">US</td> <td class="xl31" x:num="38016" align="right">1-30-2004</td> <td x:num="" align="right">134</td> <td>
</td> <td class="xl27">
</td> <td class="xl26">
</td> <td class="xl26">
</td> <td class="xl26">
</td> <td class="xl28" x:num="">500000</td> <td class="xl23" x:num="">7</td> <td class="xl30" x:num="38352">12-31-2004</td> <td class="xl23" x:num="">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" x:num="303000" align="right" height="17">303,000</td> <td class="xl25" x:num="310000" align="right">310,000</td> <td class="xl23">CI</td> <td class="xl31" x:num="38093" align="right">4-16-2004</td> <td x:num="" align="right">129</td> <td>
</td> <td class="xl26" x:num="" x:fmla="=D3-D2" align="right">77.0</td> <td class="xl26">
</td> <td class="xl26">
</td> <td class="xl26">
</td> <td class="xl29" style="width: 54pt;" x:num="" width="72">1000000</td> <td class="xl23" x:num="">3</td> <td class="xl30" x:num="38717">12-31-2005</td> <td class="xl23" x:num="">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" x:num="1275000" align="right" height="17">1,275,000</td> <td class="xl25" x:num="1500000" align="right">1,500,000</td> <td class="xl23">US</td> <td class="xl22" x:num="38387" align="right">2-4-2005</td> <td x:num="" align="right">45</td> <td>
</td> <td class="xl26" x:num="" x:fmla="=D4-D3" align="right">294.0</td> <td class="xl26">
</td> <td class="xl26">
</td> <td class="xl26">
</td> <td class="xl29" style="width: 54pt;" x:num="" width="72">1500000</td> <td class="xl23" x:num="">1</td> <td class="xl30" x:num="39082">12-31-2006</td> <td class="xl23" x:num="">5</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" x:num="279000" align="right" height="17">279,000</td> <td class="xl25" x:num="279000" align="right">279,000</td> <td class="xl23">CI</td> <td class="xl22" x:num="38596" align="right">9-1-2005</td> <td x:num="" align="right">436</td> <td>
</td> <td class="xl26" x:num="" x:fmla="=D5-D4" align="right">209.0</td> <td class="xl26">
</td> <td class="xl26">
</td> <td class="xl26">
</td> <td class="xl24" style="width: 54pt;" x:num="" width="72">2000000</td> <td class="xl23" x:num="">1</td> <td class="xl30" x:num="39447">12-31-2007</td> <td class="xl23" x:num="">12</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" x:num="3050000" align="right" height="17">3,050,000</td> <td class="xl25" x:num="3400000" align="right">3,400,000</td> <td class="xl23">US</td> <td class="xl22" x:num="38885" align="right">6-17-2006</td> <td x:num="" align="right">379</td> <td>
</td> <td class="xl26" x:num="" x:fmla="=D6-D5" align="right">289.0</td> <td class="xl26">
</td> <td class="xl26">
</td> <td class="xl26">
</td> <td class="xl24" style="width: 54pt;" x:num="2500000" width="72">2500000</td> <td class="xl23" x:num="">4</td> <td class="xl30" x:num="39813">12-31-2008</td> <td class="xl23" x:num="">3</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" x:num="5900000" align="right" height="17">5,900,000</td> <td class="xl25" x:num="5950000" align="right">5,950,000</td> <td class="xl23">US</td> <td class="xl22" x:num="38954" align="right">8-25-2006</td> <td x:num="" align="right">351</td> <td>
</td> <td class="xl26" x:num="" x:fmla="=D7-D6" align="right">69.0</td> <td class="xl26">
</td> <td class="xl26">
</td> <td class="xl26">
</td> <td class="xl24" style="width: 54pt;" x:num="3000000" width="72">3000000</td> <td class="xl23" x:num="">2</td> <td class="xl30" x:num="40178">12-31-2009</td> <td class="xl23" x:num="">0</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" x:num="5500000" align="right" height="17">5,500,000</td> <td class="xl25" x:num="5950000" align="right">5,950,000</td> <td class="xl23">US</td> <td class="xl22" x:num="38958" align="right">8-29-2006</td> <td x:num="" align="right">1859</td> <td>
</td> <td class="xl26" x:num="" x:fmla="=D8-D7" align="right">4.0</td> <td class="xl26">
</td> <td class="xl26">
</td> <td class="xl26">
</td> <td class="xl24" style="width: 54pt;" x:num="3500000" width="72">3500000</td> <td class="xl23" x:num="">1</td> <td>
</td> <td class="xl23" x:num="">0</td> </tr> </tbody></table>

What I'm trying to do is figure out how to write a macro which will give me an average DOM on a yearly basis and populate a different column with the results. I see the basic programming structure as:

1) Select cells based on date in TD column, e.g. all dates in 2004 calendar year.
2) Select those adjacent DOM cells.
3) Calculate the average DOM.
4) Post results to another column.
5) Select cells based on date in TD column + one year
6) Process repeats to end of database

I'm using Excel 03 on a Win XP box with SP3.

I hope this isn't confusing and any help would be greatly appreciated! Many thanks in advance, guys.

Kind regards,
Anthony


<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden"><input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden"><input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
Sort by date Sort by votes
Could a pivot table not be used with the group by function (year). Instead of SUM or COUNT change to average?
 
Upvote 0
Hello c_m_s_jr,

And thank you very much for your kind reply. While I could probably get to the data via a pivot table method, in this case I'll need to have it in the database itself in a 'flattened' state.

This is because I'll be using another business-intelligence program which links to Excel and it requires each unique record -- and all its metrics -- reside in a single row.

It would be fantastic if there's a way to do this with a pivot table! Is this indeed possible?

Thanks in advance,
Anthony
 
Upvote 0
I understand then why you can't use a pivot. Can you give an example of expected results based on the same you have above?

What should go into the Avg DOM by year column for each of the lines you show?
 
Upvote 0
Hello c_m_s_jr,

This is the desired outcome in red:

<table x:str="" style="border-collapse: collapse; width: 622pt;" border="0" cellpadding="0" cellspacing="0" width="828"><tbody><tr style="height: 51pt;" height="68"><td class="xl23" style="height: 51pt; width: 72pt;" height="68" width="96">SALES PRICE</td> <td class="xl23" style="width: 72pt;" width="96">LIST PRICE</td> <td class="xl23" style="width: 26pt;" width="34">CURR.</td> <td class="xl23" style="width: 67pt;" width="89">DATE SOLD</td> <td class="xl23" style="width: 48pt;" width="64">D.O.M.</td> <td class="xl24" style="width: 16pt;" width="21">
</td> <td class="xl24" style="width: 48pt;" width="64">Days between last sale</td> <td class="xl24" style="width: 16pt;" width="21">
</td> <td class="xl24" style="width: 48pt;" width="64">Avg. DOM by year</td> <td valign="top">
</td><td class="xl24" style="width: 18pt;" width="24">
</td> <td class="xl24" style="width: 54pt;" width="72">Sales Freq.per SP Range</td> <td class="xl24" style="width: 18pt;" width="24">
</td> <td class="xl24" style="width: 53pt;" width="71">Qty. of Sales 010104-310109</td> <td class="xl24" style="width: 18pt;" width="24">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" x:num="4800000" align="right" height="17">4,800,000</td> <td class="xl25" x:num="5975000" align="right">5,975,000</td> <td class="xl23">US</td> <td class="xl31" x:num="38016" align="right">1-30-2004</td> <td x:num="" align="right">134</td> <td>
</td> <td class="xl27">
</td> <td class="xl26">
</td> <td class="xl26">
</td> <td valign="top">
</td><td class="xl26">
</td> <td class="xl28" x:num="">500000</td> <td class="xl23" x:num="">7</td> <td class="xl30" x:num="38352">12-31-2004</td> <td class="xl23" x:num="">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" x:num="303000" align="right" height="17">303,000</td> <td class="xl25" x:num="310000" align="right">310,000</td> <td class="xl23">CI</td> <td class="xl31" x:num="38093" align="right">4-16-2004</td> <td x:num="" align="right">129</td> <td>
</td> <td class="xl26" x:num="" x:fmla="=D3-D2" align="right">77.0</td> <td class="xl26">
</td> <td class="xl26"> 131.5
</td> <td valign="top">
</td><td class="xl26">
</td> <td class="xl29" style="width: 54pt;" x:num="" width="72">1000000</td> <td class="xl23" x:num="">3</td> <td class="xl30" x:num="38717">12-31-2005</td> <td class="xl23" x:num="">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" x:num="1275000" align="right" height="17">1,275,000</td> <td class="xl25" x:num="1500000" align="right">1,500,000</td> <td class="xl23">US</td> <td class="xl22" x:num="38387" align="right">2-4-2005</td> <td x:num="" align="right">45</td> <td>
</td> <td class="xl26" x:num="" x:fmla="=D4-D3" align="right">294.0</td> <td class="xl26">
</td> <td class="xl26">
</td> <td valign="top">
</td><td class="xl26">
</td> <td class="xl29" style="width: 54pt;" x:num="" width="72">1500000</td> <td class="xl23" x:num="">1</td> <td class="xl30" x:num="39082">12-31-2006</td> <td class="xl23" x:num="">5</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" x:num="279000" align="right" height="17">279,000</td> <td class="xl25" x:num="279000" align="right">279,000</td> <td class="xl23">CI</td> <td class="xl22" x:num="38596" align="right">9-1-2005</td> <td x:num="" align="right">436</td> <td>
</td> <td class="xl26" x:num="" x:fmla="=D5-D4" align="right">209.0</td> <td class="xl26">
</td> <td class="xl26"> 240.5
</td> <td valign="top">
</td><td class="xl26">
</td> <td class="xl24" style="width: 54pt;" x:num="" width="72">2000000</td> <td class="xl23" x:num="">1</td> <td class="xl30" x:num="39447">12-31-2007</td> <td class="xl23" x:num="">12</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" x:num="3050000" align="right" height="17">3,050,000</td> <td class="xl25" x:num="3400000" align="right">3,400,000</td> <td class="xl23">US</td> <td class="xl22" x:num="38885" align="right">6-17-2006</td> <td x:num="" align="right">379</td> <td>
</td> <td class="xl26" x:num="" x:fmla="=D6-D5" align="right">289.0</td> <td class="xl26">
</td> <td class="xl26">
</td> <td valign="top">
</td><td class="xl26">
</td> <td class="xl24" style="width: 54pt;" x:num="2500000" width="72">2500000</td> <td class="xl23" x:num="">4</td> <td class="xl30" x:num="39813">12-31-2008</td> <td class="xl23" x:num="">3</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" x:num="5900000" align="right" height="17">5,900,000</td> <td class="xl25" x:num="5950000" align="right">5,950,000</td> <td class="xl23">US</td> <td class="xl22" x:num="38954" align="right">8-25-2006</td> <td x:num="" align="right">351</td> <td>
</td> <td class="xl26" x:num="" x:fmla="=D7-D6" align="right">69.0</td> <td class="xl26">
</td> <td class="xl26">
</td> <td valign="top">
</td><td class="xl26">
</td> <td class="xl24" style="width: 54pt;" x:num="3000000" width="72">3000000</td> <td class="xl23" x:num="">2</td> <td class="xl30" x:num="40178">12-31-2009</td> <td class="xl23" x:num="">0</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" x:num="5500000" align="right" height="17">5,500,000</td> <td class="xl25" x:num="5950000" align="right">5,950,000</td> <td class="xl23">US</td> <td class="xl22" x:num="38958" align="right">8-29-2006</td> <td x:num="" align="right">1859</td> <td>
</td> <td class="xl26" x:num="" x:fmla="=D8-D7" align="right">4.0</td> <td class="xl26">
</td> <td class="xl26"> 863.0
</td> <td valign="top">
</td><td class="xl26">
</td> <td class="xl24" style="width: 54pt;" x:num="3500000" width="72">3500000</td> <td class="xl23" x:num="">1</td> <td>
</td> <td class="xl23" x:num="">0</td></tr></tbody></table>
As you can see, it would be a sort of rolling calculation through the spreadsheet (i.e. 134 + 129 / 2 = 131.5 as the average DOM for the 2004 year) with the results posted adjacent to the last date for a particular year.

I hope this helps.

Thanks again,
Anthony<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden"><input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden"><input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">
 
Upvote 0
I don't think I can come up with a formula for you on this one. If there is anyone who might be able to it would be Aladin or Barry. If you are looking for a macro lots of people on the board (jbeaucaire, lenze, VoG, Jonmo1).

Sorry I couldn't be of more help. if you still haven't gotten a response by the time I post this, I would "bump" this back to the top of the board.
 
Upvote 0
You could put this CSE formula in F2 and drag downward.

=IF(D2 < MAX(((YEAR(D2)=YEAR(D2:D8))*D2:D8)), "", AVERAGE(IF(YEAR($D$2:$D$8)=YEAR(D2), $E$2:$E$8)))

It needs to be entered with Ctrl-Shift-Enter (Cmd+Return for Mac)

<table border=1 cellspacing=0>
<tr align="center" bgcolor=#A0A0A0><td width=25> <td width=25><b>A</b><td width=25><b>B</b><td width=25><b>C</b><td width=25><b>D</b><td width=25><b>E</b><td width=25><b>F</b></tr>
<tr><td align="center" bgcolor=#A0A0A0><b>1</b><td align="left" bgcolor=#FFFFFF><td align="left" bgcolor=#FFFFFF><td align="left" bgcolor=#FFFFFF><td align="left" bgcolor=#FFFFFF>date sold<td align="left" bgcolor=#FFFFFF>DOM<td align="left" bgcolor=#FFFFFF></tr>
<tr><td align="center" bgcolor=#A0A0A0><b>2</b><td align="right" bgcolor=#FFFFFF>4,800,000<td align="right" bgcolor=#FFFFFF>5,975,000<td align="left" bgcolor=#FFFFFF>US<td align="left" bgcolor=#FFFFFF>1/30/04<td align="right" bgcolor=#FFFFFF>134<td align="left" bgcolor=#FFFFFF></tr>
<tr><td align="center" bgcolor=#A0A0A0><b>3</b><td align="right" bgcolor=#FFFFFF>303,000<td align="right" bgcolor=#FFFFFF>310,000<td align="left" bgcolor=#FFFFFF>CI<td align="left" bgcolor=#FFFFFF>4/16/04<td align="right" bgcolor=#FFFFFF>129<td align="right" bgcolor=#FFFFFF>131.5</tr>
<tr><td align="center" bgcolor=#A0A0A0><b>4</b><td align="right" bgcolor=#FFFFFF>1,275,000<td align="right" bgcolor=#FFFFFF>1,500,000<td align="left" bgcolor=#FFFFFF>US<td align="left" bgcolor=#FFFFFF>2/4/05<td align="right" bgcolor=#FFFFFF>45<td align="left" bgcolor=#FFFFFF></tr>
<tr><td align="center" bgcolor=#A0A0A0><b>5</b><td align="right" bgcolor=#FFFFFF>279,000<td align="right" bgcolor=#FFFFFF>279,000<td align="left" bgcolor=#FFFFFF>CI<td align="left" bgcolor=#FFFFFF>9/1/05<td align="right" bgcolor=#FFFFFF>436<td align="right" bgcolor=#FFFFFF>240.5</tr>
<tr><td align="center" bgcolor=#A0A0A0><b>6</b><td align="right" bgcolor=#FFFFFF>3,050,000<td align="right" bgcolor=#FFFFFF>3,400,000<td align="left" bgcolor=#FFFFFF>US<td align="left" bgcolor=#FFFFFF>6/17/06<td align="right" bgcolor=#FFFFFF>379<td align="left" bgcolor=#FFFFFF></tr>
<tr><td align="center" bgcolor=#A0A0A0><b>7</b><td align="right" bgcolor=#FFFFFF>5,900,000<td align="right" bgcolor=#FFFFFF>5,950,000<td align="left" bgcolor=#FFFFFF>US<td align="left" bgcolor=#FFFFFF>8/25/06<td align="right" bgcolor=#FFFFFF>351<td align="left" bgcolor=#FFFFFF></tr>
<tr><td align="center" bgcolor=#A0A0A0><b>8</b><td align="right" bgcolor=#FFFFFF>5,500,000<td align="right" bgcolor=#FFFFFF>5,950,000<td align="left" bgcolor=#FFFFFF>US<td align="left" bgcolor=#FFFFFF>8/29/06<td align="right" bgcolor=#FFFFFF>1859<td align="right" bgcolor=#FFFFFF>863.0</tr>
</table>
 
Upvote 0
mikerickson said:
You could put this CSE formula in F2 and drag downward.

=IF(D2 < MAX(((YEAR(D2)=YEAR(D2:D8))*D2:D8)), "", AVERAGE(IF(YEAR($D$2:$D$8)=YEAR(D2), $E$2:$E$8)))

It needs to be entered with Ctrl-Shift-Enter (Cmd+Return for Mac)

<TABLE border=1 cellSpacing=0>
<TBODY><TR align=middle bgColor=#a0a0a0><TD width=25> <TD width=25>A<TD width=25>B<TD width=25>C<TD width=25>D<TD width=25>E<TD width=25>F</TD>

<TR><TD bgColor=#a0a0a0 align=middle>1<TD bgColor=#ffffff align=left><TD bgColor=#ffffff align=left><TD bgColor=#ffffff align=left><TD bgColor=#ffffff align=left>date sold<TD bgColor=#ffffff align=left>DOM<TD bgColor=#ffffff align=left></TD>

<TR><TD bgColor=#a0a0a0 align=middle>2<TD bgColor=#ffffff align=right>4,800,000<TD bgColor=#ffffff align=right>5,975,000<TD bgColor=#ffffff align=left>US<TD bgColor=#ffffff align=left>1/30/04<TD bgColor=#ffffff align=right>134<TD bgColor=#ffffff align=left></TD>

<TR><TD bgColor=#a0a0a0 align=middle>3<TD bgColor=#ffffff align=right>303,000<TD bgColor=#ffffff align=right>310,000<TD bgColor=#ffffff align=left>CI<TD bgColor=#ffffff align=left>4/16/04<TD bgColor=#ffffff align=right>129<TD bgColor=#ffffff align=right>131.5</TD>

<TR><TD bgColor=#a0a0a0 align=middle>4<TD bgColor=#ffffff align=right>1,275,000<TD bgColor=#ffffff align=right>1,500,000<TD bgColor=#ffffff align=left>US<TD bgColor=#ffffff align=left>2/4/05<TD bgColor=#ffffff align=right>45<TD bgColor=#ffffff align=left></TD>

<TR><TD bgColor=#a0a0a0 align=middle>5<TD bgColor=#ffffff align=right>279,000<TD bgColor=#ffffff align=right>279,000<TD bgColor=#ffffff align=left>CI<TD bgColor=#ffffff align=left>9/1/05<TD bgColor=#ffffff align=right>436<TD bgColor=#ffffff align=right>240.5</TD>

<TR><TD bgColor=#a0a0a0 align=middle>6<TD bgColor=#ffffff align=right>3,050,000<TD bgColor=#ffffff align=right>3,400,000<TD bgColor=#ffffff align=left>US<TD bgColor=#ffffff align=left>6/17/06<TD bgColor=#ffffff align=right>379<TD bgColor=#ffffff align=left></TD>

<TR><TD bgColor=#a0a0a0 align=middle>7<TD bgColor=#ffffff align=right>5,900,000<TD bgColor=#ffffff align=right>5,950,000<TD bgColor=#ffffff align=left>US<TD bgColor=#ffffff align=left>8/25/06<TD bgColor=#ffffff align=right>351<TD bgColor=#ffffff align=left></TD>

<TR><TD bgColor=#a0a0a0 align=middle>8<TD bgColor=#ffffff align=right>5,500,000<TD bgColor=#ffffff align=right>5,950,000<TD bgColor=#ffffff align=left>US<TD bgColor=#ffffff align=left>8/29/06<TD bgColor=#ffffff align=right>1859<TD bgColor=#ffffff align=right>863.0</TD>

</TR>
</TABLE>
Click to expand...

And that is why I don't have MVP after my name. WOW, very impressive.
 
Upvote 0
Thanks a million, mikerickson and c_m_s_jr!

Much appreciated!!

Kind regards,
Anthony
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden"><input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
537
smozgur
smozgur
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
1K
CrashOD
C
M
  • Question Question
Help with FilterXML formula
Replies
0
Views
1K
montex01
M
T
  • Question Question
How can I make queryselector to properly loop through a range of cells and get results from a webpage
Replies
1
Views
2K
Worf
Worf
M
  • Question Question
Drop down select
Replies
1
Views
1K
madu
M

Forum statistics

Threads
1,223,227
Messages
6,170,848
Members
452,361
Latest member
d3ad3y3

Share this page

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
Back
Top