contents

  1. B

    clear contents in one column based on text in another column

    Hi, If someone could help me? I'm looking for vba code to clear the contents of a cell in column A if the cell in column D has specific text. ie If column D contains "Sample" then clear the contents of column A.
  2. T

    Populating List boxes

    Hi all, I have two list boxes and I want to fill one list box with the contents where the contents contain a unique ID from the other list box. Example list box1 contains ShopID and Shop Name and second list box would be populated with the ShopID and more details from the data in the...
  3. I

    macro to search for a file name, open it and copy contents.

    I would like to run a macro that would allow me to enter 'text' to search for in the title of the file I would like to open. (this file would be in the following location) : C:\FileServer\Admin1\Glen\101-061-909\invoices i would like to be able to enter "1210912" and have it open file...
  4. P

    Print contents of a cell in Header

    Hi all I'm still having difficulty finding out how (if) I can have the contents of one particular cell, ie C3 on each sheet, printed in a Header, alongside the Sheet Name. I would like to be able to type in the year the spreadsheet applies to, ie 2019 for this year, and then when the worksheet...
  5. kelly mort

    Clear contents from the "Excel Folder" in the drive C

    Hello Geniuses, How do I locate and clear the contents of the "Excel Folder" located under the "AppData" folder? I mean with a vba code. Thanks
  6. K

    Pull text between 2 characters in cell

    Hi All, I'm sure someone has asked a similar question before, but tbh, I really wanted to get a direct answer to my specific question, so I don't have to spend time figuring out how to retrofit another answer. :P I would like to pull out the contents from the middle of a cell between two...
  7. F

    VBA-code to move master sheet/source data (# of rows change often) based on one column to predefined tabs

    I get an excel file each month that needs to be sorted by location, then subtotaled. It has 11 different locations. Each location's file contents must be sent separately in an email to various recipients. I have been spending a lot of time copying each subtotaled section to a new tab sheet and...
  8. T

    Formula to display the contents of the first filtered cell

    Hello kings i want A Formula to display the contents of the first filtered cell Exemple like this pic
  9. D

    Word Table of Contents to Excel Spreadsheet

    Hello - I'm trying to convert a table of contents in word to go into the following table in excel via VBA. I would like the table of contents details (excluding the page #) to be one column, and the next column would include the page number for reference. If possible, I would like a unique ID...
  10. T

    Deleting Contents of Empy Cells with Macro

    Hi, I am using this Macro and it does not do exactly what I want. It deletes the contents of the cells that I highlight but not the cells that are not highlighted in a column even though all of those cells have a null value in them. I want it to go through all of the rows in a column and...
  11. S

    can a string value be created reflecting the contents of a txt file in a single string?

    I am trying to open a text file by the name of response.txt using VBA code. I don't actually want the file to open or close on the screen; but I just want the vba code to assign the string variable A with the contents of the text file. The string is not more than 20 characters. What coding...
  12. S

    Separating Cell contents in VBA Strings

    Greetings, I would like to separate values held in a cell. The cell content is produced from a web query and is of the format below: "11.00+1.00 (+10.00%)" I would like to use the leftmost '.' (period) as a reference point if necessary. I would like to set as a variable value any numbers to...
  13. P

    Searching a document for multiple criteria using VBA Macro

    Ok I have been stuck on this for a while, and hope someone can help. I have an Excel Workbook with useful data in Column A and Column K. I would like to accomplish the following using a VBA macro on Worksheet 30: Dim D04C_MMF_Count As Integer D04C_MMF_Count = 0 If the contents of a cell in...
  14. C

    Add contents of another cell to existing contents of cell

    In H2 I have =TODAY() formula. Need for that date to be added to cell in column F & active row. ADDED is the key word - I am going to be calling this macro from another, which sends email and this macro is meant to keep recording every date email is sent for this line item. Code I have so far is...
  15. T

    I used a " " in a formula to return no value and there is a value being picked up by another formula

    I am linking two files in a formula. In that formula I am using " " as the value to return if the value in the source cell is either a 0 or an error. If there is no value in the source cell that I am linking up it should return a blank space. In my destination file I am using a vlookup to...
  16. A

    Button (or drawing) to copy specific text from bottom row to next blank row? Google sheets

    Hopefully I can describe this one succinctly. I would like a generic button that will copy the contents of specific cells in the bottom row of a sheet, and paste those values into the row below (first blank row). I won't post the whole spreadsheet as it's a huge mess of formulas and whatnot...
  17. A

    Convert to contents

    If I have a string e.g. "Sheet1!$B$2", is there a Excel function that will give me the contents of that cell? Or must it be a UDF, in which case , no problem.
  18. B

    Find Duplicates based on multiple criteria

    Hi There I work at a large hospital and we have an issue with our door access system in regards to cards having duplicate doors placed on cards and this is causing some not to work. I have attached a sample which shows the cards with their contents. I need to reference each cards contents to a...
  19. E

    Adding comments automatically

    Hi, before i start to explain my problem, I'm a complete rookie when it comes to VBA, however I've got a fair amount of knowledge when it comes to formulas. I would like to know if its possible to add comments automatically, depending on the contents of the cell. For example the comment is...
    • EwEn999
    • Thread
    • authors automatically comment comments contents
    • Replies: 17
    • Forum: Excel Questions
  20. L

    Search Range of Cells, return cell contents when match

    Hi, I am trying to figure out a way to search a range of cells, and then return the cell contents of the cell that does not contain a certain word. I am referring to a formula for Column U Please let me know if any more clarification is required. Thank you, Chris

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top