Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Collecting data from worksheets.
Here is a frustrating scenario I have. An employee collects data on people in a spreadsheet. Each worksheet within the file is a month, from January to June. Each month lists names with some numbers and totals at the end of the rows. Here is the hard part, each month has a different list of names. Some have names that re-occur, some don't. He wants to create a new worksheet in the file listing all the names from every month (sorted alphabetically) with totals from a cell range in each month. I've burned myself out on this problem, and I'm out of ideas. -- MrSeagull ------------------------------------------------------------------------ MrSeagull's Profile: http://www.excelforum.com/member.php...o&userid=27722 View this thread: http://www.excelforum.com/showthread...hreadid=559418 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match and Sort for two range of data on different worksheets? | New Users to Excel | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Macro pulling data from 2 worksheets | Excel Discussion (Misc queries) | |||
sharing rows of data across multiple worksheets within a workbook | Excel Worksheet Functions | |||
data entry on multiple worksheets | Excel Discussion (Misc queries) |