Is this possible?

[jonesymw]

I am trying to figure out a way to tell excel to view my spreadsheet and say that stores a, b, c, d, e, f, g, h, i should be listed as region 1 under the region tab column. Then if the store is not listed, add it to sheet with the store name, store number, region code, and 0 for sales reported. Then if there is a store listed that is not in the macro change the font to red (so I know to add it). And finally sort it by region tab, then store #.

sales.xls
	A	B	C	D	E
1	RegionTab	STORENUM	STORENAME	Sales	Region
2	Region1	A	Jonesy1	1	MD-A1
3	Region1	B	JonesyPlus1	3	MD-A1
4	Region1	C	JonesySuperstore1	1	MD-A1
5	Region1	D	JonesyCaf1	2	MD-A1
6	Region1	E	JonesyBarandGrill1	2	MD-A1
7	Region2	AA	Jonesy2	1	MD-B1
8	Region2	AB	JonesyPlus2	1	MD-B1
9	Region2	AC	JonesySuperstore2	1	MD-B1
10	Region2	AD	JonesyCaf2	2	MD-B1
11	Region2	AE	JonesyBarandGrill2	1	MD-B1
12	Region3	BA	Jonesy3	1	MD-C1
13	Region3	BB	JonesyPlus3	2	MD-C1
14	Region3	BC	JonesySuperstore3	2	MD-C1
15	Region3	BD	JonesyCaf3	1	MD-C1
16	Region3	BE	JonesyBarandGrill3	1	MD-C1
17	Region4	CA	Jonesy4	2	MD-C4
18	Region4	CB	JonesyPlus4	1	MD-C4
19	Region4	CC	JonesySuperstore4	1	MD-C4
20	Region4	CD	JonesyCaf4	1	MD-C4
21	Region4	CE	JonesyBarandGrill4	1	MD-C4
Sheet1

 

[RalphA]

Generally, this forum helps Excel users to solve their problems by viewing either the formulas or code the user provides, and then indicating where their problem might lie. Normally, no one here will try to solve a total problem, such as the one you are describing. That's probably why you have had so many viewers, with nobody trying to answer you. Also, the posting instructions clearly requires you to very briefly indicate the type of Excel problem you are facing, and frowns heavily on subjects such as your enigmatic "Is this possible?"!

 

[jonesymw]

Clarification

I am not asking anyone to solve the issue at hand. I was simply asking if anyone could simply say by hearing the problem, oh try this function or this command. I just had no idea where to begin and was asking if someone could say oh try this function, not to say oh here is your script from beginning to end. I apologize if everyone got that opinion. As far as the subject line goes - I would have had to of made it one rather large line to put everything I wanted to in it - so that is why it was so "enigmatic" with, "Is this possible?" because that is basically all I wanted to know - is it possible with basic excel functions and etc to do what I want to do so that I don't have to waste hour upon hour running in circles to find out that it wasn't. So hopefully this helps clarify that I'm not not looking for a hand out.

 

[jonesymw]

Any Pointers for Verifying, Adding, Sorting Data?

I am trying to figure out a way to tell excel to view my spreadsheet and say that stores a, b, c, d, e, f, g, h, i should be listed as region 1 under the region tab column. Then if the store is not listed, add it to sheet with the store name, store number, region code, and 0 for sales reported. Then if there is a store listed that is not in the macro change the font to red (so I know to add it). And finally sort it by region tab, then store #. I am not looking for someone to hand me the script. I just am wondering if it is a possibility and for a few suggestions on what funtion to try to manipulate or just a hey check into this, research this topic - it will lead you in the right direction. Then I can get to the point where I have script for hashing. Appreciate any pointers.

sales.xls
	A	B	C	D	E
1	RegionTab	STORENUM	STORENAME	Sales	Region
2	Region1	A	Jonesy1	1	MD-A1
3	Region1	B	JonesyPlus1	3	MD-A1
4	Region1	C	JonesySuperstore1	1	MD-A1
5	Region1	D	JonesyCaf1	2	MD-A1
6	Region1	E	JonesyBarandGrill1	2	MD-A1
7	Region2	AA	Jonesy2	1	MD-B1
8	Region2	AB	JonesyPlus2	1	MD-B1
9	Region2	AC	JonesySuperstore2	1	MD-B1
10	Region2	AD	JonesyCaf2	2	MD-B1
11	Region2	AE	JonesyBarandGrill2	1	MD-B1
12	Region3	BA	Jonesy3	1	MD-C1
13	Region3	BB	JonesyPlus3	2	MD-C1
14	Region3	BC	JonesySuperstore3	2	MD-C1
15	Region3	BD	JonesyCaf3	1	MD-C1
16	Region3	BE	JonesyBarandGrill3	1	MD-C1
17	Region4	CA	Jonesy4	2	MD-C4
18	Region4	CB	JonesyPlus4	1	MD-C4
19	Region4	CC	JonesySuperstore4	1	MD-C4
20	Region4	CD	JonesyCaf4	1	MD-C4
21	Region4	CE	JonesyBarandGrill4	1	MD-C4
Sheet1

 

[RalphA]

Ignore!

 

[RalphA]

Ignore!

 

[RalphA]

I didn't mean to offend, so, I apologize for my bluntness.

Referreng to your first sentence, namely,

I am trying to figure out a way to tell excel to view my spreadsheet and say that stores a, b, c, d, e, f, g, h, i should be listed as region 1 under the region tab column.

perhaps the following pseudocode concept will help you?

For i = 2 to the last row with data
  If len(cell "B" & i) = 1 then
    show the sentence, "Store "& CHAR(j) &" should be listed as Region 1"
  ElseIf len(cell "B"& i) = 2 then
    For j = 65 to 90 'Code("A")=65, Code("Z") = 90     
      If left(cell "B" & i,1) = char(j) then
        show the sentence, "Store "& cell "B"& i(char(j)" should be listed _
        as  Region "& j-63
      End If
    Next j
  End If
Next i

Is this the kind of help you are looking for? If so, maybe I can help. But, if you need VBA help, I know very little VBA, and someone else would have to pitch in.

 

[jonesymw]

Thankful for any help!

That is the type of help I am looking for, even if it isn't very specific it will be a help. Just an idea for me to try or a pointer here and there. My only problem is with this particular challenge, I just had no idea where to begin. I will try working with your example and see what I come up with, thanks.

 

[RalphA]

jonesymw:

In re-reading my post, I notice that I have one or two errors. But, if you can get the help you needed from my post, then I won't try to correct my code. If you get tangled up, though, I will carefully correct my previous post. Good luck!