Hi all!
I am a very beginning in VBA (self-study+VBA for beginners training) and I have written below macro.
I know that it is very rough and here comes my request.
This macro is working when I use "call" but it doesn't when the body of called macro is put into the main formula and I don't know why. Any ideas?
I had much trouble with loop the search of "XXX" in the proposal payment sheet. I couldn't make to search the next item.
I was able to manage the way like it is but I don't like it. I am sure that there is an easier and without changing raw data way.
Can you please roast my macro? Stress all weaknesses but with solution how to improve it in the future.... - this will be the best learning for me (on my mistakes).
Data for payment proposal are basically imported from text file (not CSV) with many empty rows and columns.
I deleted all data except the ones macro uses.
Bookmarks