update cells

  1. M

    Find dates and delete text VBA

    Hi gurus, I am looking for a VBA solution to check a cell which contains several updates and only keep the latest update, each update has its updated date and time. See the example below: <tbody> M 2 2018-05-18 01:02:09 - K (Work notes) As per suggestion, implemented the fix. No...
  2. R

    Finding last used cell in a Range and ADD form values into the Worksheet

    Hello guys, Need some help here. I have a form and I need my code to update the form values into a specific range (M55:Q65) in my worksheet. <tbody> Rno M N O P 52 End of Booking Data 53 54 55 eDM Name Tot sends Uniq OR Uniq CTR 56 Need the data to updated 4rm this line...
  3. R

    Updating Current Row from ComboBox

    I have a UserForm that pulls values into a combo box from a dynamic range. On some sheets, I want to add data from the UserForm, to the last row. I can do that. I'm struggling to update the row that has the same value as what was selected in the combo box. I've looked around and I found this...
  4. T

    Find/Copy/Paste Issue

    I am brand new to anything to do with Excel programming via VBA. My issue sounds simple but I don't know how to fix it. It is for my job and I feel there is an easier way to do this. I have a workbook that has 177,000 records. The example below doesn't show all the columns on the original and...
  5. H

    Need a formula to update info by date but also maintain old info by date

    Greetings everyone, I'm trying to write a formula to check for new data added each day with certain criteria. One worksheet has data added to it, and the other worksheet runs the calculations. So Worksheet 1 will have x number of lines of new data added to the top of the list, and each new...
  6. M

    Update Data in Listobject

    Dear Experts What is the most elegant method to update data in a listobject (with a userform)? This is the table tblCustomers: <tbody> ID Name Street Postal Code Phone Mobile </tbody> The userform frmCustomer has: txtName , txtStreet, txtPostalCode, txtPhone, txtMobile Is this the...
  7. H

    Referencing a list throughout multiple sheets that automatically updates

    I am working on a project as a contractor, and I am having a somewhat interesting problem. The company sells chemical products and I was instructed to have one page where the products are listed and can be updated throughout the document. I was also instructed to use type selective drop-down...
  8. C

    Find All Matches Update Missing Info

    I have to enter in manually the dates for E-H and update the matching vins manually. I have been trying to create a macro that would find all matching VIN's in column B and then fill in missing dates from E-H that have already been entered. I keep running into issues with the code I have been...
  9. J

    Fill Handle of VBA functions

    Hi there, I wrote a vba function, which works fine. I want it to be applied at each row all the way down an entire column. I typed the formula into the top cell and I clicked the little box to drag it all the way down to the last row, which drags the formula down but doesn't update the...
  10. S

    Update a cell from comparing cells in a list

    I have three columns; Column A, B and C. 1. Column A. This is a blank column that compares what is entered into Column B to a list of filled in cells in Column C. If it finds a match, it puts a Y. If it does not find a match it puts an N. 2. Column B. This is where a user enters data or...
  11. M

    Forced formatting of input data

    I have a sheet that routinely has data pasted into it. Sometimes the data that is pasted in has a 13.5 pt. MS Sans Serif font. I want everything on the sheet to look uniform so I would like any text placed in the sheet to instantly convert to a 12 pt. Comic Sans font. I would think the easiest...
  12. J

    Setting the same cell on multiple worksheets

    I am creating a 3D worksheet and need to set the same cell on multiple worksheets at the same time. As a user enters text in a cell, say ("C4") on one worksheet, the same cell ("C4") on several other worksheets are updated with the user's input. Does anyone know how to do this? Thanks in...

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