Am I able to do a formula for whole column on excel sheet

[tweacle]

HI

I have a workbook that is adding running totals on a 2nd sheet. At present I have it for one cell only but im trying to get the macro to run on all data in cells B7-B32 and E7-E32

Please Login or Register  to view this content.

Any Ideas?

I have posted on here too

https://www.mrexcel.com/board/thread.../#post-5849492

[WideBoyDixon]

How about this:

Please Login or Register  to view this content.

WBD

[tweacle]

big massive thanks

[tweacle]

Got one other thing that I need to add to it now if poss.

Once the data has transferred over to sheet 2 I then need the values in cells B20/B23/B26 added into the value of B17 to make a new total.

I.E lets say B17 after data transferred was a value of £5.00 and cells B20/B23/B26 were all a value of £1.00 I need the values added to the total of B17 so it then becomes £8.00
and I then need to delete the values in B20/B23/B26

Any Ideas?