ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Is there a way to add monthly message to excel (https://www.excelbanter.com/excel-discussion-misc-queries/57742-there-way-add-monthly-message-excel.html)

Leta

Is there a way to add monthly message to excel
 
I am trying to design a monthly invoice that will automatically insert a
monthly holiday message according to the month.

Dave Peterson

Is there a way to add monthly message to excel
 
Add a worksheet.
Put 1 to 12 in A1:A12
put your messages in B1:B12

=vlookup(month(today()),sheet2!a:b,2,false)

to retrieve that message based on today's month.

Leta wrote:

I am trying to design a monthly invoice that will automatically insert a
monthly holiday message according to the month.


--

Dave Peterson


All times are GMT +1. The time now is 09:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com