Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy rows to another worksheet
I have a worksheet of data that I would like to have the row contents copied
to another worksheet if the contents of column O = "XX". This is done several times a week every week so I am not sure how to write the formula and save it so it is available to any open workbook. The worksheets are not a consistent size. They usually go from 300 to 1000 rows of data. Any help would be appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy rows to another worksheet
You can record a macro and reuse it later...
Start recording macro and do the following; Data-Auto Filter Filter on 'XX' on Col O Data-Go To-Select Visible Cells only Edit-Copy Go to the other sheet Paste the rows copied Stop recording Dave Peterson answered elsewhere about how to add a toolbar so that your macros are available to you _______________ For additions to the worksheet menu bar, I really like the way John Walkenbach does it in his menumaker workbook: http://j-walk.com/ss/excel/tips/tip53.htm or http://spreadsheetpage.com/index.php...g_custom_menus Here's how I do it when I want a toolbar: http://www.contextures.com/xlToolbar02.html (from Debra Dalgleish's site) _______________ "GeorgeR" wrote: I have a worksheet of data that I would like to have the row contents copied to another worksheet if the contents of column O = "XX". This is done several times a week every week so I am not sure how to write the formula and save it so it is available to any open workbook. The worksheets are not a consistent size. They usually go from 300 to 1000 rows of data. Any help would be appreciated. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy rows to another worksheet
Hi,
For instances like this, please use Advanced filters. They are very well explained in the Help menu -- Regards, Ashsih Mathur Microsoft Excel MVP www.ashishmathur.com "GeorgeR" wrote in message ... I have a worksheet of data that I would like to have the row contents copied to another worksheet if the contents of column O = "XX". This is done several times a week every week so I am not sure how to write the formula and save it so it is available to any open workbook. The worksheets are not a consistent size. They usually go from 300 to 1000 rows of data. Any help would be appreciated. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy rows to another worksheet
Hi GeorgeR
Try this add-in http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "GeorgeR" wrote in message ... I have a worksheet of data that I would like to have the row contents copied to another worksheet if the contents of column O = "XX". This is done several times a week every week so I am not sure how to write the formula and save it so it is available to any open workbook. The worksheets are not a consistent size. They usually go from 300 to 1000 rows of data. Any help would be appreciated. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy rows to another worksheet
THank you Ron
"Ron de Bruin" wrote: Hi GeorgeR Try this add-in http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "GeorgeR" wrote in message ... I have a worksheet of data that I would like to have the row contents copied to another worksheet if the contents of column O = "XX". This is done several times a week every week so I am not sure how to write the formula and save it so it is available to any open workbook. The worksheets are not a consistent size. They usually go from 300 to 1000 rows of data. Any help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet - Copy rows | Excel Discussion (Misc queries) | |||
Copy rows to another worksheet | Excel Discussion (Misc queries) | |||
Copy Rows With Same Value into a new Worksheet | Excel Discussion (Misc queries) | |||
copy rows to another worksheet | Excel Worksheet Functions | |||
How do I NOT copy hidden rows to a new worksheet? | Excel Discussion (Misc queries) |