oam
10-20-2021, 11:48 AM
I have a worksheet with a large amount of production data broken up into production years and what I am needing is to find the last data entered in a column if the production year matches.
What I need it to do is look at column B last row and if the cell on Sheet3 D3 matches number in column B last row data entered it will return the last data from column J entered for that production year.
Thank you are any and all help
A
B
C
D
E
F
G
H
I
J
K
Row
Day of Production
Production Year #
Total ABC Production
Pipe QC
Total ABCQC Production
Total Daily Production
Start Date
End Date
Total Year Production
Total Year Over Contract
ABCQC
Over Contract
2
10
3
10
4
10
5
10
6
10
What I need it to do is look at column B last row and if the cell on Sheet3 D3 matches number in column B last row data entered it will return the last data from column J entered for that production year.
Thank you are any and all help
A
B
C
D
E
F
G
H
I
J
K
Row
Day of Production
Production Year #
Total ABC Production
Pipe QC
Total ABCQC Production
Total Daily Production
Start Date
End Date
Total Year Production
Total Year Over Contract
ABCQC
Over Contract
2
10
3
10
4
10
5
10
6
10