Making last cell in vba code with sumifs

Hi Guys
I have some code I have been given. From this forum but unusually I have not kept the member's name. It works great but does not allow me to add more rows unless I alter the last row number. I have tried fiddling with it without any luck.

Here it is

Please Login or Register  to view this content.

The code is on a sheet called Summary. It looks up data in a sheets called Transactions within data parameters which are fine. 2033 is the hard wired last row. I could easily just change it each time but would love to have it clean.

Any help greatly appreciated

All the best

Mark
Overcast here in London but may get better later

Hi TMS

Too much for a Saturday morning. Made me laugh way before looking at your code. 'Being unapologetic means never having to say you're sorry' John Cooper Clarke. I will be using it though I won't pretend its mine.
“Always forgive your enemies; nothing annoys them so much.”
– Oscar Wilde

I have several sheets all linked and use a control sheet where there are tables. In this instance I have B3 to B62, I deactivated my original B3 line and popped in your code. I am getting the dreaded #VALUE!. Not sure why. I will keep looking about but if I am not successful could i Please send you a few sheets. It is no doubt a simple alteration but my knowledge is limited.
Thank you
Mark

Hi TMS
My original workbook was way too large. Took me time to strip it. Note I have spent summary as summaryy intentionally.
The function is on the Summarry screen. Hopefully it will open on that screen. B3.
I have left the VBA as I had it save that I have removed Transactions to make the file smaller. Now only BDC2.
If you open the VBA you will see the specific code two thirds way down immediately below 8 rows of ++++.
Hope this makes sense.
Please feel free to make any critique of the VBA as you think fit. You will see it has be cobbled together indicating the level of my experience. This year I intend to improve.

Mark

AHHH Can't upload my file. I have opened advanced and the paper clip is there but it only opens a tiny box below it not an upload dialogue ox of my files. Tried googling for a solution but none.

Can't see where the attachment should show. Unless you are supposed to do the same. I expect the alteration is related to the security issue.
Mark

Hi TMS
Its been a while since I was able to get back to this. Thank you very much but I'm not sure this is what I am looking for. I had entered row 2033 'R2033C5' in my VBA as I could not work out how to enter the last row. What you have here is row 6. This is part of my accounts system and I know that I could buy one but prefer to make it. I need a function / formula that accepts varying number of rows. I must have asked my question incorrectly when I said last cell. Perhaps I should have said last row.

Mark

Hi TMS
Reading your text I can see that you are on the same page and it is me that is not able to get it .... as yet. But I will. Have people staying for the next few days so will not be able to get back to this till they have gone. I am though blown over by your generosity in the completeness of your response.
I have so much to learn.
So an interim thank you.
Mark

Hi TMS
You must have thought me dead. Well here I am back from the grave. This is great. Obviously because it works beautifully. But also because of the excellent way you have explained it in so much detail. I had 2016 in the drop down but 2015 in the sheet so of course it was always a Zero.
Again thank you.

Mark