word

  1. H

    Automatically Alphabetize Names

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

    Search, find, highlight cell - cells are hyperlinks

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

    Run formula if text is found in a cell.

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

    Saving a Word Document from Excel

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

    Help modifying VBA code

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

    Excel-Word linked

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

    If Cell value is equal to, copy data from cells to other workbook

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

    Loop through Folder for PDF Files - Open PDF in Word and extract text into Excel

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

    picture hide the text behind

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

    Automating "Find"

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

    Extracting a location from a meeting - VBA

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

    How to count in a column

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

    .contect.find not keeping the format

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

    Integrating Excel and Word

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

    Formula to highlight duplicate but ignore text/word

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

    VBA run 3 different macros based on 3 different conditions

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

    Linking two worksheets in word

    This is probably an easy one but, I have two excel 2003 worksheets in a single Microsoft Word doc.. Is there a way I can link them? Or at least a sum on one page to another? What I have is a long spreadsheet that I wish I could fit on one sheet but it is way to long. I had to put the information...
  18. D

    Count If Formula Help

    Hello, I have a range of cells (J7:J38) that the user will type text into. I'd like to know the best way to count the cells that share the same input. For instance, let's say that the user types in "dog" in 17 cells, the word "cat" in 7 cells, the word "squirrel" in 10 cells, and "hippo" in the...
  19. S

    RunTime Error 462 while converting word docx to PDF

    '******* EmpFolder is a Global Variable containing Folder Path ************************* Sub BatchConvertDocxToPDF() Dim objDoc1 As Document Dim strFile As String, strFolder As String 'Initialization strFolder = EmpFolder & "" strFile = Dir(strFolder & "*.docx", vbNormal)...
  20. M

    COUNTIF Exclusion Logic

    I use the following formula in column M to find duplicate values in column L =COUNTIF(L:L, L2)>1 The formula works correctly with returning values of TRUE or FALSE I would like to add an exception to this formula. I would like a value of FALSE to be returned when the word "offline" is found...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top