Excel 2003
 

Hi All,

After suggestions for the following please.

Have a large data table that tracks customer information. Would like to
interogate the table and display customer information that meets a certain
criteria.

i.e if customer delivery date is falling due less than 5 days from a
nominated date, i would like to display customer name, item # etc on a
seperate page that meets that condition (highlight falling due)

Cheers
Jim

Excel 2003
 

"OzzyJim" wrote:

Hi All,

After suggestions for the following please.

Have a large data table that tracks customer information. Would like to
interogate the table and display customer information that meets a certain
criteria.

i.e if customer delivery date is falling due less than 5 days from a
nominated date, i would like to display customer name, item # etc on a
seperate page that meets that condition (highlight falling due)

Cheers
Jim
Just to clarify above. Simple table below. If i want to return info on lines with less than 5 days to go, line 1 details would be displayed

Customer Part Due date Days to go
John 114-524 18/12/2009 4
Deb 114-525 19/12/2009 5
Deb 114-526 20/12/2009 6

Excel 2003
 

Autofilter on Days to Go then copy results to the next sheet.


Gord Dibben MS Excel MVP

On Mon, 14 Dec 2009 21:07:02 -0800, OzzyJim
wrote:



"OzzyJim" wrote:

Hi All,

After suggestions for the following please.

Have a large data table that tracks customer information. Would like to
interogate the table and display customer information that meets a certain
criteria.

i.e if customer delivery date is falling due less than 5 days from a
nominated date, i would like to display customer name, item # etc on a
seperate page that meets that condition (highlight falling due)

Cheers
Jim
Just to clarify above. Simple table below. If i want to return info on lines with less than 5 days to go, line 1 details would be displayed

Customer Part Due date Days to go
John 114-524 18/12/2009 4
Deb 114-525 19/12/2009 5
Deb 114-526 20/12/2009 6

Excel 2003
 

Thanks Gord,

Is there anyway to make this automated....i.e if and vlookup???

"Gord Dibben" wrote:

Autofilter on Days to Go then copy results to the next sheet.


Gord Dibben MS Excel MVP

On Mon, 14 Dec 2009 21:07:02 -0800, OzzyJim
wrote:



"OzzyJim" wrote:

Hi All,

After suggestions for the following please.

Have a large data table that tracks customer information. Would like to
interogate the table and display customer information that meets a certain
criteria.

i.e if customer delivery date is falling due less than 5 days from a
nominated date, i would like to display customer name, item # etc on a
seperate page that meets that condition (highlight falling due)

Cheers
Jim
Just to clarify above. Simple table below. If i want to return info on lines with less than 5 days to go, line 1 details would be displayed

Customer Part Due date Days to go
John 114-524 18/12/2009 4
Deb 114-525 19/12/2009 5
Deb 114-526 20/12/2009 6

.

Excel 2003
 

Sort of..........

In Sheet1 you have the list per your example.

In Sheet2 row 1 enter your titles.

In Sheet2 A2 enter this formula

=IF(Sheet1!$D2<5,Sheet1!A2,"")

Copy across to D2 and down as far as you need.

Data will not be contiguous but it will get there.

To fully automate it you could use code from Ron de Bruin's site which
filters and copies to a sheet.

http://www.rondebruin.nl/copy5.htm

He gives five example scenarios with code for each and a sample workbook.


Gord


On Tue, 15 Dec 2009 13:34:02 -0800, OzzyJim
wrote:

Thanks Gord,

Is there anyway to make this automated....i.e if and vlookup???

"Gord Dibben" wrote:

Autofilter on Days to Go then copy results to the next sheet.


Gord Dibben MS Excel MVP

On Mon, 14 Dec 2009 21:07:02 -0800, OzzyJim
wrote:



"OzzyJim" wrote:

Hi All,

After suggestions for the following please.

Have a large data table that tracks customer information. Would like to
interogate the table and display customer information that meets a certain
criteria.

i.e if customer delivery date is falling due less than 5 days from a
nominated date, i would like to display customer name, item # etc on a
seperate page that meets that condition (highlight falling due)

Cheers
Jim
Just to clarify above. Simple table below. If i want to return info on lines with less than 5 days to go, line 1 details would be displayed

Customer Part Due date Days to go
John 114-524 18/12/2009 4
Deb 114-525 19/12/2009 5
Deb 114-526 20/12/2009 6

.

Excel 2003
 

Spot on Gord, appreciate your help mate

"Gord Dibben" wrote:

Sort of..........

In Sheet1 you have the list per your example.

In Sheet2 row 1 enter your titles.

In Sheet2 A2 enter this formula

=IF(Sheet1!$D2<5,Sheet1!A2,"")

Copy across to D2 and down as far as you need.

Data will not be contiguous but it will get there.

To fully automate it you could use code from Ron de Bruin's site which
filters and copies to a sheet.

http://www.rondebruin.nl/copy5.htm

He gives five example scenarios with code for each and a sample workbook.


Gord


On Tue, 15 Dec 2009 13:34:02 -0800, OzzyJim
wrote:

Thanks Gord,

Is there anyway to make this automated....i.e if and vlookup???

"Gord Dibben" wrote:

Autofilter on Days to Go then copy results to the next sheet.


Gord Dibben MS Excel MVP

On Mon, 14 Dec 2009 21:07:02 -0800, OzzyJim
wrote:



"OzzyJim" wrote:

Hi All,

After suggestions for the following please.

Have a large data table that tracks customer information. Would like to
interogate the table and display customer information that meets a certain
criteria.

i.e if customer delivery date is falling due less than 5 days from a
nominated date, i would like to display customer name, item # etc on a
seperate page that meets that condition (highlight falling due)

Cheers
Jim
Just to clarify above. Simple table below. If i want to return info on lines with less than 5 days to go, line 1 details would be displayed

Customer Part Due date Days to go
John 114-524 18/12/2009 4
Deb 114-525 19/12/2009 5
Deb 114-526 20/12/2009 6

.


.