how to transpose values without selecting the cell

you guys have spoiled me. i need some help with some coding. i'm trying to copy and transpose some info without actually selecting the cells. the following code works but the cells get selected in excel.

Please Login or Register  to view this content.

what i'm looking for is something that works like this:
'

Please Login or Register  to view this content.

Where you the user never see the macro running and it does not look like a ghost copying and pasting.

Some background:
In the spread sheet i'm trying to finish the macro that must run, must copy information from a few sheets to a sheet for that month, then it must clear the copied info from those sheets. But the first step would be to copy totals in C19:L19 in the inputs page and copy it to B28:B27 for July (transposing it). The macro determines the cell by another macro that tells it which month to select. for example:

Please Login or Register  to view this content.

Then i named a Cell under each month to help it select the right place. the whole code for that macros is:

Please Login or Register  to view this content.

i dimmed(') the parts that are working and have modified the code since i first started on it to try incorporate the "variables" or what ever the "dims" are.
i am also attaching the spread sheet. the other months tabs are not there as i will copy and past them from the "Jul" tab then rename them

thanks the second one worked for me