how to make multiple sheets based on info in main worksheet

[lunima]

HELP , sorry have checked out as many threads as possible to try and work out what I need to do but have realised that as far as EXCEL goes I am completely iliterate ...sorry
I need to do the following
WE have one main excel sheet on the server that four of us update and save with new reservations , the data on this sheet is ordered by file reference

PLSA30505

Alvarez Laura

2

arg

toselli

miércoles, 25 de enero de 2012

05/02/2012

horus jordania

<COLGROUP><COL style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3876" width=106><COL style="WIDTH: 119pt; mso-width-source: userset; mso-width-alt: 5814" width=159><COL style="WIDTH: 60pt" span=3 width=80><COL style="WIDTH: 169pt; mso-width-source: userset; mso-width-alt: 8228" width=225><COL style="WIDTH: 60pt" span=2 width=80><TBODY>
</TBODY>

we would need to make cross reference sheets that show for example only the reservations for the month of january ( enero ) , February , thru to december and that these sheets update everytime someone enters new data

Is it possible ??

Please help

 

[patel45]

can you attach a link to a sample file with comments ?

 

[lunima]

can you attach a link to a sample file with comments ?

Ref	name	pax	pais	empresa	fecha	fin	circuito
PLSA30505	Alvarez Laura	2	arg	toselli	miércoles, 25 de enero de 2012	domingo, 05 de febrero de 2012	horus jordania
PLSA30509	lopez	2	arg	piamonte	domingo, 23 de enero de 2011	01/0212	horus EB4 con alejandría
PLSA30510	CARRENO	2	ARG	PIAMONTE	lunes, 23 de abril de 2012	lunes, 30 de abril de 2012	HORUS 5*
PLSA30517	PERGOLA	2	ARG	PIAMONTE	sábado, 28 de enero de 2012	domingo, 05 de febrero de 2012	HORUS 5
PLSA30518	ROSENFELDT	2	ARG	PIAMONTE	domingo, 22 de enero de 2012	domingo, 29 de enero de 2012	HORUS 5 LUJO
PLSA30519	CABANA CATALINA	1	ARG	PIAMONTE	viernes, 10 de febrero de 2012	sábado, 18 de febrero de 2012	HORUS 4 + EXTRA NOCHE
PLSA30520	MARELLI SERGIO	4	ARG	PIAMONTE	sábado, 18 de febrero de 2012	jueves, 01 de marzo de 2012	EXT SHARM DESDE EL GRUPAL
PLSA30521	GRUPAL ENERO 2012	9	ARG	EUROVIPS	domingo, 08 de enero de 2012		horus 5 super lujo
PLSA30522	robles sergio	2	arhg	eurovips	sábado, 21 de enero de 2012	sábado, 28 de enero de 2012	horus 5 lujo
PLSA30523	bessone	2	arg	eurovips	viernes, 20 de enero de 2012	lunes, 23 de enero de 2012	solo crucero + traslados
PLSA30524	ORTALE	2	ARG	PIAMONTE	viernes, 17 de febrero de 2012	sábado, 25 de febrero de 2012	horus 5
PLSA30529	Tortorice	1	arg	navijet	sábado, 14 de abril de 2012	sábado, 21 de abril de 2012	horus 5 desdeMAD agente de viajes
PLSA30530	CARVALHO	4	arg	piamonte	jueves, 02 de febrero de 2012	jueves, 09 de febrero de 2012	Horus con vuelo 4D
PLSA30531	rodriguez arturi	2	arg	eurovips	viernes, 20 de enero de 2012	domingo, 29 de enero de 2012	HORUS 5 CON 2 NOCHES EXTRAS
PLSA30534	Grupal Mayo eurovips	20+1	arg	eurovips	domingo, 27 de mayo de 2012	domingo, 03 de junio de 2012	Horus
PLSA30535	Cordoba	2	arg	piamonte	domingo, 08 de enero de 2012	domingo, 15 de enero de 2012	horus 4 con vuelo $D

<COLGROUP><COL style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3876" width=106><COL style="WIDTH: 119pt; mso-width-source: userset; mso-width-alt: 5814" width=159><COL style="WIDTH: 60pt" span=2 width=80><COL style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 3730" width=102><COL style="WIDTH: 169pt; mso-width-source: userset; mso-width-alt: 8228" width=225><COL style="WIDTH: 158pt; mso-width-source: userset; mso-width-alt: 7716" width=211><COL style="WIDTH: 153pt; mso-width-source: userset; mso-width-alt: 7460" width=204><TBODY>
</TBODY>

 

[Oeldere]

Maybe you can tell the forummembers you crossposted this question.how to make multiple sheets based on info in main worksheet