OK, per the advice of those on this board, I am posting snap shots of my page layouts…I hope it works and helps everyone understand.<!--[if !supportEmptyParas]--><!--[endif]--><o></o>
I am very new, so please be as simplistic and detailed as you can with your advice. I’m struggling enough as it is.<!--[if !supportEmptyParas]--><!--[endif]--><o></o>
Anyway, here is what I need. The user is trying to find the products that are due to be reordered within a specified “window”. So, on sheet 1, the user will enter the date of their next order. They will also enter how many days in advance they want to use, in order to find products that are due for reorder within this “window”. Using this date, and this number of days, I want the program to search all of the sheets in the workbook (1 for each customer – upwards of 50 customers) for “NEXT ORDER” (as shown on sheet 2) dates that fall within this “window”. In this example, the “window” is within 30 days from June 18.<!--[if !supportEmptyParas]--><!--[endif]--><o></o>
Once the “NEXT ORDER” dates are found, on each and every sheet, I want the program to get the following information from each sheet for each product that is due for reorder – CUSTOMERS NAME, PRODUCT, QUANTITY, and the NEXT ORDER date. Then enter this information on sheet 1. Thus, creating a list of products, and the associated customers, that are due to be reordered.<!--[if !supportEmptyParas]--><!--[endif]--><o></o>
Sheet 1<!--[if !supportEmptyParas]--><!--[endif]--><o></o><!--[if !supportEmptyParas]--><HTML><HEAD><Script Langage JavaScript></Script></HEAD><BODY BGCOLOR=#E0F4EA><CENTER><FONT COLOR=#339966 SIZE=5>[HtmlMaker 2.42]</FONT><BR><BR></CENTER><HR><BR><SPAN id='ForSubmit'>
</pre></SPAN></BODY></HTML>
Sheet 2<HTML><HEAD><Script Langage JavaScript></Script></HEAD><BODY BGCOLOR=#E0F4EA><CENTER><FONT COLOR=#339966 SIZE=5>[HtmlMaker 2.42]</FONT><BR><BR></CENTER><HR><BR><SPAN id='ForSubmit'>
</SPAN></BODY></HTML></pre>
I am very new, so please be as simplistic and detailed as you can with your advice. I’m struggling enough as it is.<!--[if !supportEmptyParas]--><!--[endif]--><o></o>
Anyway, here is what I need. The user is trying to find the products that are due to be reordered within a specified “window”. So, on sheet 1, the user will enter the date of their next order. They will also enter how many days in advance they want to use, in order to find products that are due for reorder within this “window”. Using this date, and this number of days, I want the program to search all of the sheets in the workbook (1 for each customer – upwards of 50 customers) for “NEXT ORDER” (as shown on sheet 2) dates that fall within this “window”. In this example, the “window” is within 30 days from June 18.<!--[if !supportEmptyParas]--><!--[endif]--><o></o>
Once the “NEXT ORDER” dates are found, on each and every sheet, I want the program to get the following information from each sheet for each product that is due for reorder – CUSTOMERS NAME, PRODUCT, QUANTITY, and the NEXT ORDER date. Then enter this information on sheet 1. Thus, creating a list of products, and the associated customers, that are due to be reordered.<!--[if !supportEmptyParas]--><!--[endif]--><o></o>
Sheet 1<!--[if !supportEmptyParas]--><!--[endif]--><o></o><!--[if !supportEmptyParas]--><HTML><HEAD><Script Langage JavaScript></Script></HEAD><BODY BGCOLOR=#E0F4EA><CENTER><FONT COLOR=#339966 SIZE=5>[HtmlMaker 2.42]</FONT><BR><BR></CENTER><HR><BR><SPAN id='ForSubmit'>
Customers Orders.xls | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | |||
1 | |||||||||||||
2 | |||||||||||||
3 | DateOfNextOrder | July18,2008 | |||||||||||
4 | Productsforreorderwithinthenext: | 30 | Days | ||||||||||
5 | |||||||||||||
6 | Customer | Product | Quantity | NextOrder | |||||||||
7 | |||||||||||||
8 | |||||||||||||
9 | |||||||||||||
10 | |||||||||||||
11 | |||||||||||||
12 | |||||||||||||
13 | |||||||||||||
14 | |||||||||||||
15 | |||||||||||||
16 | |||||||||||||
17 | |||||||||||||
18 | |||||||||||||
19 | |||||||||||||
20 | |||||||||||||
Sheet1 |
Sheet 2<HTML><HEAD><Script Langage JavaScript></Script></HEAD><BODY BGCOLOR=#E0F4EA><CENTER><FONT COLOR=#339966 SIZE=5>[HtmlMaker 2.42]</FONT><BR><BR></CENTER><HR><BR><SPAN id='ForSubmit'>
Customers Orders.xls | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | |||
1 | ||||||||||||||
2 | ||||||||||||||
3 | Name: | HomePhone: | ||||||||||||
4 | Address: | WorkPhone: | ||||||||||||
5 | City: | CellPhone: | ||||||||||||
6 | State: | E-mail: | ||||||||||||
7 | Zip: | Birthday: | ||||||||||||
8 | ||||||||||||||
9 | ||||||||||||||
10 | ||||||||||||||
11 | ||||||||||||||
12 | Product | Quantity | LastOrdered | DaysOfUse | NextOrder | |||||||||
13 | RubyRedLipstick | 2 | July10,2008 | 45 | August24,2008 | |||||||||
14 | GrassSeed | 3 | May5,2008 | 60 | July4,2008 | |||||||||
15 | BaseballCards | 1 | June16,2008 | 40 | July26,2008 | |||||||||
16 | KaratePoster | 5 | June30,2008 | 30 | July30,2008 | |||||||||
17 | ||||||||||||||
18 | ||||||||||||||
19 | ||||||||||||||
20 | ||||||||||||||
21 | ||||||||||||||
22 | ||||||||||||||
23 | ||||||||||||||
24 | ||||||||||||||
Sheet 2 |