Macro to sum selected cells into a new row - size and positions ARE RELATIVE

[macropulos]

Hi guys after great experience with the geniuses on this forum iam asking for more of your time and expertise to solve this little porblem… iam to newbie in excel to figure this out myself… if somebody find some time to look at this i would be very thankfull

Iam working on a bit advanced food diary… ill show you on pictures what i would need if anyone have a bit of time to help me please…

check the attached diagrams and the sample excel (had to use xlsx or some functionality error pops-up)...

As you can see from diagrams i need quite a simple macro that will take a manually selected region (which will be sometimes 1 line, sometimes 2 or more so it has to be flexible) and SUM the columns of the selected region into new row of cells which will be positioned relatively to the position of the source region…

The main trouble is the relative size of the source region (sometimes i will select 1 line sometimes more) and the generated row with SUM of values must be always positioned relatively to the currently used region - always relatively to the top line, right corner of the source region…

plaease check the pictures and maybe if you can… post a macro code that i can paste into macro editor and assign a simple shortcut that will trigger the macro AFTER i manually select the region i want to SUM

any help greatlly apreciated… thanks everyone

macro03.gifmacro02.gifmacro01.gifmacro_sample.xlsx