I have the below code which opens a word document and find words in column A and replaces it with the text in the adjacent cell in Column B. This works well.
My issue is that when it copies a date from one of the cells to word, it displays the date as a number rather than a date.
I am currently using a nested '=find(text,cell)' formula to categorise a list for example.
If the term Doctor, Surgeon, Nurse, OT is in cell containing job title then the formula will return 'Medical'.
This I have done by nesting separate find fictions for each key work with an if statement...
I am busy making an eCommerce website, I have made a csv database with all the information that I need.
The issue I am facing now, I have thousands of rtf files for each items product description that I would like to add into excel.
The contents of each rtf file should be copied into a single...
I have a workbook that will convert multiple word documents at once into PDF format. I am combining two macros I found on the web to try and get them to open a word doc, place a watermark on the doc, and then export it as a PDF. It will do this once for each file in a folder that I specify in...
I am hoping someone can help.
It seems like such an easy thing to do and I just can't find the answer anywhere.
So, I would like to search a range of cells F2:F6 (APPLICATION) for the word "Yes"
The word will be returned in multiple cells and I would like to copy the B2:B6 corresponding cell...
Good day all
I need help with a MS Word form. I've searched all over the net and followed everything I've seen (I think) and I'm still stuck.
I have a word table that I want people to fill out as a form. but I don't want the person to be able to change the forms layout. Specifically the height...
I am looking for a formula that can find a certain work and return only 10 characters to the left of that word.
OTHER INFORMATION.... FOR PO# 55222 FROM COMPANY
Left of "From Company" I want it to return the PO# 55222
Any help would be appreciated
Thank you! :)
I have two columns of data, one that has a list of bookmarks and another with corresponding data in a workbook. I need to write a macro that looks at the data column, assesses to see if it blank. If it is not blank, it needs to look at the bookmark name and put the data into the...
I need to write a formula that highlights cells that contain an error if the next cell contains the word "Venmo."
IF (AND (I3=ISERROR , J3 CONTAINS THE WORD VENMO)) then color the cell red
I know my formula is silly, but think it conveys what I am trying to do?? :-D
PS, I know...
My inexperience is showing here and I hope someone can help.
I have some VBA code in an Excel workbook that creates a Word document then copies various objects from the workbook to various associated bookmarks in the Word document.
After I have completed copying and pasting some...
I'm attempting to add conditional formatting to a sheet. The Conditional Format is based on:
1) Column A contains the word "Sales" AND Column C is < 30
2) Column A does not contain the word "Sales" AND Column C is < 90
I attempted to build out the formula, but it does not work as...
I have a VBA code that copies a seelction of cells from Excel and creates a Word table that is linked to the original document. I need to be able to insert images into the created word table. The table will allow me to do this, but each time the link to excel is refreshed the images disappear...
I'd like to highlight a row based on certain criteria.
Say for example in row 7, if C7 contains the word "checked" or its empty, and if D7 contains the word "checked" or its empty, and if E7 contains the word "checked" or its empty, then i want this row to be highlighted.
Thanks in advance!
I have a code that populate word documents then prints to pdf. The problem is I have to click SAVE for each one then the display of the PDF opens. Is there a way to automatically SAVE and also prevent the preview from coming up? Any help would be greatly appreciated. Below is the code:
I use excel spreadsheets (xls, DDE) as the database for my mail merge in word. After the upgrade to Word 2016, the excel open a new file (Book2) automatically when I open the word file. The main problem is that when the new excel file (Book 2) was opened, all the previous entered data was not...
I'm looking for some help tweaking this code. I have data in an excel sheet and a Word template. It will fill in the template but when it goes to save it pops up and I have to manually save it. I want it to save and move on to the next line. Any help would be appreciated. The code I have so...
I'm trying to count the number of times a word appears within a phrase. Each row lists an action taken by an agent (i.e. Policy: Transfer / Sellers). I'm trying to use COUNTIF to count how many of the row contain a specific word, like "Transfer" but it keeps giving the result as zero. I...
I have hundreds of word documents. I would like to extract the contents from the word documents and add them into excel with each cell in a single representing a unique word document.
For example, B1 would represent word doc 1
B2 would represent word doc 2
Hello! I will start by saying that I don't really know anything about coding or VBA...other than copying the help all of you have given me in the past to a new module and connecting that to a button.
So! I'm hoping someone here will find this ridiculously simple and be able to help me. I have...
Hello All In sheet 1 I have the following