fill formula

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

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

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

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

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

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

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

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

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