zenkei2007
New Member
- Joined
- Jun 20, 2010
- Messages
- 4
Okay, basically I have an expense report that has a column heading of dates, and it breaks down each line of business i need to grab expenses for by these days and also by certain work codes.
I need to grab a specific line of expenses based on the work code and line of business by row
so ie
3/16 3/17 3/18 3/19
LOB Work code 1 9 33 55 66
LOB Work code 2 7 5 95 34
LOB 2 Work code 1 etc etc
It needs to paste into another document on a line where I know it will have to go based on the work code but it has to go under the corresponding date column. I will have to paste these rows using special values.
I initially tried to do an index match loop through cell by cell but it is extremely slow operating and not complete yet so now I am investigating ways to just copy the row and paste in the corresponding known location. The expense report is not consistent so it will need to have some way to find a beginning and end date and then some way to copy the row that intersects with that date from that particular point with the corresponding lob and work code needed.
any input is greatly appreciated, this isnt a design the whole thing for me if you could just point me in the direction of recommended methods or even moderate pseudocode id be extremely grateful. invested lots of hrs into it so far.
I need to grab a specific line of expenses based on the work code and line of business by row
so ie
3/16 3/17 3/18 3/19
LOB Work code 1 9 33 55 66
LOB Work code 2 7 5 95 34
LOB 2 Work code 1 etc etc
It needs to paste into another document on a line where I know it will have to go based on the work code but it has to go under the corresponding date column. I will have to paste these rows using special values.
I initially tried to do an index match loop through cell by cell but it is extremely slow operating and not complete yet so now I am investigating ways to just copy the row and paste in the corresponding known location. The expense report is not consistent so it will need to have some way to find a beginning and end date and then some way to copy the row that intersects with that date from that particular point with the corresponding lob and work code needed.
any input is greatly appreciated, this isnt a design the whole thing for me if you could just point me in the direction of recommended methods or even moderate pseudocode id be extremely grateful. invested lots of hrs into it so far.
