Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy data from one worksheet to another
Is there a function or command I can use to get excel to automatically copy a
row from the master worksheet over to a seperate monthly sheet when the data in a certain cell matches a range of criteria i.e. Master (Wksht 1) A B C Joe Smith Active 11/01/07 John Doe Closed 11/10/07 Justine A Pending 11/08/07 Kim Al Active 12/07/07 Monthly (Wksht 2) A B C =the entire row if cell C is within 11/01/07 - 11/30/07 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy from B worksheet to A worksheet with NO repeated data | Excel Discussion (Misc queries) | |||
copy data from a worksheet | Excel Worksheet Functions | |||
copy data in a cell from worksheet A to worksheet B | Excel Discussion (Misc queries) | |||
Copy Data from one worksheet to another | Excel Discussion (Misc queries) | |||
Copy Data to Another Worksheet | Excel Worksheet Functions |