Hello. I have created a macro to send an email with data from a worksheet. It works fine as plain text but I would like to format (ie bold) the dollar value in (I40) and date value in (I21) which means I need to convert it to HTML. Everything I've tried has failed. Can you please help? This is...
Hi
I have a workbook where Sheet 2 is the data source containing all employee information and Sheet 1 displays one individual's information at a time using vlookup to pull in the data.
I want to create a macro button that will write today's date into the 'Date' field in the data source (Sheet2)...
I want to create a form that when the user inputs a Start Date and End Date, excel can look up a table of dates and alert the user if one of the dates in the table falls within the user's range of dates.
Is this possible?
Many thanks
Maggie