PDA

View Full Version : Sleeper: Spliting of data inside each sheet



everytime
08-22-2005, 07:32 AM
hi there , i have 3 different spread sheets ... i there a way to simplify the process of copying the details of each country and placing them into another sheet ??

say eg London - LoansLondon - BR
DBS LONDON BRANCH Total, all inside GP loans
extracted and placed inside GP-loans-London ??

another thing is that there will be newly added countries from time to time but the columns are fixed only the rows my change ..

royUK
08-22-2005, 10:15 AM
I think your task would be much easier if you tidied up the design of your Spreadsheet. If you collate all your data into one sheet as an Excel Database then you can use PivotTables to review data. Here's a good article on designing spreadsheets as database (http://www.ozgrid.com/forum/announcement.php?f=8)

everytime
08-23-2005, 04:31 AM
thx for the reply .. but i was assigned to extract the data .. i am not the one incharge of doing the spreadsheets ...