Excel 2003

  • Thread starter Thread starter OzzyJim
  • Start date Start date
O

OzzyJim

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
 
OzzyJim said:
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
Click to expand...

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
 
Autofilter on Days to Go then copy results to the next sheet.


Gord Dibben MS Excel MVP
 
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
 
Spot on Gord, appreciate your help mate

Gord Dibben said:
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




.
Click to expand...
 
Back
Top