Can anyone let me know why this code is not working?? It copies formula from T2 to last row. Then at Last row the total is the SUM calculation we need......dont know where we are going wrong.....
Please Login or Register to view this content.
Can anyone let me know why this code is not working?? It copies formula from T2 to last row. Then at Last row the total is the SUM calculation we need......dont know where we are going wrong.....
Please Login or Register to view this content.
You don't seem to have any line of code that would copy down the formula from T2 though?
I assume the last row always returns 2?
Would need to know which column we can use to know what the last row is...
Assuming for example that "S" always has data in the last row:
Please Login or Register to view this content.
Last edited by Arkadi; 04-24-2018 at 01:54 PM.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
we require that the formula in T2 be copied down to the end of last row. And at the end Last row we need to calculate total SUM of All...Enclosed worksheet...
Q has data till last row....
Will the formulas in your example in R5 and S5 already be there when the macro runs? Or will the macro add those formulas also?
Please Login or Register to view this content.
Last edited by Arkadi; 04-24-2018 at 02:01 PM. Reason: Forgot code tags
macro adds formula too....
Or maybe
Please Login or Register to view this content.
ohhhh....thanks a tonne arkadi.......you are great... gave the solution at lightening speed.....itt works........ you deserve double rep..... hope they have double or treble reps to be given......))) thanks a lot once again.....
thanks jolivanes...your code too is amazing....u simplified it more like a excel ninjaaaaaaaaaaa...... wowow... !! )))... given u too a rep...
Thanks for letting us know that it worked to your liking and thanks for the rep.
Good luck
Thanks for the feedback and the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks