Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy filterto workbook
Hi
THe basic funtionality I'm after is that of the autofilter. Except I want to be able to copy the first 10 columns and then the column with my criteria value + five more columns to a new workbook. To make it even more complicated I have 12 columns of criteria data each seperated by five coumns af copy data. Not all rows in the filter columns ar filled. To top this off I wolud like to add both sets (5+5 column) to the new workbook. I have tried messing around with Rons escellent examples (from http://www.rondebruin.nl/copy5.htm and another example submitted by John http://tinyurl.com/aqg55) but I can't get it working. I get no walues to the new workbooks except the creteria column, and the headers in the first row. Please helt - I'm somewhat new to VBA! Thanks! /Sunw |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy filterto workbook
Do you have a version of Ron's code working that copies the entire row that you
need? If yes, then how about just adding a few more lines of code that delete the columns you don't want from the new worksheet? Sometimes, copying everything and cleaning up a little bit is easier than copying smaller ranges lots of times. Sune Fibaek wrote: Hi THe basic funtionality I'm after is that of the autofilter. Except I want to be able to copy the first 10 columns and then the column with my criteria value + five more columns to a new workbook. To make it even more complicated I have 12 columns of criteria data each seperated by five coumns af copy data. Not all rows in the filter columns ar filled. To top this off I wolud like to add both sets (5+5 column) to the new workbook. I have tried messing around with Rons escellent examples (from http://www.rondebruin.nl/copy5.htm and another example submitted by John http://tinyurl.com/aqg55) but I can't get it working. I get no walues to the new workbooks except the creteria column, and the headers in the first row. Please helt - I'm somewhat new to VBA! Thanks! /Sunw -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to copy an image (or picture) from one workbook to a new sheetin another workbook | Excel Worksheet Functions | |||
Excel-how to link source workbook to copy of destination workbook | Excel Worksheet Functions | |||
Copy cells based on conditions in one workbook to another workbook | Excel Worksheet Functions | |||
Copy Data from Workbook into specific Worksheet in other Workbook? | Excel Discussion (Misc queries) | |||
Copy a range of cells in an unopened workbook and paste it to the current workbook | Excel Programming |