Did you run an earlier version by mistake?
Have you put the new BlankQuote in the directory C:\Users\Administrator\Desktop\W\Reports\?
Are you opening the correct BlankQuote? It will have the timestamp on it similar to my attachment above.
Printable View
Did you run an earlier version by mistake?
Have you put the new BlankQuote in the directory C:\Users\Administrator\Desktop\W\Reports\?
Are you opening the correct BlankQuote? It will have the timestamp on it similar to my attachment above.
Ok it was me, I had the BlankQuote.xlsx in the incorrect location. I fixed that.
Then I had to not delete row1 so that item # 1221 would work.
Then I re added the line to hide sheet 2.
I'll have the team go over and make sure it works for them as intended.
This is great! You have been a substantial help!
Other than adding rep to you how else can I repay the time and effort?!
No need for repayment, I'm a VBA intern and learning is payment enough! It is nice to help people, especially in these unprecidented times.
Take care and stay safe :thumb
PS Thanks for the Rep!
BTW, while I was testing I used a count-down routine that enables you to interupt the macro within 10 secs of opening the file. If you don't press a button within the 10 secs the macro runs as normal. You may find it handy for testing yourself, so I've attached it.
Just wanted to give an update! Everything is working beautifully, all 3 sheets have been successfully implemented into routine!
Again thank you very much, I am now excited to start looking for other VBA projects to optimize time!
Excellent! Stay safe :thumb
Hello again!
So far everyone is very happy and all of the Pricebooks/Quote Forms are working beautifully!
So again, thank you!
So I have a new VBA Project, should I continue here, or make a new thread?
Hi. Glad it's all okay :thumb
You would have to start a new thread, Stay Safe!
And mark this one [SOLVED] using Thread Tools above your first post