hi guys, Let me say these two things - Firstly, let me tell you that I did searched and what I found can't really help me . So please indulge me with a little patience, and I really apologize if I overlooked a previous thread that could have given the answer to this; and secondly, this a longer than normal post, so please if you really want to help, please bear with me, and do not hesitate to ask me for more details:
Every quarter I carry on this excercise:
I have 12 workbooks named: Private Banking.xls, Placencia.xls, North Side.xls, Punta Gorda.xls, San Ignacio.xls, Corozal.xls, Orange Walk.xls, San Pedro.xls, Belmopan.xls, Free Zone.xls, Dangriga.xls, Belize City.xls.
[The are on this location: G:\Accounts\BBL\District Budgets
Each Worksheet, has (standard to all sheets) the following sheets: consumer, demand, mtge, npl, odrft, stfln, usdemln, usodrft, usvisa, bzvisa, demdep, fgndemdep, sav, bztd, ustd.
On each sheet I have the following info:
Example of Belize City.xls, tab [consumer)
\1
The info on B10:B21 and D10:D21 I need to insert on this other workbook: SC2 Apr09 - Mar 10 Actuals.XLS [on this location: Q:\5yr Branch review\Balance Sheet]
\1
This workbook has (including others) 12 worksheets for each file above, i.e. a tab called bze for Belize City.xls, a tab called czl for Corozal.xls, a tab called cfz for Free Zone.xls, and so forth....
Info from Consumer tab from Belize City.xls goes on the bze tab on SC2 Apr09 - Mar 10 Actuals.XLS, like this:
April May June
SC2 Apr09 - Mar 10 Actuals.XLS B22 D22 B22 D22 B22 D22
The info required from this sheets come respectively from:
Belize City.xls [consumer tab] B10 D10 B11 D11 B12 D 12
And I have to do this for every line item on SC2 Apr09 - Mar 10 Actuals.XLS from row 20:32 for all 12 tabs pulling info from the other individual 12 files. So to put everything into a general perspective: The 12 individual files (Private Banking.xls, Placencia.xls, North Side.xls, etc.) represent, the 12 different tabs on the other file (SC2 Apr09 - Mar 10 Actuals.XLS), and the different tabs on each workbooks ((Private Banking.xls, Placencia.xls, North Side.xls, etc.), represent line items from row 19:32...
Any suggestion guys, this is pretty tedious as I have to do it [currently] every quarter, but the boss, has plans to turn this into a monthly exercise.
The 12 individual worksheets (Belize City.xls, Corozal.xls, etc) get updated quarterly.
I would really appreciate whatever you can do to minimize the time I have to spend on putting this info to these worksheets guys. I think the best we can do is formulas; but you may know better.
Thank you
Ron
Bookmarks