VBA Data table columns 1 and 2 determine value in 2 different cells outside the table.

[JulianvO]

Greetings

I have a data table - "Gas". I need to show in cell E3 how many gas cylinders are full and in cell F3 how many are empty.
If Date in Use and Date Empty have values - Dates - then cell F5 must show 1. If only Date in Use has a value - Date - then Cell E3 will show 1.

Can someone assist me with VBA code?

Thanks Julian

 

[igold]

Why do you need VBA, if given the logic you suggest would something like this work...

Book1
	A	B	C	D	E	F	G
1
2		Date In Use	Date Empty		Qty Full	Qty Empty
3		4/5/2024	5/8/2024		1	1
4		5/8/2024
5
6
7
8
9
10
11
12
13
14
Sheet1

Cell Formulas
Range	Formula
E3	E3	=COUNTA(Gas[Date In Use])-COUNTA(Gas[Date Empty])
F3	F3	=COUNTA(Gas[Date Empty])

 

[JulianvO]

Why do you need VBA, if given the logic you suggest would something like this work...

Book1
	A	B	C	D	E	F	G
1
2		Date In Use	Date Empty		Qty Full	Qty Empty
3		4/5/2024	5/8/2024		1	1
4		5/8/2024
5
6
7
8
9
10
11
12
13
14
Sheet1

Cell Formulas
Range	Formula
E3	E3	=COUNTA(Gas[Date In Use])-COUNTA(Gas[Date Empty])
F3	F3	=COUNTA(Gas[Date Empty])

Thank you Igold.

Appreciate the help

 

[igold]

You're welcome, I was happy to help. Thanks for the feedback!