I have a file that has a set value on Sheet 1 Cell A1.
Sheet 2 contains a table of data that is updated from a separate file, so each time the first file is opened, the data is updated.
Row 3 of sheet 2 contains a list of table column headings. One column (3) needs to be filtered to only show the value on Sheet1, Cell A1. It's a simple Filter operation (clear filter and filter again) to update Sheet 2's values.
I want to find out if this filter operation can be performed automatically each time i open the file - either with a Macro or VB script.
Thanks
Sheet 2 contains a table of data that is updated from a separate file, so each time the first file is opened, the data is updated.
Row 3 of sheet 2 contains a list of table column headings. One column (3) needs to be filtered to only show the value on Sheet1, Cell A1. It's a simple Filter operation (clear filter and filter again) to update Sheet 2's values.
I want to find out if this filter operation can be performed automatically each time i open the file - either with a Macro or VB script.
Thanks