Estimate, print area if quantity is over 0

MrBiggalo - Mar 1, 2018 at 03:29 PM - Latest reply: ac3mark 9622 Posts Monday June 3, 2013Registration dateModeratorStatus June 22, 2018 Last seen
- Mar 1, 2018 at 05:08 PM
Hello,

I am trying to make estimate software for a remodeling company. I just want the description to be printed or copies to clip board if quanity is over 0. Example direct from excel file.

A4 says "Permit Fees" B4 says each Permit costs $1 and C4 has Quantity, D4 is B4*C4.

What I want to happen is have A4 printed to word or copied to clip board if C4 is over 0, or has any input at all. I do not want anything but A4 to be printed as I want it to be vague and not have costs per line. Customers get too hung up on that.

Id preferably would like all this data from multiple sheets to export into a word file, thus generating an estimate to the customer from the excel sheet. I can rework something like this if it already made.

Thanks for help


See more 

Your reply

1 reply

ac3mark 9622 Posts Monday June 3, 2013Registration dateModeratorStatus June 22, 2018 Last seen - Updated by ac3mark on 1/03/18 at 05:10 PM
0
Thank you
Check for the LEN of the cell. So something like:
=LEN(a1)


If A1 contained "hello", your formula would return "5".

Check this out:
https://msdn.microsoft.com/en-us/vba/language-reference-vba/articles/len-function


After you have that, we will move on to making it print if you hit a particular key.

Good luck, and have fun!

Respond to ac3mark