Sub BEQUOTE()
'Step 1 Copy the data
Please Login or Register to view this content.
'Step 2 Open BE QUOTE FORMPlease Login or Register to view this content.
'Step 3 Paste the dataPlease Login or Register to view this content.
Please Login or Register to view this content.
'Step 4 Define Path Names and File NamePlease Login or Register to view this content.
‘Year, i.e. 2016’Please Login or Register to view this content.
‘Month, i.e. K-OCT’Please Login or Register to view this content.
‘Quote Number, i.e. X123456-XX’Please Login or Register to view this content.
‘Customer Name, i.e. ABC Co.”Please Login or Register to view this content.
‘Evaluates as 2016’Please Login or Register to view this content.
‘Fails to Evaluate’Please Login or Register to view this content.
‘Evaluates as X123456-XX’Please Login or Register to view this content.
‘Evaluates as ABC Co.’Please Login or Register to view this content.
'Step 5 Turn off application alerts
'Step 6 Save the newly created workbookPlease Login or Register to view this content.
'Step 7 Turn application alerts back onPlease Login or Register to view this content.
End SubPlease Login or Register to view this content.
Bookmarks