AStereotypicalGamer
New Member
- Joined
- Dec 5, 2016
- Messages
- 4
So I work for an IT reseller and deal with a lot of quotes and spreadsheets daily - recently I was moved to help cover another department and noticed that they were doing A LOT of manual work that seems unnecessary. I have cleaned most of it up and automated using AutoHotKey or other means but one thing I am still working on is trying to format their quotes with a few clicks of a button.
TL;DR, I am trying to create 2 VBA macros that will search the sheet and remove the rows and columns that contain the below headers:
ROW Headers
COLUMN Headers
I have tried to piece together macros I have found here and elsewhere but they keep breaking or deleting things they shouldn't.
Thanks,
TL;DR, I am trying to create 2 VBA macros that will search the sheet and remove the rows and columns that contain the below headers:
ROW Headers
Code:
Net Quote Amount:, Total Fee %:, Fee Amount:, Quote Net Total and Fee Amount:, Notes:, Bill to Name:, Bill to ID:, Customer Number:, Created By:, Created Date(DD-Mon-YYYY):, Last Modified(DD-Mon-YYYY):, Total Errors/Warnings:, Severe Errors:, Warnings:, Channel:, Intended Use:, Currency:, Co-Term:, Co-Term Date(DD-Mon-YYYY):, Deal ID:, Partner Reference Number:, Earliest Price Protection End Date(DD-Mon-YYYY):, Flexible Invoicing Quote:, Solcat#:, Display Partner Discount:, Taxability Value:
COLUMN Headers
Code:
REVENUE SOURCE CODE, HOST ID, OLD/REPLACED SN, PRODUCT CATEGORY, PRODUCT PO, PRODUCT SO, SOURCE CONTRACT NUMBER, SOURCE SERVICE LEVEL, SOURCE SERVICE END DATE(DD-MON-YYYY), TAKEOVER TYPE, TAKEOVER LINE TYPE, PRICE PROTECTION BEGIN DATE(DD-MON-YYYY), PRICE PROTECTION END DATE(DD-MON-YYYY), GU ID, GU NAME, SITE ADDRESS LINE 3, INSTALL SITE CONTACT FIRST NAME, INSTALL SITE CONTACT LAST NAME, INSTALL SITE CONTACT EMAIL, INSTALL SITE CONTACT PHONE, DELIVERY METHOD, EDELIVERY EMAIL, PAK PREFERENCE, ROUTING SHIPPING PREFERENCE, SHIPPING SERVICELEVEL, SHIPPING CARRIER, SHIPPING CARRIER ACCTNUMBER, SERVICE LINE ID, SHIPTO SITE ID, SHIPTO CONTACT ID, SHIPTO NAME, SHIPTO ADDRESS1, SHIPTO ADDRESS2, SHIPTO ADDRESS3, SHIPTO CITY, SHIPTO STATE, SHIPTO COUNTRY, SHIPTO ZIP, SHIPTO FIRST NAME, SHIPTO LAST NAME, SHIPTO TELEPHONE, SHIPTO FAX, SHIPTO EMAIL, PERCENTAGE REFERENCE CURRENCY, % OF PRODUCT PRICE
PRODUCT LIST PRICE, STANDARD SERVICE DISCOUNT - USD%, EFFECTIVE TOTAL ADJUSTED AMOUNT, CREDIT ADJUSTMENT, ANNUAL SERVICE LIST PRICE
I have tried to piece together macros I have found here and elsewhere but they keep breaking or deleting things they shouldn't.
Thanks,