Automatic organization

[Pietro Di Micio]

Hi Folks,

I am wondering if its possible to create an automatic organization of some data based on a key code, image and details below.

Tks in advance.

 

[Peter_SSs]

We cannot see what columns you have posted and we cannot copy the sample data for testing.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

Include the expected results with the XL2BB sample data and add any further explanation.

 

[Pietro Di Micio]

Sorry for that.

Actually, I do not know how to create the spreadsheet that I've mentioned; I gonna try to describe for you.

1) Column A with a KEY CODE, then Column B, C, D (Region, State, Street) after that Column E with KEY CODE and Column F with Historical;
2) Column A to D are flexible and E-F fixed;
3) What I need: When KEY CODE inside Column E match KEY CODE inside Column A, then organize by line (I mean put data inside column E and F at the same line of DATA inside Column A-D) and paint it GREEN; IF DO NOT MATCH, then do not need to organize and paint it RED;
4) Imagine that I will copy paste in daily basis informations from another spreadsheet inside Column A-D, but I need to keep the historical information to keep the tracking; so, I thought that if I keep the KEY CODE fixed in Column E perhaps is going to be a way to aligned the historical data inside Column F.

Thanks a lot for your support.

 

[Peter_SSs]

Actually, I do not know how to create the spreadsheet that I've mentioned;

Follow the XL2BB Add-in link in my previous post

 

[Pietro Di Micio]

Book2
	A
1
Sheet1

 

[MARK858]

@Pietro Di Micio you need to select the range to be posted before clicking XL2BB (you only had A1 selected when you made post 5)

 

[Pietro Di Micio]

test.xlsx
	A	B	C	D	E	F
1
2		COPY PASTE DATA - DAILY BASIS			FIXED DATA TO KEEP THE TRACKING
3
4		KEY CODE	REGION	STATE	KEY CODE 2	TRACKING INFORMATIONS
5		123	SOUTH	RIO GRANDE	235	Keep them posted about solution
6		456	NORTH	NATAL	900	Write a new message
7		789	WEST	MATO GROSSO	457	Check the content
8		900	EAST	RIO DE JANEIRO	123	Try new one
Sheet1

 

[Peter_SSs]

Thanks for getting XL2BB going.

It is still not entirely clear to me as the columns you refer to keep changing.
Also, I asked you to ..

Include the expected results with the XL2BB sample data ...

If you have done that then I'm not sure what it is or how you got it.
If you have not done that then please do so. It might mean that you need to post two XL2BB mini sheets: a "Before" mini sheet and an "After" mini sheet.

 

[Pietro Di Micio]

Follow bellow the start and final scenario that I am pleading.

test.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1
2		START SCENARIO
3
4		COPY PASTE DATA - DAILY BASIS			FIXED DATA TO KEEP THE TRACKING
5
6		KEY CODE	REGION	STATE	KEY CODE 2	TRACKING INFORMATIONS
7		123	SOUTH	RIO GRANDE	235	Keep them posted about solution
8		456	NORTH	NATAL	900	Write a new message
9		789	WEST	MATO GROSSO	457	Check the content
10		900	EAST	RIO DE JANEIRO	123	Try new one
11
12
13
14
15		START SCENARIO
16
17		COPY PASTE DATA - DAILY BASIS			FIXED DATA TO KEEP THE TRACKING
18
19		KEY CODE	REGION	STATE	KEY CODE 2	TRACKING INFORMATIONS		Does not matter where yellow is going to be placed; what is important is green aligned with green (same KEY CODE at the same line))
20		123	SOUTH	RIO GRANDE	123	Try new one
21		456	NORTH	NATAL	235	Keep them posted about solution
22		789	WEST	MATO GROSSO	457	Check the content
23		900	EAST	RIO DE JANEIRO	900	Write a new message
24		585	WEST	MATO GROSSO	-	-		New Iten can be add thru copy paste process, but if there is no match with static KEY CODE 2, there is no need to rearrangelines
25		222	NORTH	BAHIA	-	-
26		219	EAST	ESPIRITO SANTO	-	-
Sheet1

 

[Pietro Di Micio]

Is it complex?