multiple work sheets

T

traci

If I have 26 worksheets in my workbook On each sheet
column A has the part #
column B has customer name
column C has part #
column column D has product decription
column E has order date
column F has due date
column G has order quanity, .
Is there anyway i can pull the information from each worksheet by the
due date, have it on a seperate worksheet group by the due date.
What i would really like, is for when i key the due date information
it automatically appears on the other worksheet designated for that
day?
 
I

Innmentor

why not have all of the info from each sheet linked to another sheet where all
of your inout data is shown. Then use the vlookup or hlookup command in the due
date section to apply the criteria of say+30 days to the invoice date then form
a summary sheet which reads this from the data page which you can then hide.
 
Top