Hello everyone,

I'm trying to run a macro with worksheet_change but I can't quite get it to work the way I wanted to.

I would copy the data from sheet 1 then paste it to sheet 2. The value in C1 in sheet 2 would be used to filter the data available in sheet 3 and to select a designated value in sheet 4 (basically a directory that would point me to).

If I type in the value in C1 in sheet 2 the macro works just fine however what i'm doing is copying the data from sheet 1 and the pasting it.

Here's what I have so far. It only does something to sheet 3 and I haven't started on sheet 4 yet.


Private Sub Worksheet_Change(ByVal Target As Range)

If Target = Range("C1") Then

Sheets("Sheet 3").AutoFilterMode = False
Sheets("Sheet 3").Columns("B").AutoFilter Field:=1, Criteria1:=Range("C1").Value, Operator:=xlOr, Criteria2:="Dept"

End If

End Sub

Thanks!