Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi..I have workbook with 10 worksheets and I would like to extract data from
each worksheet to worksheet 11 that shows me everyone who has bought 50 + boxes.. Right now i have sort each worksheet and copy data from each worksheet to differnt worksheet.. Please help |
#2
![]() |
|||
|
|||
![]()
Nagar,
In many cases, similar data is spread across multiple sheets where it'd be much better to have it all in one sheet. Read "Data across multiple sheets" at http://www.smokeylake.com/excel/excel_truths.htm . -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Nagar" wrote in message ... Hi..I have workbook with 10 worksheets and I would like to extract data from each worksheet to worksheet 11 that shows me everyone who has bought 50 + boxes.. Right now i have sort each worksheet and copy data from each worksheet to differnt worksheet.. Please help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I display data from multiple worksheets in a summary sheet. | Excel Discussion (Misc queries) | |||
Extracting data from multiple worksheets into a list | Excel Worksheet Functions | |||
Finding Data in multiple worksheets | Excel Discussion (Misc queries) | |||
Merge Data From Multiple Worksheets | Excel Worksheet Functions | |||
data entry on multiple worksheets | Excel Discussion (Misc queries) |