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
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