1. H

    VBA to copy/fill columns

    Could anyone help me out with a script to fill cells from columns of data I am not 100% sure how to describe it. Basically I need to fill column C, D, and E, by series fill down based on on trend. Then column F and G I need to fill by copying the last known value down. For example...
  2. S

    extract info from filename and fill cells

    Hello, I am trying to setup a macro that will use the filename to populate the worksheet. Our system auto creates a filename that has a QT#, then customer name, job name and random notes after that. I am looking for help to fill cell A1 with the filename (without filepath) and use that to...
  3. J

    Fill empty cells (similar to index - match)

    Hi, I'm hoping for a solution to my predicament. I have an external data sheet linked via power query - the table contains names, certifications and identification numbers. My problem is that some of the students names are missing; however, their corresponding ID number has populated in every...
  4. E

    If and Elseif with Date comparison

    Hello, Can you tell me please a formula for the following: if the date in cell A1 is earlier than the date in cell B1, fill the formula cell with zero elseif, fill the cell with a number Can you advise me please? Thanks!
  5. K

    Fill formula

    I need a script to fill a column with the formula in cell d2 until there is nothing in column a. Thnak you
  6. H

    Macro In order to fill in blanks

    Hi, I am using below code inorder the fill the blank cell with the formula,the excel sheet contain data from A to R column,and the below coding fills the all the blank cells from A to R column But I need the macro to fill the blank cell only from A to I column and ignore the rest of columns...
  7. T

    Auto fill cell color for row

    Hi all, I am trying to auto-fill cell color based on whether the value in column A is odd or even. Odd values would make the entire row (A-O) have no fill, and even values would make the entire row (A-O) have grey fill. Can anyone provide any guidance? Much appreciated. /M
  8. H

    Fill Dates

    Is there an easier way to fill column B with the month of the date in column A. This is what i am currently doing: Sheet1.Range("B3:B" & Lastrow).Formula = "=Text(A3,""MMMM"")"
  9. A

    Data validation and click button

    Hi there guys! Hope that you are all well. This is my first post on MR Excel, so if i do something wrong (not accurate, inappropriate, too dumb, etc) please just let me know in order to improve myself. My question: I have a list of cells ex C10:L10 and C20:L20 and so on, and i need to some...
  10. S

    Custom Fill Color Tool with Specific Colors and Associated Hot Keys

    Hi Everyone, Long time Excel user who recently started a new job that involves lots of formatting with various company specific colors. I want be able to insert each of the colors to various cells quickly...ideally with just a couple key strokes. Thus my thought process was to create a tool...
  11. F

    Weekdays Mon-Thurs fill series

    I have entered the following dates into cells that correspond to Monday-Thursday 9/10/18 9/11/18 9/12/18 9/13/18 I highlighted the cells and dragged to fill series so that it continues the pattern and it's not working. I want to exclude Friday, Saturday, and Sunday dates. How do I get this to...
  12. C

    Conditional Formatting

    I am trying to format cell A1 based on the value of cell B1 If A1 < B1, fill A1 in Red If A1 = B1, fill A1 in Green If A1 > B1, fill A1 in Blue I have tried using Conditional Formatting, but cannot get it to work. I also would like to apply the same for rows 2 and 3 A B 500...
  13. muhammad susanto

    Fill Series Number Based On Adjacent Cell or Column

    hi all... how to make fill series number based on adjacent column this layout : <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ; font-family: Arial, Helvetica, sans-serif; } .tableizer-table td { padding: 4px; margin: 3px; border: 1px...
  14. muhammad susanto

    Fill Series Number With Criteria

    helllo... i am looking formula to fill series number based on adjacent with basic count of data 3 cell like this : <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ; font-family: Arial, Helvetica, sans-serif; } .tableizer-table td { padding...
  15. J

    VBA, For each loop, write to another sheet.

    Hi guys, I have this code, I get invalid procedure call or argument. What am I missing here? I am trying to take the cells from MST sheet and go to another sheet. but I want to loop through each row in column K then fill in col H in my other sheet. Any help would be appreciated...
  16. T

    How to fill multifield data form other sheet?

    Hi all, I have a worksheet like this: And data worksheet like this: I want auto fill all my filed data form data worksheet in quickest way (i dont know how to use macro). I dont want just Copy and Paste because it very slow. Ex: Thanks much
  17. B

    Error handler for filtering for fill color in table

    I have tried multiple ways to write an error handler with no luck. My code adds fill color to cells that match another sheet's column. What I trying to do is if the cell fill color has no fill then select it, copy, paste to another sheet, and then go back and delete the row(s). That part works...
  18. M

    highlight different cells

    I'm trying to compare 2 (column C and column D) columns against each other. What I want to do is highlight my numbers in column D based on the amount they are over that is in column C. In my example below. If column D is 1 higher then column C how do I highlight that Red? If column D is...
  19. ironsides

    Macro needed (Fill Down)

    cells AD19:AE9999 Each cell contains a number or is blank I want to fill in the blank cells below with the the number above them e g: 686 15.22 724 3.00 390 12.80 146 27.00 Should look like 686 15.22 686 15.22 724 3.00 390 12.80 390 12.80 390 12.80 390 12.80 390 12.80 390 12.80...
  20. R

    VBA - Change fill color of row based on cell value

    I know this is done easier with conditional formatting but for this instance, i can't use a conditional formatting fill color. I have cell B11 with a drop down list option of 4 or 5 In cell range C17:C20 I need the fill color to be blue fill for 4 or C17:C21 to be blue fill for 5 (basically...

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