I am trying to write a simple macro in excel to do some calculations and copy and paste the sum from cell O2 to cell T2. Do some more calculations and copy and paste the sum from cell O2 to cell T3 (next cell) and continue the process till it's finished. I am not sure how I can get code to paste the value in the next cell (T3). Here are the codes I have done so far. Can you please help? Thank you.
Please Login or Register to view this content.
Last edited by davesexcel; 03-14-2021 at 07:16 AM.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Hello AlphaFrog,
Thank you for your prompt reply. These codes does the job, but not all of it. On my spreadsheet the cell "O1" is the sum of "O2:O1803". I would like the macro to copy the value of this sum in to cell "T2". And the next new sum in to cell "T3" and so on till end. Is this possible to include in this code? If so, how would do it? Thank you for your help.
In the code, Change the O2 to O1
Great, Thank you AlphaFrog.
Hello AlphaFrog,
I would like to add the "If" statement to this code. See below codes. What am I doing wrong?
Thank you for your help.Please Login or Register to view this content.
Change the Else to End If
Thank you AlphaFrog. It works like a magic.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks