| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Watermark: (reference formula ie. Vlookup or IndexMatch)
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!!!!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Watermark: (reference formula ie. Vlookup or IndexMatch)
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 " wrote in message ... 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!!!!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Watermark: (reference formula ie. Vlookup or IndexMatch)
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Watermark: (reference formula ie. Vlookup or IndexMatch)
Sorry, I have no idea what you are trying to do.
A sample workbook with details would be welcome. Regards, Howard " wrote in message ... 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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Watermark: (reference formula ie. Vlookup or IndexMatch)
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Maintain Formula Reference (sort of) | Excel Worksheet Functions | |||
| Copy a relative reference formula from one sheet to another. | Excel Discussion (Misc queries) | |||
| Worksheet name / reference as a formula? | Excel Discussion (Misc queries) | |||
| Need Vlookup to work with formula in reference cell | Excel Discussion (Misc queries) | |||
Linear Mode
