I attached a piece of my code, and some of the adjustments i tried to make for it to work. in this case i only want to look for duplicates in cells a4 - a11 and then again from a22-a30.
Thanks SirJB7, this is very helpful. I went with the first macro you sent me since my data will be text and the ambiguity you mentioned will be extremely rare.
But I was hoping you could help explain how the range for searching for duplicates works. The way my template is setup for looking for...
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...
Thanks Deb, that option actually was unchecked, but I checked it and changed my maximum change to .001 (it was set at 252) and it is now working.
Thanks a lot!
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...
Thanks Hui,
I made that change and my cells less than 0 are no longer light red. They are now not formatted at all, my dark red conditional format is still not working. I tried changing to =IF($R$12<=0,1," ") but still not working. My values in column R are percents with 1 decimal place. For...
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...
Thanks guys, I just tried Faseeh's suggestion but im getting a #value error in the first month fomrula. *(MONTH($E$1:$F$3)
I changed the date format to match they way his date was displayed. Anyone know what im doing wrong?
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...
Thanks Luke,
Data will be constantly appended to this worksheet so the range of the blank cells will be different each time. I will always be looking for the range in column g, that starts with the first blank cell in column G, and the last non blank cell in column F. I want to remove the...
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 =...
I played around with this for a while and was able to come up with an answer:
Findtotalz = WorksheetFunction.Match("Total Current Scenario", [c:c], False)
findend = WorksheetFunction.Match("Total Proposed Scenario", [c:c], False)
Range("a" & Findtotalz, "a" & findend).FormulaR1C1 =...
Thanks Deb and SirJB7,
What you said worked perfectly, but now I am trying to set a range between two cells based on the two terms "total current scenario" & "total proposed scenario". Here's what I have come up with but I am getting an error "Range of Global Object Failed":
findtotal =...
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...
Oh ok I see, yes e1 is blank but e2 has a value. What would I have to do differently to get this line to instead of count all column E, count from cell e2 down to the bottom or stop at cell e1000 for example?
row_count = Application.WorksheetFunction.CountA(Columns("E:E"))
thanks again
Dave, I tried the formula you gave me, but the vlookup copies down to the second to last cell. Leaving the last non blank cell without a formula.
On the line:
For i = 3 to row_ count
I added a + 1 to the end and it works. But I would like to understand this better, why would this not be...
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...