Hi all, I am currently stuck on finding a way to input all new changes made to a specific row of cells into a string so that I can parse the final string into another function that drafts out an Outlook message. As there will be continuous updates made to the row, I want to be able to "write"...
I have a column in which i have a data in the following format:
Now i want to extract just names from these above strings and want to delete the %datetime. Please let me know how i can do this...
Hi all, I have a form that has three fields (1. Comments (TEXT), 2. Legacy_Comments (TEXT), 3, Comment date (DATE))
Now my users need to keep adding comments to the comment text box, and when they do it automatically adds the date they entered the comment in the Comment date box. Now my problem...
I am using the vba code below to input a formula into excel cells. However, I want to make the "A:A" and the "D3" in the formula relative to the variable c2 (which is an integer). Does anyone know how to do this?
Cells(3, 3).Offset(0, c2) = "=IF(COUNTIF(" & "A:A" & "," & "D3" &...