Cost Report VBA

[mak_pj]

hello.
I want to search for project cost my date in sheet No3 and i want to know project cost in sheet NO4, I attach file to see what i want to do
any help i appreciate that
thank you
mak_pj

[Richard Buttrey]

Why do you need VBA?

Some simple INDEX() MATCH() functions or Data foltering should provide all you want.

[mak_pj]

i want it vba cose the project not same another one i want when i click the buton return to the value of the project expense not all expense (expense of the project only)(date that i enter for the project only)

[Richard Buttrey]

i want it vba cose the project not same another one i want when i click the buton return to the value of the project expense not all expense (expense of the project only)(date that i enter for the project only)

Yes, I understand that.
The question is why do you need to use VBA to do this?
A Pivot Table with a Slicer to select Projects wouldseem the most obvious and be much more useful. See attached.

Always use standard Excel functionality when it's available. Only use VBA as a last resort.

[mak_pj]

thanks alot Richard Buttrey