Search results

I've built a macro to pull specific data out of a standardized template. The macro inserts a column into column A of the template sheet with "=B1&C1" formulas in order to create more specific identifiers for use with Vlookups. It turns out some of the cells in B1 and C1 are sometimes the same...

Im trying to use goal seek, but its not working in my version of excel 2007. Ive had someone else open the same file in excel 2007 and there goal seek works correctly. I get no error message, it just doesn't adjust the value and says it found the target value. Is there an add in or some option...

I have pivot table in which I am trying to use conditional formatting based on 5 cells that I have setup up in column D. I want the rows inside the pivot table to be highlighted based on the value starting with cell R12 (part of the pivot table). I have been able to get 4 of the conditions to...

Im trying to use VBA to fill the entire sheet either red or green based on the cell values in column I. I made the code below but it is giving me an error with my range line. I want to fill the sheet red if any cell in column I is equal to 1 or greater, and fill it green if any cell is equal...

I have 2 files - The first has Sku numbers and months, the second file has sku numbers and date ranges in two cells. they look like this. FILE 1: 1 2 SKUABC Mar SKU123 FEB FILE 2: 1 2 3 SKUABC 1/1/2013 3/1/2013 SKUABC...

Hello, Im looking to use the VBA RTrim function to remove spaces from the end of the cell while preserving the spaces that exist inside the cell text. For example some cells look like this(_ as spaces) ABC__115____ I want to remove the spaces after the 5 but keep the spaces between c and 1...

Hi, Im looking for help to create a macro to find blank cells in a certain range and then insert a formula in. For example I have data in a5:Q25 but cells g22:g25 are blank. I want the macro to find the empty cells and fill in a vlookup formula. The code I pasted below is overwriting cells that...

I am trying to copy the text string that is in a textbox into a variable range. This is what I have been able to come up with but, I can only get it to copy to the first cell in the range, and then I get blanks for the rest. Can anyone tell me what I'm doing wrong? row_count =...

Im trying to copy cells in column B, at first I was copying until the cell was blank and used this code. With Range("b21") Range(.Cells(1, 1), .End(xlDown)).copy Destination:=Worksheets("Copy").Range("e3") End With But in some of the files that use this macro, there are spaces in between...

I am writing a macro that will fill in vlookups, I thought what I had wrote would stop when the cell to the left(In Column E) was blank. But it fills down to the very last row. '=VLOOKUP(E3,'SKU DETAIL'!B:D,3,FALSE) Range("f3:f" & (Range("e" & Rows.Count).End(xlDown).Row)).FormulaR1C1 = _...

I am trying to convert the following: Sku Jan Cost Jan GSV Feb Cost Feb GSV 1 1 5 2 10 2 2 4 2 4 3 3 6 3 6 To Look Like this: Sku Cost GSV Month 1 1 5 Jan 2 2 4 Jan 3 3 6 Jan 1 2 10 Feb 2 2 4 Feb 3 3 6 Feb I have to do this to several files with...