pattern

Hi, I have a procedure that set / reset the pattern of the currently selected cell which work fine but I would like to set the pattern color too so I added the line in blue: Public Sub SetReset_Pattern(thePattern, patternColorIndex) With ActiveSheet If Selection.Interior.Pattern =...

Hello, Please let me know how to include these characters ( " " , []) also in the following pattern .Pattern = "[{}+=<>?'_~`!#$%^*]"

Hi Folks, Is there someone who has a daily inventory excel that I can use or make a pattern with? The business is for a small enterprise, needed to maintain the daily inventory. Thank you.

I have text in B1 = : 2 myrext: take and :test In c1 = 2 d1 = take ,e1 =test This is my pattern .pattern ="^[:]([^:].+?\s)$" What wrong with my pattern in regular exspresion

Have this: A1=val A2=val A3=val A4=val A5=val A6=val A7=val A8=val Need to turn next column into this: B1=A1 B2=A1 B3=A2 B4=A2 B5=A3 B6=A3 Excel won't pick up on the pattern, any tips? Basically need to turn "X" number of cells into twice as many cells, duplicating each cell below itself or...

I'm trying to do a simple numbering pattern but running into some issues. This is an example of what I'm trying to do: 1 2 3 4 5 2 3 4 5 3 4 5 1 2 As you can see, I'm just trying to count 1 through 5, and then start the next cell with 2 and end with 1. Thank you for any help on this.

So, I am working with a sheet that has a certain number in each column KL-LM, only if the number in JX is different from the one in the row above. So JX3 is 1850, that means KL to LM will have this number times a factor. In JX43 there is 1450. Now as you can see in the screenshot, KF3 is 6607...

how can i generate regex pattern without going through a lot of trouble of deciphering it. is there any software that generates pattern based on the example input given by user?

Dear Forum Members, I apologize if I'm missing something really simple here, but I'm trying to use VBA to test whether a string contains only zeroes. The string can be many zeroes, or one zero, but must only contain zeroes. Here's the code I've been trying. It always tells me that the string...

My spreadsheet is set up this way, with 50+ rows following the same pattern. <tbody> ID# TEAM TEAMLEADER TEAMMEMBER PHONE# COMMENT 1 BLUE HAROLD MARTHA 555-5555 2 RED BILL TONY 555-5556 3 GREEN HAROLD CYNTHIA 555-5557 </tbody> I want to set up several Macros and corresponding...

Hello dear MrExcel! Indirect values from sheet1, but it needs to skip 3 rows, pattern is always 3 rows, and there will always be 2 rows to pick up;) Thanks in advance! [/IMG] [/IMG]

Here is the code in my macro that I would like to use to check cell range D4:O4 for the pattern FY followed by two numbers. Any help would be appreciated. If Range("D4:O4").Value <> "FY##" Then MsgBox "please check your FY's." End If

Hi, the shortcut Ctrl + arrow is skipping fields with data? I've tested both up and down columns and also left and right in rows. There is no pattern to the data it's skipping over. Has anyone ever had this occurrence? Philip

When you put in a series of numbers in sequential cells then drag from the corner of the cell, Excel will see the pattern and predict the next few numbers for you. But in more complex cases, Excel completely misses the pattern. For example, this formula: =GETPIVOTDATA("Sum of...

Hello! I need to add "-" ("hyphen-minus") into the: Pattern = "[!A-Za-z0-9]" Thanks in advance!

<colgroup><col><col span="13"></colgroup><tbody> Month 0 1 2 3 4 5 6 7 8 9 10 11 12 Sales Pattern 3% 10% 21% 25% 8% 9% 10% 5% 2% 3% 2% 1% 1% Production 287 500 532 612 751 235 535 128 91 18 0 0 0 Sales 287*3% 287*10% + 500*3% 287*21% + 500*10% + 532*3% 287*25% + 500*21% + 532*10% + 612*3%...

Hi there, I have read several threads on the topic but haven't been able to figure out this issue so far: I am trying to reference cells from one sheet to another, with the following pattern: A1 A2 A4 A5 A7 A8 I.e., read 2 rows, skip one, read 2 rows, skip one...and so forth. I am new to...

I need to create a macro that goes through a list and arranges the values in that list in a 3 3 2 fashion based on a set criteria. For example: the list is: A B C D E F G H and the criteria is: A,B,D,G,H can only be in column 1 or 3 C,E can only be in column 1 and 2 F can be in column 2 and...

Hello, I was wondering if there is a way to cut words from sentences ? My problem is that i have information that is in one cell and i need to cut it apart in different cells. I could do it manualy but there are thousands of sheets like this. Example Johan dohan, snippersnapper, jorgen 21...

I am wondering if its possible to write a macro that can find a relationship between columns in the worksheet found on the link below and make possible forecasts based on the relationship. https://www.dropbox.com/s/06hpjgcxuh61vkg/FIND%20A%20RELATIONSHIP.xlsx?dl=0 The worksheet has two...