excelmacro
Board Regular
- Joined
- Apr 8, 2002
- Messages
- 50
I want to create a macro that first searches through an excel file containing raw data ("monthly"), and then automatically load certain parts of the data into another excel file ("information").
The raw data file ("monthly") has three columns that I am concerned with, column A (cost center) , D (prime) , and F (cost).
The file information has only one cost center in it (whereas monthly has many), but many primes (usually more than monthly). The reason for this is that primes in raw data (monthly) aren't present for certain cost centers if there is no cost for the prime (a little confusing but no cost= no prime for that cost center).
The primes in information are in column A, and the costs are in monthly columns.
The raw data (monthly) varies in length from month to month due to there being no cost for that prime in that month.
So i guess what i am looking for is a macro that will ask the user for the cost center they are looking for, then which coumn they want the information to be inserted into (ie which month the data is for), and then use the user inputted cost center to find the corresponding cost center in raw data column A, match the primes in raw data column D and information column A (for that cost center), and then copy the raw data column F (cost) for the for that prime into the information column that the user specifies.
I realize this is a lot to help with, but if you can help with one part, I would appreciate it.
The raw data file ("monthly") has three columns that I am concerned with, column A (cost center) , D (prime) , and F (cost).
The file information has only one cost center in it (whereas monthly has many), but many primes (usually more than monthly). The reason for this is that primes in raw data (monthly) aren't present for certain cost centers if there is no cost for the prime (a little confusing but no cost= no prime for that cost center).
The primes in information are in column A, and the costs are in monthly columns.
The raw data (monthly) varies in length from month to month due to there being no cost for that prime in that month.
So i guess what i am looking for is a macro that will ask the user for the cost center they are looking for, then which coumn they want the information to be inserted into (ie which month the data is for), and then use the user inputted cost center to find the corresponding cost center in raw data column A, match the primes in raw data column D and information column A (for that cost center), and then copy the raw data column F (cost) for the for that prime into the information column that the user specifies.
I realize this is a lot to help with, but if you can help with one part, I would appreciate it.