Excel – how to copy the sum from one cell and pasting as a value in another

Topic

New Reply

I would like to know how to create a marco to do the following:

Take the value of this =SUM(H9018:K9018)

and put it in F9018.

Currently I have to copy (=SUM(H9018:K9018)) then put the cursor on F9018, right click, choose values and then hit OK. I have to do this about 50 times a day, and need a quicker method.

Any suggestions?

Thanks!

Reply | Quote

Replies

Pete,

Place your cursor in F9018.
Click the Summation Tool 31603-Sumation.
Click and drag from H9018 to J9018.
Hit Enter.
Done. :cheers:

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote