Auto populate lists in 4 columns

[lost_in_the_sauce]

I have a list of stores with opening dates (mostly within the last 4 years) so they fall into the categories of Years Open (1, 2, 3, 4+) based on the opening date vs =today(). Column A being store name and column B being opening date.

My second tab is more of a dashboard list view, with name, version, sales YTD by park - all easily referenced info from tab 1 with all the data. Is there a way to auto populate the 4 columns on tab 2? For example, Starting with cell C15 and going down, all stores in their first year, same for cell H7 down and 2nd year, etc etc, but it places the stores in the correct columns when the file is opened instead of having to audit by hand every month to see which stores have broken an anniversary and need to change column?

 

[Ottsel]

I was following you in the first half, but the second part threw me off, so if I misunderstood your request I apologies.

So, going off your Store Open Index or sheet I'm guessing it'll look something along the lines as such?

Book1
	A	B	C
1	Store Name	Opening Date	Years Open
2	Sauce 1	1/1/2018	4
3	Sauce 2	01/01/19	3
4	Sauce 3	01/01/20	2
5	Sauce 4	01/01/21	1
6	Sauce 5	01/01/18	4
7	Sauce 6	01/01/19	3
8	Sauce 7	01/01/20	2
9	Sauce 8	01/01/21	1
Stores

Cell Formulas
Range	Formula
C2:C9	C2	=DATEDIF(B2,TODAY(),"y")

If so, then perhaps an automated format like this will work. No VBA required. You can switch it up with an

CONCATENATE

function if you perfer, but this worked for me.

Book1
	C	D	E	F	G	H	I	J	K	L
7	Years Open
8	1	2	3	4	5	6	7	8	9	10
9				Sauce 1
10			Sauce 2
11		Sauce 3
12	Sauce 4
13				Sauce 5
14			Sauce 6
15		Sauce 7
16	Sauce 8
17
18
19
20
21
22
23
24
25
26
27
28
Dashboard

Cell Formulas
Range	Formula
C9:L18	C9	=IF(Stores!$A2&Stores!$C2=Stores!$A2&Dashboard!C$8,Stores!$A2,"")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C9:L28	Expression	=MOD(ROW(),2)	text	NO

IMPORTANT: If this is what your seeking, remember to be careful when reformatting it to work on your worksheet, as the absolute and relative referring is critical here.