copy formulas

  1. F

    Copying formulas that only grab particular ranges

    I found some previously solved posts that are similar to what I need, but I am having trouble making their solutions work for myself. I would really appreciate anyone's help! Here's the scenario: I have created a report that holds the grades of certain calls that have a corresponding reference...
  2. M

    Copying a formula in a column while keeping one cell a fixed value

    I'm trying to duplicate a formula from one cell to all the remaining cells below. I want one cell to remain a constant fixed value in the next cell with the formula using the adjoining cell. The adjoining cell needs to increase in the next cell with one value remaining constant. I know there...
  3. poitbot

    Copy formulas with text to new sheet

    Hey again! Really loving this place. I have a macro that extracts text from multiple worksheets and places it in a column along with the cell reference and worksheet name. I'd like to do the same thing but instead of text I'd like it to pull formulas with text only. Some of the formulas have...
  4. C

    Copy lines based on number in a column

    I am looking for a function to copy lines based on a number in column C, for example if column C has a number 2 copy this line 1 time so i have 2 same lines, if column C has a 3 copy this line 2 times so i have it 3 times, i have a worksheet with 300 lines.
  5. C

    Automatic insert / delete rows and accompanying formulas + formats

    Hello all, I have a document that I frequently use for making calculations for quotations. I always use the same formulas in each line for this document with different operations in the columns. To have an overview, I have split these enumerations into phases and subphases. To avoid errors...
  6. B

    Copy down unique date formula

    I want to copy a formula down. The data is dates between 02/01/2009 and 14/12/2009 but only want every Wednesday and Saturday. I have put in the first few and trie to copy the formula down but excel just copies the five or so I have put in and pastes that over and over again. Is what I am...
  7. C

    Copying formulas into all cells of a column Macro

    Hello Excel Gurus! Hopefully I can explain my dilemma, a bit of background: it's a supplier score monthly tracker, very basic, list of suppliers in column A then Jan scores in column B, Feb scores in column C etc etc. I've been working on Macros for arranging by score based on the last...

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