Hi there,
I'm hoping some excel genius can help me with this query I have;
On the attached sheet I have 2 tabs, 'Fee Summary' that houses the info & 'Fee Changes' where I want the data to show.
The same 8 columns are replicated for each month on tab Fee Summary. I would like to show that data on the Fee Changes tab depending on the month that is picked on tab Fee Changes in columns B:I. It also has to correspond to the correct client on each row. I can bring in 1 months info using an index match but I can't for the life of me work out how to make it change dynamically once the certain month is picked.
The drop down list of dates will be in cells B:I on 'Fee Changes' tab.
Hoping someone can help
Thanks
C:\Users\Eimear\Documents\EJHTMLe\TempJean.htm
Fee summary
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:194px;"><col style="width:98px;"><col style="width:81px;"><col style="width:110px;"><col style="width:90px;"><col style="width:110px;"><col style="width:90px;"><col style="width:110px;"><col style="width:91px;"><col style="width:92px;"><col style="width:81px;"><col style="width:110px;"><col style="width:90px;"><col style="width:110px;"><col style="width:90px;"><col style="width:110px;"><col style="width:91px;"><col style="width:105px;"><col style="width:81px;"><col style="width:110px;"><col style="width:90px;"><col style="width:110px;"><col style="width:90px;"><col style="width:110px;"><col style="width:91px;"></colgroup><tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=339966]#339966[/URL] , align: center"]Account[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=339966]#339966[/URL] , colspan: 8, align: center"]March 2019[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=339966]#339966[/URL] , colspan: 8, align: center"]February 2019[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=339966]#339966[/URL] , colspan: 8, align: center"]January 2019[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]2[/TD]
[TD="align: center"]Total (AUD)[/TD]
[TD="align: center"]Total[/TD]
[TD="colspan: 2, align: center"]G[/TD]
[TD="colspan: 2, align: center"]F[/TD]
[TD="colspan: 2, align: center"]B[/TD]
[TD="align: center"]Total (AUD)[/TD]
[TD="align: center"]Total[/TD]
[TD="colspan: 2, align: center"]G[/TD]
[TD="colspan: 2, align: center"]F[/TD]
[TD="colspan: 2, align: center"]B[/TD]
[TD="align: center"]Total (AUD)[/TD]
[TD="align: center"]Total[/TD]
[TD="colspan: 2, align: center"]G[/TD]
[TD="colspan: 2, align: center"]F[/TD]
[TD="colspan: 2, align: center"]B[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]3[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: center"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: center"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: center"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: center"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: center"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: center"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: center"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: center"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: center"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]4[/TD]
[TD="align: right"]$29.00[/TD]
[TD="align: right"]$11.00[/TD]
[TD="align: right"]$2.00[/TD]
[TD="align: right"]$2.00[/TD]
[TD="align: right"]$4.00[/TD]
[TD="align: right"]$8.00[/TD]
[TD="align: right"]$2.00[/TD]
[TD="align: right"]$97.50[/TD]
[TD="align: right"]$28.00[/TD]
[TD="align: right"]$6.50[/TD]
[TD="align: right"]$5.50[/TD]
[TD="align: right"]$15.50[/TD]
[TD="align: right"]$28.00[/TD]
[TD="align: right"]$14.00[/TD]
[TD="align: right"]$90.00[/TD]
[TD="align: right"]$12.00[/TD]
[TD="align: right"]$5.00[/TD]
[TD="align: right"]$28.00[/TD]
[TD="align: right"]$8.50[/TD]
[TD="align: right"]$28.00[/TD]
[TD="align: right"]$8.50[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]5[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]Client1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$3.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$6.50[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$2.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.50[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$5.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]6[/TD]
[TD="align: right"]$10.50[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$3.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.50[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.50[/TD]
[TD="align: right"]$2.00[/TD]
[TD="align: right"]$4.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.50[/TD]
[TD="align: right"]$21.00[/TD]
[TD="align: right"]$5.00[/TD]
[TD="align: right"]$5.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$1.00[/TD]
[TD="align: right"]$5.00[/TD]
[TD="align: right"]$5.00[/TD]
[TD="align: right"]$25.50[/TD]
[TD="align: right"]$5.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.50[/TD]
[TD="align: right"]$5.00[/TD]
[TD="align: right"]$5.00[/TD]
[TD="align: right"]$5.00[/TD]
[TD="align: right"]$5.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]7[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]Client 3[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$6.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$2.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$9.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$3.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$2.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$3.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$8.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.00[/TD]
[TD="align: right"]$2.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$3.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$3.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]8[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]Client4[/TD]
[TD="align: right"]$3.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$2.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.00[/TD]
[TD="align: right"]$14.00[/TD]
[TD="align: right"]$4.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$4.00[/TD]
[TD="align: right"]$4.00[/TD]
[TD="align: right"]$2.00[/TD]
[TD="align: right"]$8.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$4.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$4.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]9[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$25.50[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$8.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.50[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$8.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$8.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$22.50[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$5.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.50[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$8.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.50[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$8.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.50[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]10[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]Client6[/TD]
[TD="align: right"]$5.50[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$3.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.50[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.50[/TD]
[TD="align: right"]$1.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.50[/TD]
[TD="align: right"]$21.50[/TD]
[TD="align: right"]$7.00[/TD]
[TD="align: right"]$0.50[/TD]
[TD="align: right"]$2.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$7.00[/TD]
[TD="align: right"]$5.00[/TD]
[TD="align: right"]$21.00[/TD]
[TD="align: right"]$1.00[/TD]
[TD="align: right"]$2.00[/TD]
[TD="align: right"]$7.00[/TD]
[TD="align: right"]$2.00[/TD]
[TD="align: right"]$7.00[/TD]
[TD="align: right"]$2.00[/TD]
</tbody>
<tbody>
</tbody>
Fee Changes
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:194px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"></colgroup><tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=339966]#339966[/URL] , align: center"]Account[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=339966]#339966[/URL] , colspan: 8, align: center"]March 2019[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]2[/TD]
[TD="align: center"]Total (AUD)[/TD]
[TD="align: center"]Total[/TD]
[TD="colspan: 2, align: center"]G[/TD]
[TD="colspan: 2, align: center"]F[/TD]
[TD="colspan: 2, align: center"]B[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]3[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]4[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]5[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]Client1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]6[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]7[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]Client 3[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]8[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]Client4[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]9[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]10[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]Client6[/TD]
</tbody>
<tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
I'm hoping some excel genius can help me with this query I have;
On the attached sheet I have 2 tabs, 'Fee Summary' that houses the info & 'Fee Changes' where I want the data to show.
The same 8 columns are replicated for each month on tab Fee Summary. I would like to show that data on the Fee Changes tab depending on the month that is picked on tab Fee Changes in columns B:I. It also has to correspond to the correct client on each row. I can bring in 1 months info using an index match but I can't for the life of me work out how to make it change dynamically once the certain month is picked.
The drop down list of dates will be in cells B:I on 'Fee Changes' tab.
Hoping someone can help
Thanks
C:\Users\Eimear\Documents\EJHTMLe\TempJean.htm
Fee summary
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y |
| |||||||||||||||||||||||||
Total | | | | ||||||||||||||||||||||
Client 2 | | | | ||||||||||||||||||||||
| | | |||||||||||||||||||||||
Client5 | |||||||||||||||||||||||||
| | |
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:194px;"><col style="width:98px;"><col style="width:81px;"><col style="width:110px;"><col style="width:90px;"><col style="width:110px;"><col style="width:90px;"><col style="width:110px;"><col style="width:91px;"><col style="width:92px;"><col style="width:81px;"><col style="width:110px;"><col style="width:90px;"><col style="width:110px;"><col style="width:90px;"><col style="width:110px;"><col style="width:91px;"><col style="width:105px;"><col style="width:81px;"><col style="width:110px;"><col style="width:90px;"><col style="width:110px;"><col style="width:90px;"><col style="width:110px;"><col style="width:91px;"></colgroup><tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=339966]#339966[/URL] , align: center"]Account[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=339966]#339966[/URL] , colspan: 8, align: center"]March 2019[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=339966]#339966[/URL] , colspan: 8, align: center"]February 2019[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=339966]#339966[/URL] , colspan: 8, align: center"]January 2019[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]2[/TD]
[TD="align: center"]Total (AUD)[/TD]
[TD="align: center"]Total[/TD]
[TD="colspan: 2, align: center"]G[/TD]
[TD="colspan: 2, align: center"]F[/TD]
[TD="colspan: 2, align: center"]B[/TD]
[TD="align: center"]Total (AUD)[/TD]
[TD="align: center"]Total[/TD]
[TD="colspan: 2, align: center"]G[/TD]
[TD="colspan: 2, align: center"]F[/TD]
[TD="colspan: 2, align: center"]B[/TD]
[TD="align: center"]Total (AUD)[/TD]
[TD="align: center"]Total[/TD]
[TD="colspan: 2, align: center"]G[/TD]
[TD="colspan: 2, align: center"]F[/TD]
[TD="colspan: 2, align: center"]B[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]3[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: center"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: center"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: center"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: center"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: center"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: center"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: center"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: center"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: center"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]4[/TD]
[TD="align: right"]$29.00[/TD]
[TD="align: right"]$11.00[/TD]
[TD="align: right"]$2.00[/TD]
[TD="align: right"]$2.00[/TD]
[TD="align: right"]$4.00[/TD]
[TD="align: right"]$8.00[/TD]
[TD="align: right"]$2.00[/TD]
[TD="align: right"]$97.50[/TD]
[TD="align: right"]$28.00[/TD]
[TD="align: right"]$6.50[/TD]
[TD="align: right"]$5.50[/TD]
[TD="align: right"]$15.50[/TD]
[TD="align: right"]$28.00[/TD]
[TD="align: right"]$14.00[/TD]
[TD="align: right"]$90.00[/TD]
[TD="align: right"]$12.00[/TD]
[TD="align: right"]$5.00[/TD]
[TD="align: right"]$28.00[/TD]
[TD="align: right"]$8.50[/TD]
[TD="align: right"]$28.00[/TD]
[TD="align: right"]$8.50[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]5[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]Client1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$3.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$6.50[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$2.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.50[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$5.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]6[/TD]
[TD="align: right"]$10.50[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$3.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.50[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.50[/TD]
[TD="align: right"]$2.00[/TD]
[TD="align: right"]$4.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.50[/TD]
[TD="align: right"]$21.00[/TD]
[TD="align: right"]$5.00[/TD]
[TD="align: right"]$5.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$1.00[/TD]
[TD="align: right"]$5.00[/TD]
[TD="align: right"]$5.00[/TD]
[TD="align: right"]$25.50[/TD]
[TD="align: right"]$5.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.50[/TD]
[TD="align: right"]$5.00[/TD]
[TD="align: right"]$5.00[/TD]
[TD="align: right"]$5.00[/TD]
[TD="align: right"]$5.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]7[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]Client 3[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$6.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$2.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$9.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$3.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$2.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$3.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$8.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.00[/TD]
[TD="align: right"]$2.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$3.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$3.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]8[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]Client4[/TD]
[TD="align: right"]$3.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$2.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.00[/TD]
[TD="align: right"]$14.00[/TD]
[TD="align: right"]$4.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$4.00[/TD]
[TD="align: right"]$4.00[/TD]
[TD="align: right"]$2.00[/TD]
[TD="align: right"]$8.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$4.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$4.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]9[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$25.50[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$8.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.50[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$8.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$8.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$1.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$22.50[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$5.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.50[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$8.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.50[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$8.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.50[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]10[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]Client6[/TD]
[TD="align: right"]$5.50[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$3.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.50[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.50[/TD]
[TD="align: right"]$1.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]$0.50[/TD]
[TD="align: right"]$21.50[/TD]
[TD="align: right"]$7.00[/TD]
[TD="align: right"]$0.50[/TD]
[TD="align: right"]$2.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$7.00[/TD]
[TD="align: right"]$5.00[/TD]
[TD="align: right"]$21.00[/TD]
[TD="align: right"]$1.00[/TD]
[TD="align: right"]$2.00[/TD]
[TD="align: right"]$7.00[/TD]
[TD="align: right"]$2.00[/TD]
[TD="align: right"]$7.00[/TD]
[TD="align: right"]$2.00[/TD]
</tbody>
Spreadsheet Formulas | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
<tbody> </tbody> |
<tbody>
</tbody>
Fee Changes
| A | B | C | D | E | F | G | H | I |
| |||||||||
Total | |||||||||
| | | | | | | | ||
Client 2 | | | | | | | | | |
| | | | | | | | ||
| | | | | | | | ||
Client5 | | | | | | | | | |
| | | | | | | |
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:194px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"></colgroup><tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=339966]#339966[/URL] , align: center"]Account[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=339966]#339966[/URL] , colspan: 8, align: center"]March 2019[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]2[/TD]
[TD="align: center"]Total (AUD)[/TD]
[TD="align: center"]Total[/TD]
[TD="colspan: 2, align: center"]G[/TD]
[TD="colspan: 2, align: center"]F[/TD]
[TD="colspan: 2, align: center"]B[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]3[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]4[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]5[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]Client1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]6[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]7[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]Client 3[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]8[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]Client4[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]9[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]10[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]Client6[/TD]
</tbody>
Spreadsheet Formulas | ||||||||||||||||||
<tbody> </tbody> |
<tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
Last edited: