update one spreadsheet everyday from several

[Jaiecutler]

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

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>

 

[Andrew Poulsom]

Welcome to MrExcel.

See if something here helps you:

Copy/Paste/Merge examples