VBA Problem: How to call the last number typed in each line but in different columns

[Guilherme.Cristofoli]

Hello Friends!

Here is my problem so you can understand... I have products in inventory (lines) and the days of the month (columns), my need is to have the last quantity of product registered by the system at the end of the period, but here is the catch, the system updates the inventory in different periods for each type of product.
I have almost 350 products so I will need to have a loop or something like that at the end of the script...

At the moment I thought to do trough: select cell K3 > type SUM > select the left cell, and press Ctrl + Shift + Left > enter...
But how can I automate this process and repeat it for every line?

If someone could type the VBA script here, I would appreciate it a lot!

Hugs!Capturar2.JPG

[6StringJazzer]

Is there any reason you want to do this with VBA? If you put this formula in column H you won't need VBA:

Please Login or Register  to view this content.

Copy down.

[Guilherme.Cristofoli]

Man! You saved me! Thank you very much!

[6StringJazzer]

You are very welcome, and thanks for the rep!



If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."