Hello,

I have extremely limited VBA experience but thought this was a good chance to learn.

The logic I need to perform is as follows...

I need to place a formula on a sheet that looks up if a deal has been invoiced or not from a different sheet. I used the following formula =IF('Detailed Deal Tracker'!Q3>0,VLOOKUP('Detailed Deal Tracker'!C3,'Detailed Deal Tracker'!C3:Q8,1,FALSE),"Not Invoiced")

However I would like to use a macro to create a loop where the code will just go through my column index number and only display a value if Q:Q>0 and won't have to display "Not Invoiced" as the value for If false.

If possible I would also like to have the Fee charged and the date invoiced display along side the invoiced deals.


Can someone please help?

-Thanks