Hi - I need to automate some Excel work with use of VBA but I have never done anything this complex before. Could you perhaps show me where to start?
Firstly, I need some kind of "count" function that I can increment. This will help me keep track of a quantitative process. E.g. an integer that increments each time I an IF statement is successful. I will also need to reset the count to 0 every now and then.
Secondly, I need to somehow refer to cell references. E.g. copy cell A5 and paste into [cell reference - 1]. I will also need to increment this cell reference.
Thanks!
Bookmarks