Jaiecutler
New Member
- Joined
- Jul 2, 2013
- Messages
- 2
I would like to transfer only changed data from 4 spreadsheets to one that I receive daily, it's quite time consuming using vlookup because the data varies depending upon who sends me the information. Below are the headers I need to populate from each spreadsheet, don't know if it helps. all the spreadsheets are similar in nature
<TBODY>
</TBODY><COLGROUP><COL span=2><COL><COL><COL span=5><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL span=2><COL><COL><COL><COL><COL span=3><COL><COL><COL><COL><COL span=2><COL><COL><COL></COLGROUP>
Cascade ID</SPAN> | Concurrent Permit </SPAN> | STOP WORK </SPAN> | RF Cluster</SPAN> | GD SAM </SPAN> | Site Ac Vendor</SPAN> | A&E Vendor</SPAN> | MLA Landlord</SPAN> | Non-MLA Landlord </SPAN> | Landlord Site Number</SPAN> | Add. Ground Landlord</SPAN> | Site Type</SPAN> | Leasing Required </SPAN> | Jurisdiction Name </SPAN> | Zoning Type</SPAN> | Zoning Duration</SPAN> | Permit Type</SPAN> | Permit Duration</SPAN> | Structural Results</SPAN> | Structural Capacity %</SPAN> | Mount Analysis Results</SPAN> | Mount Ordered</SPAN> | 2C Status</SPAN> | AM Study Required</SPAN> | MW/AAV</SPAN> | MW Donor</SPAN> | Priority</SPAN> | COMMENTS (Most Recent Comments First)</SPAN> | Hot Swap</SPAN> | Crane Needed</SPAN> | NEPA STATUS</SPAN> | A&E Status</SPAN> | PO Status</SPAN> | NTP Status</SPAN> | Sprint Category</SPAN> | Engineering Survey</SPAN> | COLO Application</SPAN> | Real Estate Entitlements Complete</SPAN> | Zoning Process Filed</SPAN> | Zoned</SPAN> | Construction Drawings</SPAN> | Building Permit (BP) Application</SPAN> | Building Permits</SPAN> | NEPA Land Use Report and Backup Docs (includes SHPO)</SPAN> | Structural Evaluation Ordered</SPAN> | Structural Evaluation Complete</SPAN> | 3G Site Acquisition Complete</SPAN> | 4G Site Acquisition Complete</SPAN> | NTP Submitted to Sprint</SPAN> | NTP'd</SPAN> | OUT OF SEQUENCE</SPAN> | Construction Start </SPAN> | NTP TO CX OUT OF SEQUENCE</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL span=2><COL><COL><COL span=5><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL span=2><COL><COL><COL><COL><COL span=3><COL><COL><COL><COL><COL span=2><COL><COL><COL></COLGROUP>