Dear Sir,
Ref to attached excel sheet ,it’s my payment sheet I enter data into this then I import into my software, I wanted it to customized as follows.
1) If I enter data into A column then L column should write D
2) Column J should get entry no from master sheet but against vehicle no from sheet 1 column A but it should only with last 4 digit because in some cases initial no may be different but last 4 digit will remain same.
3) Once Entry # come in column J then column E should show billing and column I should show p3
Thanks.
Ref to attached excel sheet ,it’s my payment sheet I enter data into this then I import into my software, I wanted it to customized as follows.
1) If I enter data into A column then L column should write D
2) Column J should get entry no from master sheet but against vehicle no from sheet 1 column A but it should only with last 4 digit because in some cases initial no may be different but last 4 digit will remain same.
3) Once Entry # come in column J then column E should show billing and column I should show p3
Thanks.