Hello,
I am trying to collect data from different sheets into a table. I’dlike the table to auto-fill based on the date of the day, and matching the name. The formula shouldn’t count entries, but rather report or copy the number entered in the cell for that person on that date.
Example:
Table should populate from a sheet that looks something like this:
[TABLE="width: 284"]
<tbody>[TR]
[TD="width: 379, bgcolor: transparent, colspan: 4"]
[/TD]
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"]
[/TD]
[TD="width: 92, bgcolor: transparent"]
[/TD]
[TD="width: 92, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"]
[/TD]
[TD="width: 92, bgcolor: transparent"]
[/TD]
[TD="width: 92, bgcolor: transparent"]
[/TD]
[TD="width: 92, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"]
[/TD]
[TD="width: 92, bgcolor: transparent"]
[/TD]
[TD="width: 92, bgcolor: transparent"]
[/TD]
[TD="width: 92, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"]
[/TD]
[TD="width: 92, bgcolor: transparent"]
[/TD]
[TD="width: 92, bgcolor: transparent"]
[/TD]
[TD="width: 92, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"]
[/TD]
[TD="width: 92, bgcolor: transparent"]
[/TD]
[TD="width: 92, bgcolor: transparent"]
[/TD]
[TD="width: 92, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 103"]
[/TD]
[TD="width: 92"]
[/TD]
[TD="width: 92"]
[/TD]
[TD="width: 92"]
[/TD]
[/TR]
[TR]
[TD="width: 103"]
[/TD]
[TD="width: 92"]
[/TD]
[TD="width: 92"]
[/TD]
[TD="width: 92"]
[/TD]
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"]
[/TD]
[TD="width: 92, bgcolor: transparent"]
[/TD]
[TD="width: 92, bgcolor: transparent"]
[/TD]
[TD="width: 92, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"]
[/TD]
[TD="width: 92, bgcolor: transparent"]
[/TD]
[TD="width: 92, bgcolor: transparent"]
[/TD]
[TD="width: 92, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"]
[/TD]
[TD="width: 92, bgcolor: transparent"]
[/TD]
[TD="width: 92, bgcolor: transparent"]
[/TD]
[TD="width: 92, bgcolor: transparent"]
[/TD]
[/TR]
</tbody>[/TABLE]
And auto-fill the table that looks something like this:
[TABLE="width: 366"]
<tbody>[TR]
[TD="width: 103, bgcolor: transparent"]
[/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 17, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"]
[/TD]
[TD="width: 92, bgcolor: transparent"]
[/TD]
[TD="width: 92, bgcolor: transparent"]
[/TD]
[TD="width: 92, bgcolor: transparent"]
[/TD]
[TD="width: 17, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"]BILL
[/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 17, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"]JOHN
[/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 17, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"]GARY
[/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 17, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 17, bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]
So, if my formula were to be working properly with the example data above, my table would look like:
[TABLE="width: 366"]
<tbody>[TR]
[TD="width: 103, bgcolor: transparent"]
[/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 17, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"]
[/TD]
[TD="width: 92, bgcolor: transparent"]
[/TD]
[TD="width: 92, bgcolor: transparent"]
[/TD]
[TD="width: 92, bgcolor: transparent"]
[/TD]
[TD="width: 17, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"]BILL
[/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"]
[/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 17, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"]JOHN
[/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"]
[/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 17, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"]GARY
[/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"]
[/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 17, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 17, bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]
Any help is greatly appreciated!
I am trying to collect data from different sheets into a table. I’dlike the table to auto-fill based on the date of the day, and matching the name. The formula shouldn’t count entries, but rather report or copy the number entered in the cell for that person on that date.
Example:
Table should populate from a sheet that looks something like this:
[TABLE="width: 284"]
<tbody>[TR]
[TD="width: 379, bgcolor: transparent, colspan: 4"]
ORDERS
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"]
BILL
[TD="width: 92, bgcolor: transparent"]
JOHN
[TD="width: 92, bgcolor: transparent"]
GARY
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"]
7/10/2018
[TD="width: 92, bgcolor: transparent"]
2
[TD="width: 92, bgcolor: transparent"]
4
[TD="width: 92, bgcolor: transparent"]
1
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"]
8/15/2018
[TD="width: 92, bgcolor: transparent"]
2
[TD="width: 92, bgcolor: transparent"]
1
[TD="width: 92, bgcolor: transparent"]
2
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"]
8/16/2018
[TD="width: 92, bgcolor: transparent"]
2
[TD="width: 92, bgcolor: transparent"]
1
[TD="width: 92, bgcolor: transparent"]
2
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"]
8/17/2018
[TD="width: 92, bgcolor: transparent"]
1
[TD="width: 92, bgcolor: transparent"]
4
[TD="width: 92, bgcolor: transparent"]
3
[/TR]
[TR]
[TD="width: 103"]
8/18/2018
[TD="width: 92"]
0
[TD="width: 92"]
0
[TD="width: 92"]
0
[/TR]
[TR]
[TD="width: 103"]
8/19/2018
[TD="width: 92"]
0
[TD="width: 92"]
1
[TD="width: 92"]
0
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"]
8/20/2018
[TD="width: 92, bgcolor: transparent"]
0
[TD="width: 92, bgcolor: transparent"]
3
[TD="width: 92, bgcolor: transparent"]
1
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"]
8/21/2018
[TD="width: 92, bgcolor: transparent"]
2
[TD="width: 92, bgcolor: transparent"]
2
[TD="width: 92, bgcolor: transparent"]
1
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"]
8/22/2018
[TD="width: 92, bgcolor: transparent"]
0
[TD="width: 92, bgcolor: transparent"]
8
[TD="width: 92, bgcolor: transparent"]
10
[/TR]
</tbody>[/TABLE]
And auto-fill the table that looks something like this:
[TABLE="width: 366"]
<tbody>[TR]
[TD="width: 103, bgcolor: transparent"]
8/22/2018
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 17, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"]
REFERRALS
[TD="width: 92, bgcolor: transparent"]
ORDERS
[TD="width: 92, bgcolor: transparent"]
OUTREACH
[TD="width: 92, bgcolor: transparent"]
COMPLETED
[TD="width: 17, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"]BILL
[/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 17, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"]JOHN
[/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 17, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"]GARY
[/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 17, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 17, bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]
So, if my formula were to be working properly with the example data above, my table would look like:
[TABLE="width: 366"]
<tbody>[TR]
[TD="width: 103, bgcolor: transparent"]
8/22/2018
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 17, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"]
REFERRALS
[TD="width: 92, bgcolor: transparent"]
ORDERS
[TD="width: 92, bgcolor: transparent"]
OUTREACH
[TD="width: 92, bgcolor: transparent"]
COMPLETED
[TD="width: 17, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"]BILL
[/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"]
0
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 17, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"]JOHN
[/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"]
8
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 17, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"]GARY
[/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"]
10
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 17, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 103, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 17, bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]
Any help is greatly appreciated!
Last edited: