PDA

View Full Version : macro to Create a Output file based on Input file



shan
11-27-2015, 09:22 AM
Hello Everybody,

Request you assistance to create a Output file based out of Input file.

Data is attached for your reference.


Thank You


Regards,
Shan

SamT
11-27-2015, 10:31 AM
Do you want help to learn how to write this program, OR, do you want someone to perform all the work for you?

About:


OW/RT
If FB (RT) then RT and IF FB (OW) the OO else Blank


Ftnt
If FB (RT) then RT and IF FB (OW) the OO else Blank


RtgNo
If FB (RT) then RT and IF FB (OW) the OO else Blank


RuleNo
If FB (RT) then RT and IF FB (OW) the OO else Blank


How can they be Blank?

Attachment herein is color coded for correspondences

shan
11-27-2015, 11:41 AM
Thank you for your reply.
Sir.. I would like to have the macro by which I can perform the task.

its my mistake fltno, rtgno and rule no will always be only blank there is no condition...

you are correct OW/RT will not be blank..

Thank You