Bk5 jobs
...W12)+SUMIF(X12,"WOODLOT",Y12)+SUMIF(AD5,"WOODLOT",AE5)+SUMIF(AF5,"WOODLOT",AG5)+SUMIF(AH5,"WOODLOT",AI5)+SUMIF(AJ5,"WOODLOT",AK5)+SUMIF(AL5,"WOODLOT",AM5)+SUMIF(AN5,"WOODLOT",AO5)+SUMIF(AP5,"WOODLOT",AQ5)+SUMIF(AR5,"WOODLOT",AS5)+SUMIF(AT5,"WOODLOT",AU5)+SUMIF(AV5,"WOODLOT",AW5)+SUMIF(BB5,"WOODLOT",BC5)+SUMIF(BD5,"WOODLOT",BE5)+SUMIF(BF5,"WOODLOT",BG5)+SUMIF(BH5,"WOODLOT",BI5)+SUMIF(BJ5,"WOODLOT",BK5)+SUMIF(BL5,"WOODLOT",BM5)+SUMIF(BN5,"WOODLOT",BO5)+SUMIF(BP5,"WOODLOT",BQ5)+SUMIF(BR5,"WOODLOT",BS5)+SUMIF(BT5,"WOODLOT",BU5)+SUMIF(BZ5,"WOODLOT",CA5)+SUMIF(CB5,"...
...need for each client is in each of these BK5 files. I attach a sample backup file . We need to gain access to the data in these proprietary BK5 files and create an interface with Excel to allow us to read data from the BK5 files. We would want to be able to lookup data in client files from within Excel to populate custom reports, workpapers etc. We currently use VBA with connection strings to extract similar data from other MYOB (SQL based) products. We want to be able to : - return balance of a ledger account at a specified date - return net movement in an account for specified date range - return totals for various categories of GST based on dates Attached are BankLink reports showing type of data to extract. Excel could locate each BK5 via ...
...software (see their website - ) which stores client transactional data in a proprietary database structure with a separate .bk5 datafile for each client. All the information we need for each client is in each of these .BK5 files. I have attached a sample .BK5 file for you to have a look at. We need someone to gain access to the data in these proprietary .BK5 files and create an interface with Excel to allow us to read and write data to the BK5 files. We would want to be able to lookup data in client files from within excel to create custom reports, workpapers etc. We would also like to be able to push transactions back into the BK5 file from Excel. We want to be able to READ the following: - Return a balance of an account at a specified d...
Hi, We want to be ab...Banklink software via Microsoft Excel - so effectively we need a live data connector where Excel Spreadsheets can lookup data in the Banklink database and return transaction lines, account totals etc etc. Banklink is a piece of software and you can find details about it on their website - www.banklink.com.au. The software stores client transactional data in individual client datafiles with a *.bk5 extension - all the information we need for each client will be stored in these files. We would want to be able to lookup data in client files from within excel to create custom reports, workpapers etc. Ideally I am looking for someone who has had previous success with accessing data stored in Banklink client files. I look forward to hearing form you. ...
