RE: Altair slc appending mutiple excel ranges within one sheet
Too long to pst on listserv, see github
https://github.com/rogerjdeangelis/utl-altair-slc-appending-mutiple-excel-ranges-within-one-sheet
/community.altair.com
https://community.altair.com/discussion/5965?tab=accepted
OPS PROBLEM
I need to capture the data for each line that represents a loan. Lines 14-19 and Lines 25-31
I will need to append the Account number to each line for the account that is showing above each section.
Lines 14-19 (Append Account 123456) and Lines 25-31 (Append Account 1237890)
Spreadsheet has extra lines and blank lines in the spreadsheet and is a semi structured spreadsheet in my opinion
THREE SOLUTIONS
1 Manually create named ranges (could do this programtically)
ranges
account1
balance1
account2
balance2
2 Hardcode ranges
3 General solution 100 balances
repeated customer balances
