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
[TABLE="width: 5204"]
<TBODY>[TR]
[TD]Cascade ID</SPAN>[/TD]
[TD]Concurrent Permit </SPAN>[/TD]
[TD]STOP WORK </SPAN>[/TD]
[TD]RF Cluster</SPAN>[/TD]
[TD] GD SAM </SPAN>[/TD]
[TD]Site Ac Vendor</SPAN>[/TD]
[TD]A&E Vendor</SPAN>[/TD]
[TD]MLA Landlord</SPAN>[/TD]
[TD]Non-MLA Landlord </SPAN>[/TD]
[TD]Landlord Site Number</SPAN>[/TD]
[TD]Add. Ground Landlord</SPAN>[/TD]
[TD]Site Type</SPAN>[/TD]
[TD]Leasing Required </SPAN>[/TD]
[TD]Jurisdiction Name </SPAN>[/TD]
[TD]Zoning Type</SPAN>[/TD]
[TD]Zoning Duration</SPAN>[/TD]
[TD]Permit Type</SPAN>[/TD]
[TD]Permit Duration</SPAN>[/TD]
[TD]Structural Results</SPAN>[/TD]
[TD]Structural Capacity %</SPAN>[/TD]
[TD]Mount Analysis Results</SPAN>[/TD]
[TD]Mount Ordered</SPAN>[/TD]
[TD]2C Status</SPAN>[/TD]
[TD]AM Study Required</SPAN>[/TD]
[TD]MW/AAV</SPAN>[/TD]
[TD]MW Donor</SPAN>[/TD]
[TD]Priority</SPAN>[/TD]
[TD]COMMENTS
(Most Recent Comments First)</SPAN>[/TD]
[TD]Hot Swap</SPAN>[/TD]
[TD]Crane Needed</SPAN>[/TD]
[TD]NEPA STATUS</SPAN>[/TD]
[TD]A&E Status</SPAN>[/TD]
[TD]PO Status</SPAN>[/TD]
[TD]NTP Status</SPAN>[/TD]
[TD]Sprint Category</SPAN>[/TD]
[TD]Engineering Survey</SPAN>[/TD]
[TD]COLO Application</SPAN>[/TD]
[TD]Real Estate Entitlements Complete</SPAN>[/TD]
[TD]Zoning Process Filed</SPAN>[/TD]
[TD]Zoned</SPAN>[/TD]
[TD]Construction Drawings</SPAN>[/TD]
[TD]Building Permit (BP) Application</SPAN>[/TD]
[TD]Building Permits</SPAN>[/TD]
[TD]NEPA Land Use Report and Backup Docs (includes SHPO)</SPAN>[/TD]
[TD]Structural Evaluation Ordered</SPAN>[/TD]
[TD]Structural Evaluation Complete</SPAN>[/TD]
[TD] [/TD]
[TD]3G Site Acquisition Complete</SPAN>[/TD]
[TD]4G Site Acquisition Complete</SPAN>[/TD]
[TD]NTP Submitted to Sprint</SPAN>[/TD]
[TD]NTP'd</SPAN>[/TD]
[TD]OUT OF SEQUENCE</SPAN>[/TD]
[TD]Construction Start </SPAN>[/TD]
[TD]NTP TO CX OUT OF SEQUENCE</SPAN>[/TD]
[/TR]
</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>[/TABLE]

 

[Andrew Poulsom]

Welcome to MrExcel.

See if something here helps you:

Copy/Paste/Merge examples