fill formula

  1. C

    Use FormulaR1C1 to populate formula if cell contains specified value

    Hello, I need help with inserting a multiplication formula that is using two cell values in the formula IF another cell contains a specific value. If cell G1 = "1", then I want to insert a formula in cell H1 as follows G1*D1, and so on throughout the table of data. The table of data will...
  2. L

    VBA Insert row - keeping clacs and reference numbers in order

    Hi All I have been looking/trying various bits of code to insert a row on a large protected sheet. I have also been recoring various stages, but cant get the result I am after and think I might be overcomplicating metters. Large Excel sheet with A:Z and 1-100 hidden, full of calculations. The...
  3. M

    VBA help - Fill down with changing start and end cells

    Any help is much appreciated, I am learning VBA on the go and cannot seem to work through this issue. Thanks! Example Below: Column A Column B Portfolio 1: AAPL DIS YHOO Portfolio 2: AAPL FORMULA (=A7&" US Equity") FB TWTR XOM Portfolio 3: COP KO WMT I am...
  4. E

    Filling Series for Referenced Workbooks

    Hey people, I need help filling a series based on a referenced workbook. Here is my formula: =[CIF9000.xls]Sheet1!$A$1 I want to be able to fill down a series that only increments my referenced workbook. So, filling the series would look like this: =[CIF9000.xls]Sheet1!$A$1...
  5. M

    Fill in blank cells based off criteria

    Happy Friday everyone, I have 2 columns of data (A-Trans and B-Reason) - each trans in col A should should have a reason in col B. The logic I am trying to apply is: if A3<>A2 do nothing. if A3=A2 and B3 is blank, B3=B2 I am looking for a solution for this problem. I preferably am looking...
  6. S

    Filter data from one colum and then fill a listbox on a userform

    Hi, I have a sheet called Timeliste, <tbody> Consultan Date Customer Activity Comments Start time End time Total time Customer ref Changing order Jo Doe 03.01.2014 Test Customer Test Test 11:00 12:00 02:00 34 Jo Doe 06.01.2014 Test2 Customer Test2 Test 12:30 52...
  7. S

    How to fill series in a pattern ?

    Column A contains a list of usernames, emails, account numbers, etc. I want to extract only the username and the respective email and put them is separate columns (C & D). So I entered the following formulas manually in C & D for the first 4 rows. I'm trying to autofill the cell addresses in...
  8. J

    Conditional Formatting

    I was wondering if there is any way to conditionally format a sheet to highlight cells in a certain range that do not contain a formula? Any suggestions are appreciated Thank you, Jared
  9. R

    filling formulas in a column

    i am trying to fill a column with this formula which is in the first cell of the column (H6), =G6/G36. when i try to fill down, both cell references increase by one, =G6/G36, =G7/G37, =G8/G38, etc. i want the first cell reference (G6) to increase by one cell (G7, G8, G9, etc.) and the second...

Watch MrExcel Video

This Week's Hot Topics

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
Top