An "adding" PASTE and a CELL update

[drgkt]

Hi

I need 2 macros:

1. An ordinary macro that would copy values only of G7:G29 pasting them to H7:H29 BUT adding the G value to the H value.
For example, H11 would become 223.74.

2. An automatic sheet changing macro that when a value (numeric) is entered in J7:J29, that value would be subtracted from either the value in H or I, same row, which ever is filled, and the value in H or I would be updated.
(H and I will NEVER have values on the SAME row).
The value entered in J cannot be greater than the value entered in H or I.

[drgkt]

Anyone please...

[vichopalacios]

1.-

Please Login or Register  to view this content.

2.-

Please Login or Register  to view this content.

[drgkt]

Thank you for helping me achieve this!
edit: Thank you for achieving this for me!

Re: sheet code

On testing, I saw once the message that the value was greater than H or I, not seeing it any more nor the values are reduced by J

[drgkt]

Re Macro 1.

To get rid of zeros I changed formula in G7:G29 to "=IF(E7="√";"";IF(D7-F7=0;"";D7-F7))"
Now I am getting RunTime ERROR 13: Type mismatch
Sht.Cells(i, 8).Value = Sht.Cells(i, 7).Value + Sht.Cells(i, 8).Value


p.s. If G is blank and H is blank H becomes zero instead of be left blank

[drgkt]

Ok. Despite the minor details above,

Macro 1: Usable as is, and optionally formatting zero values to be invisible.

HOWEVER

Macro 2: Is not working as supposed to. Sometimes it gives the message "Value is grater than H or I", sometimes it is not, BUT FAILS to add the value to either H or I.


Someone to take a look in the code please!

[drgkt]

Deleted this post

[vichopalacios]

Hi @ drgkt

My answers take sometimes longer than you may like
I'm sory, I'm not a 24/7 follower of this site, I just come here from time to time, when I'm free, and feel the liking.

for macro#1
If you want not to do anything when there is nothing in H(i), then you can change to this:

Please Login or Register  to view this content.

for macro# let me check, I think I understand your point.

[vichopalacios]

Hi @ drgkt

Macro 2: Is not working as supposed to. Sometimes it gives the message "Value is grater than H or I", sometimes it is not, BUT FAILS to add the value to either H or I.

I think I found the bug.
by sure, with the previous code, after you saw the "Value is greater than H or I" message, the worksheet started to show a weird performance.
it was because we ended the sub leaving "Application.EnableEvents = False"
now, try with this please.

Please Login or Register  to view this content.