L
Lost
ok im gonna try to explain this as well as possible. I need help figureing
out how to pull Lot numbers and the amount used of each Lot. The lots are in
cell range workbook1.xls a1:a11, workbook2.xls a1:a11,......workbook6.xls
a1:11 and the amount used is in B1:b11 in all 6 workbooks. Each workbook has
6 sheets in them, so what i need help with is "how do I pull them to
Workorder.xls?"
Example of one sheet in one workbook(same in all workbooks same on all
sheets for data spots)
Wookbook1.xls sheet1 sheet2 ....
sheet6
A B A B
A B
lot used Lot used
Lot used
1 456 20 567 30
456 30
2 345 40 345 20
567 30
3 567 20
345 5
:
11
Workorder
a b c d
1 date1 lot used
2 date2 345 65
3 product # 456 50
4 567 80
5
6
7
I have only 24 places to put the data so i cant have any blank spaces, also
both dates and product #'s have to match between workbook's 1 thru 6 if not
then dont pull data. well say date1 is d5,date2 is d6, product # is d7 on all
the workbooks except workorder.
out how to pull Lot numbers and the amount used of each Lot. The lots are in
cell range workbook1.xls a1:a11, workbook2.xls a1:a11,......workbook6.xls
a1:11 and the amount used is in B1:b11 in all 6 workbooks. Each workbook has
6 sheets in them, so what i need help with is "how do I pull them to
Workorder.xls?"
Example of one sheet in one workbook(same in all workbooks same on all
sheets for data spots)
Wookbook1.xls sheet1 sheet2 ....
sheet6
A B A B
A B
lot used Lot used
Lot used
1 456 20 567 30
456 30
2 345 40 345 20
567 30
3 567 20
345 5
:
11
Workorder
a b c d
1 date1 lot used
2 date2 345 65
3 product # 456 50
4 567 80
5
6
7
I have only 24 places to put the data so i cant have any blank spaces, also
both dates and product #'s have to match between workbook's 1 thru 6 if not
then dont pull data. well say date1 is d5,date2 is d6, product # is d7 on all
the workbooks except workorder.
as long as it works, this has been beating me