I have a three sheet workbook, one sheet is a summary sheet, the secon
is a data sheet and the third contains the constants.
I need to sum information from sheet2 and display in sheet1, soun
simple enough. I am summing the total plant hours.

I have several different order types, stored ina column in sheet2
these order types need to sum into different cells on sheet1. I als
need to have the amounts sum based on a date input from user(by week)
I have been thinking to select a variable range, because the sheet wil
be constantly added too, and then writing a loop to go thru the dat
column, but how do I pull the information?
Any suggestions?
I tried to attach the file, but it was too large, if anyone wants i
let me know I can e mail it.

Thanks,
msMop

--
Message posted from http://www.ExcelForum.com