fwawergurl16
09-05-2007, 02:34 AM
Hi. A friend of mine needs some help with this little assignment of his. I can't exactly help him cos I've no idea how this could be done in VBA as well.
"There will be a raw data extracted, let?s say the branches of the banks. So, now whenever I import the raw data into the spreadsheet, I need to rearrange the branches so that there is no repetition of branches in the report and it will accumulate the amount of transaction per branch."
Can anyone help?
The attached files will give a better view of the initial sheet & the intended look.
"There will be a raw data extracted, let?s say the branches of the banks. So, now whenever I import the raw data into the spreadsheet, I need to rearrange the branches so that there is no repetition of branches in the report and it will accumulate the amount of transaction per branch."
Can anyone help?
The attached files will give a better view of the initial sheet & the intended look.