Advanced filters.
Hello there,
I have a file with 3 sheets.
1 - Has a combobox linked up to a list of 'names', then a rows (assigned to
dates) and columns (assigned to values and calculations).
2 - Has all the data in rows by name, date and then the values.
3 - Is blank at the moment.
I want to set up an advanced filter that will copy the rows to sheet 3 if
and when the name in sheet 2 rows matches the name selected in the combobox.
Is there a simple way and I am being too dim?
|