word

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...

Hi all, 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 .... ... . B897 would...

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 <tbody> HELPER 2 FIRST NAME HELPER 1 LAST NAME LAST, FIRST 1 BILLY 6 SMITH SMITH, BILLY 8 ZEE 7 WORD WORD, TONY 7 WILL 2 HAYES HAYES, WILL 3 PAUL 3 MORRIS MORRIS, PAUL 6 TAMMY 7 WORD WORD, ZEE 5 TIM 4 PARKER PARKER, TIM 2 JACK 5 PRICE...

Hi All I'm in need of some help - i'm trying to use conditional formatting to highlight individual cell when a word is typed. So if i start to type the word google - the cell containing the word google highlights red with a yellow font. So if i type g or goo the cell containing the word...

Good day all I'm trying to add a clause to a formula. What I want is to check cell L2 and only if it finds the word "open" then run the following formula. Any help is greatly appreciated. TIA =IF(ISNUMBER(SEARCH("Not used",E2)),"",IF(TODAY()=E2,"Today",IF(TODAY()>E2,"Past...

Hello All, I am hoping someone can help me with a problem I have been surfing the forums trying to find a solution to for a few hours now. I have an Excel macro file which will be stored in our company's SharePoint which will be used to track contracts being created and also serve a process...

I'm using the code below which works great provided the word "Remove" is somewhere on the sheet in column F. However, when the code runs on a worksheet where the word "Remove" is not present it removes the first row of the worksheet which is the column headings and also removes my alternate row...

When I run spreadsheets I create tables and charts in them. I format them as desired, then cut/paste them into a Word document. But I have found that the Word document and Excel file are "linked," which I don't want. The last time I copied the Word doc onto a usb driver to work at from home...

Hello, I'm setting up a macro for a button on a worksheet, worksheet 1 in workbook X. What I would like when this button is clicked, is to check all cells in column A for the word "Copy" Next step is that if this word is found, another workbook, Y, is opend. Finally if the word "Copy" was...

Hello, I am using the code below in Excel to open a PDF File in Word andextract the data as text only into Excel. The code works perfectly fine as itis, however, I want to loop through all pdf files within the folder instead ofhardcoding the filename in pathAndFileName variable. My goal is...

Hi I inserted a picture in a sheet. I moved the picture over a table. After that I can not see the contents of some cells. Can I put the picture in the background and move the text in front, like in Word? Thank you very much

Does anyone have a suggestion on how I could create a situation where clicking on a particular word in a cell initiates a Find for that word? I have a list of customers and it would be helpful to be able to click on a particular customer and then see all the other locations in my workbook that...

Hi, I am not sure if this is possible, but I have a macro that is building onboarding schedules in Word and filling in details based on an excel spreadsheet. The current problem I am having is that the locations of the meetings do change every couple of weeks. These locations are in Outlook...

Hello, I have a column that has different words. I need to find out how many of each word is in that column. For example, there might be 50 of the word banana, 7 of the word apple, 23 of the word orange, etc. What is an easy way to figure this or formula to use, I have over 150 cells to check. I...

Hi all, I have created the below loop and find and replaces instances in word. I have created an excel spread sheet and some of the data that's being replaced is currently formatted as currency in excel. The find and replace feature works perfectly and replaces everything correctly. The only...

Hello there, I hope this finds you all well. I'm back again, and I was hoping for some advice. As part of my work, I produce reports in Microsoft Word. Maybe about 30 pages long, largely the same text information, with an amount of financial information pulled across from a default...

Hi, I have the following formula which almost does what I want it to. =SUMPRODUCT(COUNTIF(B8:DG22,B8:DG22)-1)>0 However, in the range B8:DG22, which is made up of 5-digit numbers and the word "Blank", I want it to tell me if there's any duplicate entries in the range but ignore the word...

Hello, Is there a VBA code that can select a workbook and run different macros on condition? For example: If sheet 1, cell: A15 says the word "Blue" Go to Sheet 3 run macro for blue Or If sheet 1, cell 15 says the word "Red" Go to Sheet 2 run macro for red Or if Sheet 1, cell A15 says...