Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Retrieve text from filter data in workbook 1 and place values in 2
What would be a good way to get data from a text range in workbook1 for only
rows that meet a criteria. When I filter the data in workbook1 and then do a copy paste I get the unfiltered rows between the selected rows. The macro to do this was recorded as I did it step by step. Please help. I'm new to Basic but was a programer in other languages. Thanks, RHall -- none |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Retrieve text from filter data in workbook 1 and place values in 2
I filtered a list, copied the filtered rows and pasted them. I got only the
filtered rows. No unfiltered rows. Excel 2007. Perhaps I'm misunderstanding what you're trying to do. "RHall" .(donotspam) wrote in message ... What would be a good way to get data from a text range in workbook1 for only rows that meet a criteria. When I filter the data in workbook1 and then do a copy paste I get the unfiltered rows between the selected rows. The macro to do this was recorded as I did it step by step. Please help. I'm new to Basic but was a programer in other languages. Thanks, RHall -- none |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Retrieve text from filter data in workbook 1 and place values in 2
You really don't need a macro for this.
Select the filtered data, then hit <F5 to get the "GoTo" dialog box. Click on "Special", then "Visible Cells Only", then <OK. Right click in the selection and choose "Copy", and then navigate to where you would like to paste. If you do this often enough, there is an icon you can place on your toolbar to make this easier yet. Right click on the toolbar and choose "Customize". Under the "Commands" tab, In the left window, click on "Edit", In the right window, scroll down to the bottom, where the next to last icon is "Select Visible Cells". Click and drag it to your toolbar. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "RHall" .(donotspam) wrote in message ... What would be a good way to get data from a text range in workbook1 for only rows that meet a criteria. When I filter the data in workbook1 and then do a copy paste I get the unfiltered rows between the selected rows. The macro to do this was recorded as I did it step by step. Please help. I'm new to Basic but was a programer in other languages. Thanks, RHall -- none |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Retrieve Excel Workbook | Excel Worksheet Functions | |||
Retrieve values from 2 worksheets. | Excel Worksheet Functions | |||
Link Protected WorkBook ... and Get #N/A for Text Values! | Excel Discussion (Misc queries) | |||
How do I copy text and values from the same workbook onto a different sheet?? | Excel Discussion (Misc queries) | |||
filter data from 10+workbooks and display in separate workbook? | Excel Discussion (Misc queries) |