| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how can i filter data from one sheet and copy to another via formu
i am dealing with 30000 line items of data. i would like to populate various
worksheets based on updated data on the "DATA" sheet. Example: Data sheet has data for 30 different product lines. i would like to select product A and any related data to product A and move it on a new worksheet, named "A". Currently i use the filter, cut and paste feature to do this but would like to know of a faster method. thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
| Copy sheet 1 data to sheet 2 cells. | Excel Worksheet Functions | |||
| copy data from one worksheet to identical sheet in different workbook | Excel Discussion (Misc queries) | |||
| Copy data in other sheet | Excel Worksheet Functions | |||
| Copy 1 Sheet to Another | Excel Worksheet Functions | |||
Threaded Mode
