w*******1
发帖数: 3 | 1 A zip file includs 10 monthly data sets and it is about 100 stocks each
month covering 5 countries. Some columns are date, sector, country, month
return ....I have import the data from text file into a workbook. Please
help with the following request:
1. How to write code that will caluculate and write out into a sheet the
sector return for each month by country. Should I generate a separate sheet
to loop through all the cells?
- New to VBA | c********g
发帖数: 54 | 2 why not sort by country and then use subtotal?
sheet
【在 w*******1 的大作中提到】
: A zip file includs 10 monthly data sets and it is about 100 stocks each
: month covering 5 countries. Some columns are date, sector, country, month
: return ....I have import the data from text file into a workbook. Please
: help with the following request:
: 1. How to write code that will caluculate and write out into a sheet the
: sector return for each month by country. Should I generate a separate sheet
: to loop through all the cells?
: - New to VBA
| p******a
发帖数: 23 | 3 You can do it in Excel Pivot table. This is more straight.
Also, you canfollow your original idea, loop through each row and create
functions to process each row. You probably need to create data structure to
hold the intemediate result, more loops are needed when you aggregate the
data by country. month and sector. Then you need to write data to a seperate
sheet, in a loop. It's doable. y'll get solid VBA experience though this
excercise. | T*C
发帖数: 14 | 4 This is a piece of cake.
How could you find this job without knowing anything about VB.
If you run into anyone in wall st, ask for help. |
|
