Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Moving data from from one worksheet to another
I want to create a workbook in which I can enter (farm) feild information in
the front worksheet, set up similiar to a checkbook register. I have specified a column in which I will use a code name for a given feild. I have also created summary worksheets for each feild on the farm. What I want to do is copy the data from the front sheet which pertains to each feild into the individual feild summary sheets. Can I use the first column of each row to isolate and copy only the rows that have a matching codename to the corresponding feild summary sheet. How can I accomplish this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Moving data from from one worksheet to another
You can, but I wouldn't.
I'd just apply data|filter|Autofilter to show/hide the stuff I want shown/hidden. But if you really want.... Debra Dalgleish and Ron de Bruin have samples that you may like. Ron's addin may be sufficient right out of the box. Debra's site: http://www.contextures.com/excelfiles.html Create New Sheets from Filtered List -- uses an Advanced Filter to create separate sheet of orders for each sales rep visible in a filtered list; macro automates the filter. AdvFilterRepFiltered.xls 35 kb or Update Sheets from Master -- uses an Advanced Filter to send data from Master sheet to individual worksheets -- replaces old data with current. AdvFilterCity.xls 55 kb And Ron de Bruin's easyfilter. http://www.rondebruin.nl/easyfilter.htm imills wrote: I want to create a workbook in which I can enter (farm) feild information in the front worksheet, set up similiar to a checkbook register. I have specified a column in which I will use a code name for a given feild. I have also created summary worksheets for each feild on the farm. What I want to do is copy the data from the front sheet which pertains to each feild into the individual feild summary sheets. Can I use the first column of each row to isolate and copy only the rows that have a matching codename to the corresponding feild summary sheet. How can I accomplish this? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) | |||
Master worksheet automatically enters data into sub worksheets | Excel Discussion (Misc queries) | |||
Data From One Worksheet To Be Used In A Cell In A Different Worksheet | Excel Worksheet Functions | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
How do I collect data from an interactive web worksheet and impor. | Excel Discussion (Misc queries) |