Watermark: (reference formula ie. Vlookup or IndexMatch)

[Qull666]

Good Day,

Its like this, when a certain document is paid in the post office or any
other agencies or like in the movies, the person attending the matter would
stamp PAID (with the date, cheque number or other information).

I have seen Ron De Bruin's watermark stuff. There is a box switch to trigger
the watermark. If the trigger can be shifted in another way.

I have this little status boxes that shows item 1-3 below, but lets go bold,
THE WATERMARK!!!!..

I have 3 requirements that triggers and change the wording of the watermark.

1. Paid - Cheque Number - Date - etc.....
2. Waiting for Official Receipt
3. No Watermark (Not Paid) or NOT PAID in watermark.

(Vlookup is there, Index Match, If stuff are also used)

This is for on-screen graphical and printing

Holler: THANKS FOR THE HELP!!!!!

 

[L. Howard Kittle]

I'm vague on what you want to achieve. Could you provide more info on what
you want to happen on the sheet and when.

I would be glad to take a look at a sample workbook.

Regards,
Howard

 

[Qull666]

Dear Howard, thank you for responding.

I will make briefs of it.

Its like a VLookup thing, but the watermark will be stamped on the CP-37 tax
return form (Sheet 2) when it is paid.

Sequence:
1. 2 worksheets (Database & Form CP-37)
2. Enter Payment Data in Database (sheet1).
3. Print the Form in CP-37 (sheet2).
4. -----Waiting for official receipt--2 days transit time---
5. When the receipt is received, enter payment data in database (sheet1).
6. Form in CP-37 (sheet2) stamped paid (watermark).


Current:

1. When the receipt is received, I have a cell that states the receipt
information.
Here is the formula:

=IF(VLOOKUP(I14,Dbase!D:L,9,FALSE)=0,"",IF(ISERROR(CONCATENATE(VLOOKUP(I14,Dbase!D:L,8,FALSE),"
/ ",TEXT(VLOOKUP(I14,Dbase!D:L,9,FALSE),"dd-mmm-yy"))),"",CONCATENATE("IRB
Receipt: ",VLOOKUP(I14,Dbase!D:L,8,FALSE)," /
",TEXT(VLOOKUP(I14,Dbase!D:L,9,FALSE),"dd-mmm-yy"))))

Interpretation of the formula:
1. If VLookup returns value, IRS receipt date = 0, then [blank]
2. If not 0, then it will return 2 values, Receipt No. & Receipt Date. {Font
in RED}

This way, at one glance I will know if the Tax Payment has been made or not.

The watermark will incorporate this formula as the trigger point.

Content in CP-37:

1. Cheque Number (Key Field)
2. Enter cheque number and VLookup and other formulas would use this reference


I am just venturing to see if it can be done. For graphical purposes only.

Once again, thank you Howard.

 

[L. Howard Kittle]

Sorry, I have no idea what you are trying to do.

A sample workbook with details would be welcome.

Regards,
Howard

 

[Qull666]

Dear Howard, I will forward a copy of the template, but I need a confirmation
of your email address.

(e-mail address removed)

Thanks for the help.

Sorry, I have no idea what you are trying to do.

A sample workbook with details would be welcome.

Regards,
Howard

Dear Howard, thank you for responding.

I will make briefs of it.

Its like a VLookup thing, but the watermark will be stamped on the CP-37
tax
return form (Sheet 2) when it is paid.

Sequence:
1. 2 worksheets (Database & Form CP-37)
2. Enter Payment Data in Database (sheet1).
3. Print the Form in CP-37 (sheet2).
4. -----Waiting for official receipt--2 days transit time---
5. When the receipt is received, enter payment data in database (sheet1).
6. Form in CP-37 (sheet2) stamped paid (watermark).


Current:

1. When the receipt is received, I have a cell that states the receipt
information.
Here is the formula:

=IF(VLOOKUP(I14,Dbase!D:L,9,FALSE)=0,"",IF(ISERROR(CONCATENATE(VLOOKUP(I14,Dbase!D:L,8,FALSE),"
/ ",TEXT(VLOOKUP(I14,Dbase!D:L,9,FALSE),"dd-mmm-yy"))),"",CONCATENATE("IRB
Receipt: ",VLOOKUP(I14,Dbase!D:L,8,FALSE)," /
",TEXT(VLOOKUP(I14,Dbase!D:L,9,FALSE),"dd-mmm-yy"))))

Interpretation of the formula:
1. If VLookup returns value, IRS receipt date = 0, then [blank]
2. If not 0, then it will return 2 values, Receipt No. & Receipt Date.
{Font
in RED}

This way, at one glance I will know if the Tax Payment has been made or
not.

The watermark will incorporate this formula as the trigger point.

Content in CP-37:

1. Cheque Number (Key Field)
2. Enter cheque number and VLookup and other formulas would use this
reference


I am just venturing to see if it can be done. For graphical purposes only.

Once again, thank you Howard.

 

[L. Howard Kittle]

Yes, that is it. (e-mail address removed)

Dear Howard, I will forward a copy of the template, but I need a
confirmation
of your email address.

(e-mail address removed)

Thanks for the help.

Sorry, I have no idea what you are trying to do.

A sample workbook with details would be welcome.

Regards,
Howard

in
message news:[email protected]...

Dear Howard, thank you for responding.

I will make briefs of it.

Its like a VLookup thing, but the watermark will be stamped on the
CP-37
tax
return form (Sheet 2) when it is paid.

Sequence:
1. 2 worksheets (Database & Form CP-37)
2. Enter Payment Data in Database (sheet1).
3. Print the Form in CP-37 (sheet2).
4. -----Waiting for official receipt--2 days transit time---
5. When the receipt is received, enter payment data in database
(sheet1).
6. Form in CP-37 (sheet2) stamped paid (watermark).


Current:

1. When the receipt is received, I have a cell that states the receipt
information.
Here is the formula:

=IF(VLOOKUP(I14,Dbase!D:L,9,FALSE)=0,"",IF(ISERROR(CONCATENATE(VLOOKUP(I14,Dbase!D:L,8,FALSE),"
/
",TEXT(VLOOKUP(I14,Dbase!D:L,9,FALSE),"dd-mmm-yy"))),"",CONCATENATE("IRB
Receipt: ",VLOOKUP(I14,Dbase!D:L,8,FALSE)," /
",TEXT(VLOOKUP(I14,Dbase!D:L,9,FALSE),"dd-mmm-yy"))))

Interpretation of the formula:
1. If VLookup returns value, IRS receipt date = 0, then [blank]
2. If not 0, then it will return 2 values, Receipt No. & Receipt Date.
{Font
in RED}

This way, at one glance I will know if the Tax Payment has been made or
not.

The watermark will incorporate this formula as the trigger point.

Content in CP-37:

1. Cheque Number (Key Field)
2. Enter cheque number and VLookup and other formulas would use this
reference


I am just venturing to see if it can be done. For graphical purposes
only.

Once again, thank you Howard.