Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MultiSheet macro, to sum based on condition
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I delete the same row in a multisheet spreadsheet | Excel Discussion (Misc queries) | |||
macro to copy and paste based on a condition | Excel Discussion (Misc queries) | |||
Macro to delete rows based on a condition | Excel Worksheet Functions | |||
Deactivating a Forms macro button based on a worksheet condition? | Excel Discussion (Misc queries) | |||
Multisheet formula | Excel Discussion (Misc queries) |