Thanks Doc
FileSnack | Easy file sharing
See link to my file, hope this simplifies it a bit.
If I were you, I'd try the set up of the link. Failing that, I'd post a sample from FILE CAPTURE like below:
[TABLE="width: 529"]
<COLGROUP><COL style="WIDTH: 143pt; mso-width-source: userset; mso-width-alt: 6798" width=191><COL style="WIDTH: 119pt; mso-width-source: userset; mso-width-alt: 5660" width=159><COL style="WIDTH: 148pt; mso-width-source: userset; mso-width-alt: 7025" width=198><COL style="WIDTH: 119pt; mso-width-source: userset; mso-width-alt: 5632" width=158><TBODY>[TR]
[TD="class: xl73, width: 191, bgcolor: transparent"] [/TD]
[TD="class: xl73, width: 159, bgcolor: transparent"] [/TD]
[TD="class: xl73, width: 198, bgcolor: transparent"] [/TD]
[TD="class: xl73, width: 158, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl74"]
DATE OF TRANSACTION[/TD]
[TD="class: xl74"]
DRIVER NAME[/TD]
[TD="class: xl74"]
REGISTRATION NUMBER[/TD]
[TD="class: xl74"]
KM OUT(BRANCH)[/TD]
[/TR]
[TR]
[TD="class: xl69"]
8/8/2014[/TD]
[TD="class: xl70"]
1[/TD]
[TD="class: xl70"]
1[/TD]
[TD="class: xl70"]
1[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent"]
7/8/2014[/TD]
[TD="class: xl70, bgcolor: transparent"]
2[/TD]
[TD="class: xl70, bgcolor: transparent"]
2[/TD]
[TD="class: xl70, bgcolor: transparent"]
2[/TD]
[/TR]
[TR]
[TD="class: xl71"]
4/8/2014[/TD]
[TD="class: xl72"]
3[/TD]
[TD="class: xl72"]
3[/TD]
[TD="class: xl72"]
3[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent"]
8/8/2014[/TD]
[TD="class: xl70, bgcolor: transparent"]
4[/TD]
[TD="class: xl70, bgcolor: transparent"]
4[/TD]
[TD="class: xl70, bgcolor: transparent"]
4[/TD]
[/TR]
[TR]
[TD="class: xl69"]
2/8/2014[/TD]
[TD="class: xl72"]
5[/TD]
[TD="class: xl72"]
5[/TD]
[TD="class: xl72"]
5[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent"]
7/8/2014[/TD]
[TD="class: xl70, bgcolor: transparent"]
6[/TD]
[TD="class: xl70, bgcolor: transparent"]
6[/TD]
[TD="class: xl70, bgcolor: transparent"]
6[/TD]
[/TR]
[TR]
[TD="class: xl69"]
4/8/2014[/TD]
[TD="class: xl72"]
7[/TD]
[TD="class: xl72"]
7[/TD]
[TD="class: xl72"]
7[/TD]
[/TR]
</TBODY>[/TABLE]
The desired output in FUEL SUMMARY - MONTHLY...
[TABLE="width: 513"]
<COLGROUP><COL style="WIDTH: 134pt; mso-width-source: userset; mso-width-alt: 6371" width=179><COL style="WIDTH: 124pt; mso-width-source: userset; mso-width-alt: 5859" width=165><COL style="WIDTH: 133pt; mso-width-source: userset; mso-width-alt: 6314" width=178><COL style="WIDTH: 122pt; mso-width-source: userset; mso-width-alt: 5802" width=163><TBODY>[TR]
[TD="class: xl71, width: 179, bgcolor: transparent"] [/TD]
[TD="class: xl76, width: 165, bgcolor: transparent"]
July[/TD]
[TD="class: xl77, width: 178, bgcolor: transparent"] [/TD]
[TD="class: xl71, width: 163, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl75, bgcolor: #3ef00e"]
DATE OF TRANSACTION[/TD]
[TD="class: xl75, bgcolor: #3ef00e"]
DRIVER NAME[/TD]
[TD="class: xl75, bgcolor: #3ef00e"]
REGISTRATION NUMBER[/TD]
[TD="class: xl75, bgcolor: #3ef00e"]
KM OUT(BRANCH)[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent"]
7/8/2014[/TD]
[TD="class: xl70, bgcolor: transparent"]
2[/TD]
[TD="class: xl70, bgcolor: transparent"]
2[/TD]
[TD="class: xl70, bgcolor: transparent"]
2[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent"]
7/8/2014[/TD]
[TD="class: xl70, bgcolor: transparent"]
6[/TD]
[TD="class: xl70, bgcolor: transparent"]
6[/TD]
[TD="class: xl70, bgcolor: transparent"]
6[/TD]
[/TR]
</TBODY>[/TABLE]
July is selected from a dropdown; it's actually 7/1/2014, displayed as July.
Note. The above exhibits are directly copiable into Excel. They contain small representative samples of the relevant sheets you have in your workbook. This action makes everything accessible on the board itself, therefore preferred.
All that said:
J3: IDX
J4, control+shift+enter, not just enter, and copy down:
Rich (BB code):
=IFERROR(
SMALL(
IF('FUEL CAPTURE'!$A$3:$A$9-DAY('FUEL CAPTURE'!$A$3:$A$9)+1=$B$1,
ROW('FUEL CAPTURE'!$A$3:$A$9)-ROW('FUEL CAPTURE'!$A$3)+1),
ROWS($J$4:J4)),"")
A3, just enter, copy across to D3, and down:
Rich (BB code):
=IF($J4="","",INDEX('FUEL CAPTURE'!$A$3:$D$9,$J4,
MATCH(A$3,'FUEL CAPTURE'!$A$2:$D$2,0)))