SAMCRO2014
Board Regular
- Joined
- Sep 3, 2015
- Messages
- 160
I am trying to create a If...then....else if statement loop with a cut and paste function to another worksheet. I have one master data worksheet "CAS_PPDR" and I have a column E that has the GL category in it (Regular, BB, Overtime, Premium). Based on the information in that column, I would like to have the entire row cut and pasted to a corresponding worksheet. For example,
Regular to PPDR_Regular
BB to PPDR_BB
Overtime to PPDR_OT
Premium to PPDR_Premium
Each cut and paste must be posted in the next blank row in the corresponding worksheet.
Any ideas???
Regular to PPDR_Regular
BB to PPDR_BB
Overtime to PPDR_OT
Premium to PPDR_Premium
Each cut and paste must be posted in the next blank row in the corresponding worksheet.
Any ideas???