copying cells

  1. B

    Difficulty Copying IF Function

    Hello, I am struggling with my IF function as it is copying down but the formula turns grey and does not adjust for the row it is moving down. Essentially, I am looking to calculate the time to fill which was originally done by using the DatedIf function containing job posing date and the...
  2. K

    VBA - copy cell if it is not empty

    Hi everyone, I have the following problem: I have a small table with 2 columns (E and F): I want to copy all values from column F into column E but only if there is a value in column F. I cannot use the "normal" copy function as that would copy empty cells. There are values in column E that are...
  3. J

    Copying 2 different cell values into formula using VBA

    Hello team, I'm a newbie at macros, and cannot seem to get what I need... I have sheet 1 with a huge list of client data: accounts (Column D), product names (Column C), amounts (Column E). What I am aiming is to create a macro that would copy data from cells located in Columns C, D and E...
  4. S

    Partial Matching and copying over a separate column when a match is found

    Hello. I have two columns I and J that have some model numbers in them. Model J has model numbers that are longer than those in column I. I want to have another column F that looks at I2 and searches column J for a partial match (7 characters) and once it finds one, it copies the date from...
  5. C

    VBA Code to copy formula from above row, already have macro to add row

    Hi, My macro inserts a row but I am finding that not all of the formulas are on the new row. The line above and below the inserted line have the formulas in the cells. The data validation cells in the new row work fine with the current macro, it is only my sumif formulas that do not appear to...
  6. L

    Copying a finite cell (not finite cell psotition) as it moves around after various "sorts".

    How can I copy the cell value in a cell (for example a value that may change from time to time as it is dependent on other data) to another cell, where the cells exist on different rows and rows that I will be sorting regularly in different ways? (so the target cell and reference cell are both...
    • Legacy 274910
    • Thread
    • copying cells moving cells sorting
    • Replies: 10
    • Forum: Excel Questions
  7. H

    Fill A cell with the last entered value in the column.

    -- removed inline image --- I have to enter the next value in column D to the cell D1 e.g. if the next value entered is 1000 in D4 then the value in cell D1 should be 1000 again if the next value entered is 23 in D5 then the value in cell D1 should be 23 Thanks in advance for anyone that helps

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