How to copy or filter by automation function?

[blitssman]

Hi everyone,

Let say, I have a daily production related to 5 unique departements.

(dep 1, dep 2, dep 3, dep 4, dep 5), . each of these deps, are manually entered in a table main master sheet on a daily regular basis. The required task is this: How can I get each of these departments ( dep 1, dep 2, dep 3, dep 4, dep 5) to get copied or filtered by automation to there own unique table or sheets department name, when they are typed in from the main master sheet? exemple: ( all dep1, to be copied to the dep1 sheet or table, same for dept2, to dep2 sheet.... and so on) Can excel without VBA execute this? Which function would perform this?

Thank you all in advance!ray:

Main master sheet.

date	departements
2019-03-15	dep1
2019-03-16	dep1
2019-03-16	dep5
2019-03-18	dep2
2019-03-18	dep3
2019-03-20	dep1
2019-03-20	dep5
2019-03-20	dep4
2019-03-21	dep4
2019-03-22	dep5
2019-03-23	dep2
2019-03-23	dep3
2019-03-23	dep1
2019-03-26	dep2

<tbody>
</tbody>

 

[sandy666]

what is your excel version?

 

[blitssman]

oupsss sorry its excel 2007!!

 

[sandy666]

its excel 2007!!

so I can't help

Have a nice day

 

[Peter_SSs]

See if something like this is any use.

Cells D1:E1, H1:I1, L1:M1 etc manually entered
Formula in F1 copied to J1, N1, ...
Formula in D2 is array formula so should be entered without the {} but confirmed with Ctrl+Shift+Enter, not just Enter. If confirmed correctly, Excel will insert the {}. The formula can then be copied down to the last row of your data or as far as you might ever need.
Once D2 has been entered correctly and copied down, that column of formulas is copied to columns H, L, ...

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	date	departements		date	dep1	4		date	dep2	3		date	dep3	2
2	15/03/2019	dep1		15/03/2019				18/03/2019				18/03/2019
3	16/03/2019	dep1		16/03/2019				23/03/2019				23/03/2019
4	16/03/2019	dep5		20/03/2019				26/03/2019
5	18/03/2019	dep2		23/03/2019
6	18/03/2019	dep3
7	20/03/2019	dep1
8	20/03/2019	dep5
9	20/03/2019	dep4
10	21/03/2019	dep4
11	22/03/2019	dep5
12	23/03/2019	dep2
13	23/03/2019	dep3
14	23/03/2019	dep1
15	26/03/2019	dep2
16
Split Table

 

[blitssman]

heyyy good day Peter,

thanks for your help!! will try it and let you know has soon i can!!