NeilATaylor
Board Regular
- Joined
- Aug 7, 2007
- Messages
- 185
I have got my Macro to the stage where it now presents me with two sheets of data. A kind of transaction master file (downloaded from Finance system by intended user) and a modified transaction master file, manipulated by the macro, with a TRUE/FALSE identifier. What I want the Macro to do is quite simple....
1. Lookup column header "transaction number" in modified transaction master file and return value in column C, either True or False, in last column of active sheet. Keeping in mind that column numbers will vary, and position of "transaction number" column will change between users.
2. For all rows where "transaction number" returns True (as per step above, I want the Macro to Cut and Paste these rows into a separate sheet. Can this be done using the macro?
If possible, could replies be kept as two separate macros for each step (1 & 2) above? might make it easier for me to go through them.
Cheers
Neil
1. Lookup column header "transaction number" in modified transaction master file and return value in column C, either True or False, in last column of active sheet. Keeping in mind that column numbers will vary, and position of "transaction number" column will change between users.
2. For all rows where "transaction number" returns True (as per step above, I want the Macro to Cut and Paste these rows into a separate sheet. Can this be done using the macro?
If possible, could replies be kept as two separate macros for each step (1 & 2) above? might make it easier for me to go through them.
Cheers
Neil