Extractor

pbenji09

New Member
Joined
Dec 11, 2015
Messages
1
I NEED TO EXTRACT DATA FROM 3 DIFFERENT SHEETS FROM 150000 FILES ONTO A SINGLE NEW WORKBOOK.
FIRST SHEET IS 'INFO' I NEED 'B9' 'B11' AND 'C2'
SECOND SHEET IS 'fSC COMM' RANGE 'H9:H79'
THIRD IS 'PCF COMM' RANGE 'H15:H84'
THE MASTER WORKBOOK NEEDS TO HAVE THE FILE NAMES AS FIRST COLUMN AND EVERY ROW FROM THE THREE SHEETS (FSCCOMM,PCF COMM AND INFO) NEEDS TO BE A SEPERATE COLUMN.
Total Estimated Risk of Guarantor Support Needed on Contingent Liabilities (from column 6 of CONLB worksheet) Cash & EquivalentsPublic EquitiesDomestic Stocks - unrestricted, diversifiedDomestic & International Stocks - unrestricted, concentratedDomestic Stocks - Rule 144 (liquid portion)International Stocks, diversifiedExecutive Stock Options - vestedREITsFixed Income:Government & Municipal ObligationsDomestic Corporate BondsConvertible BondsInternational Bonds/Domestic High Yield BondsInvestment Accounts with No DetailOther Liquidity (liquid portion of Hedge Funds/Alternative Investments)Total Liquid AssetsTotal Liquid Assets (Scorecard definition)Encumbered LiquidityIntermediate/Alternative Investments:Restricted/Illiquid Public SecuritiesRule 144 shares not considered liquidREIT Operating Partnership (OP) unitsHedge Funds (illiquid portion)Private Equity FundsClosely Held Companies/Privately Held Sec.Receivables:Notes & MortgagesAccounts ReceivableReal Estate:Personal Residence - Primary residencePersonal Residence(s) - non-primaryResidential Lot(s)Other 100% Owned Real Estate:Recreational Real Estate/LandIncome Producing PropertiesEquity in RE Ptnrshps and/or partially owned REEquity in Partnerships (Excluding Real Estate)Cash Value of Ins. & AnnuitiesRetirement Plans, Deferred Comp., IRAsPersonal PropertyOther AssetsFine Art or Farm EquipmentYachts, AircraftLess: Est. Taxes Payable on Unrealized Asset AppreciationTotal AssetsTotal Assets (Scorecard definition)Credit CardsInstallment AccountsOther Accounts PayableNotes Payable to BankUnsecuredSecured (Non-R/E)Other Notes PayableTo Related Parties (Non-R/E)Other (Non-R/E)Real Estate LiabilitiesMortgages on Primary ResidenceMortgages on Non-primary Residence(s)Mortgages on Residential Lot(s)Morts./Notes secured by other 100% owned R/EMorts. on Recreational Real Estate/LandIncome Producing PropertiesNotes Due to R/E Partnership/CorpsOther Direct R/E DebtTaxes PayableIncome TaxesMargin Acct / Due to BrokersLoans against Insurance / other PoliciesOther Direct LiabilitiesTotal LiabilitiesTotal Liabilities (Scorecard definition)STATED NET WORTH:Contingent Liabilities (not to be used, use RAV version)Name of Borrower:Preparation Date (for the entire spread workbook)Financial Statement Date (corresponding date for each year of financial data)Actual YearSalariesBonusesDividendsInterestRecurring Real Estate Inflows:Net Rents-NOIR/E Partnership DistributionsOther Recurring - NOIOther Partnership DistributionsOther (incl. Bus. Income, Trust Income)Other (incl. Retirement income/annuities)Other (verifiable income to be generated from asset purchased w/loan proceeds)Recurring Cash Sources SUBTOTALRecurring Cash Sources (Scorecard definition)R/E Taxes for non-income prop.Planned Investments, PartnershipContributions & Capital CallsEstimated Living ExpensesFederal Income TaxesState Income TaxesOtherRecurring Cash Uses SUBTOTALRecurring Cash Uses (Scorecard definition)CASH FL. AVAIL. FOR DEBT SERV.Subject Request debt (based on actual maturity)Subject Request debtBank of America- revolving debtBank of America- term debtResidential Mortgage debtNon-BoA debtOther CBI debtSched. Cont. Liab. Pymts.DEBT SERVICE SUBTOTALDebt Service (Scorecard definition)SUBTOTAL - RECURRING USES + DEBT SERVICENET RECURRING CASH FLOWDEBT SERVICE COVERAGEReal Estate SalesNew Real Estate InvestmentSale of Mkt. Sec.Purchase of Mkt. Sec.Other purch. & capital outlaysOtherNON-RECURRING SOURCES (USES) SUBTOTALNET CASH FLOW BEFORE FINANCING ACTIVITIESReal Estate FinancingMargin FinancingHomestead FinancingDiscretionary Debt PaymentsContingent Liability PaymentsOtherFINANCING SOURCES (USES) SUBTOTALNET CASH FLOW (DEFICIT)Scorecard Federal TaxesScorecard State Taxes
PCF F79 FSC H80 M SU$1,207.98583.650000000000001996.17702579.8272579.82700000056341400000525025000000041253200624151001770000000000005204.342000000000000000005204.3425204.34284705.499081.883Mark E Salzberg5/7/20142/25/2014Various1254.23802.44252.00400006236.68813.779007559.1517559.15164.76400801.4852267.7455.203139.1943139.1944419.9570020900032.412168.304409.716409.7163548.914010.24110.787862720002170.379-260.8382181.5416191.78200000006191.782392.60525.2
PCF F79 FSC H80 M SU$0.0075000000000000080001550155000000000000025000000040000001507505000000010000003000000400000002500000000069006900250500Klentner Family Trust7/24/20128/12/2012Various99.5031.881066.37900013.700184.46184.46000177.31431.9416.1740185.4293185.4293-0.969250064.920364.9017.760447.58447.58633.0093-448.549-0.0021700180.288-152.2770028.011-420.5380000000-420.5381.9416.174
PCF F79 FSC H80 M SU$0.006303.13502413.2510118479.60000000000127196127196000000000000400000034000000000350080001613050-5000-5000-500000000580000000140000011583.2000002004300000126783.2126783.2242217.81788.8Adam Lindemann1/31/20149/30/2013Various001496.179152.33800000402.082002050.5992050.5990001027.1980.99196.44701204.6281204.628845.97120260028000907.57200117.58536425.1576425.1577629.785-5579.190.1316650015905.85-4997.3303612.9114521.428942.23800000008942.23880.99196.447
PCF F79 FSC H80 M $0.003187.62802675.9070201713.3000000005.750207582.6207582.600000000000045000003550000000017000100001750000000000001279660000140000011383.16000000000153349.2153349.2336733.41684.8Adam Lindemann9/23/20146/30/2014Various001496.179152.33800000402.082002050.5992050.5990001021.26180.99196.44701198.6991198.699851.90028002600904.83600116.61476421.4516421.4517620.15-5569.550.1326650015905.85-4997.3303612.9114521.428951.87300000008951.87380.99196.447

<tbody>
</tbody>
 
Last edited:

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Please turn off CAPS LOCK or take your finger off SHIFT when typing. Otherwise your are SHOUTING which tends to upset people.

Admonition over, you haven't said where the data is to go or where the files are located. From the first sheet you want the values of 3 discontiguous cells; from the second sheet you want 71 rows; and from the third sheet you want 70 rows. How does that relate to the sample data that you posted?

To be honest I think your request is too much to ask of this Forum. You either need to get on and do it manually or hire a consultant.
 

Forum statistics

Threads
1,141,816
Messages
5,708,752
Members
421,588
Latest member
Wawie

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top