Hello,
I need to do the following:
Being in Workbook1, activate Workbook2 which contains the data below; filter the data in Columns A to C so that only the "c"'s in column a remain ; copy only the visible data and paste it into Workbook 1.
<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
I have been unable to find a way to select the variable range to begin filtering and then apply the filter.
I have tried solutions from various sites including using DIM and Rng and trying to use that to autofilter (I run into an error with the field bit of "AutoFilter field:=1" "and attempted to modify them but my inexperience seems to be resulting in errors.
Thanks in advance for any help you can supply
I need to do the following:
Being in Workbook1, activate Workbook2 which contains the data below; filter the data in Columns A to C so that only the "c"'s in column a remain ; copy only the visible data and paste it into Workbook 1.
The number of rows that need to be filtered will vary from day to day and so will the number of "C" rows post filter. | |||||||||
Van Trip | Start | End | Orders | No. Of Orders | Lane | C/Out | Load | Van Reg. | Driver |
A | 05:00 | 08:00 | |||||||
A | 05:01 | 08:01 | |||||||
A | 05:02 | 08:02 | |||||||
B | 05:03 | 08:03 | |||||||
B | 05:04 | 08:04 | |||||||
C | 05:05 | 08:05 | |||||||
C | 05:06 | 08:06 | |||||||
C | 06:18 | 10:36 | |||||||
C | 06:21 | 10:37 |
<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
I have been unable to find a way to select the variable range to begin filtering and then apply the filter.
I have tried solutions from various sites including using DIM and Rng and trying to use that to autofilter (I run into an error with the field bit of "AutoFilter field:=1" "and attempted to modify them but my inexperience seems to be resulting in errors.
Thanks in advance for any help you can supply