N
newguy
I have a Master Sheet (Data Insert) that is used as a form. It fills
in the corresponding worksheets based on the Date that the user inputs.
The last sheet in my workbook (Detail) is a summary of the inputed
Data sorted by Date on Row 2. I need to have it so when the user
inputs the data on the Data Insert worksheet it looks to that Detail
sheet looks for the matching Date in Row 2 Selects that column and
fills in that column.
Dim Input AS Worksheet
Dim Detail AS Worksheet
Dim sDate As Variant
Input = Worksheet("Data Insert")
Detail = Worksheet("Detail")
sDate = Input.Range("c2").Value
Now this is what I dont know how to do
Select Column From Detail Where Cell.Value = sDate
As when starting a Variable what type can be used to represent a Column?
in the corresponding worksheets based on the Date that the user inputs.
The last sheet in my workbook (Detail) is a summary of the inputed
Data sorted by Date on Row 2. I need to have it so when the user
inputs the data on the Data Insert worksheet it looks to that Detail
sheet looks for the matching Date in Row 2 Selects that column and
fills in that column.
Dim Input AS Worksheet
Dim Detail AS Worksheet
Dim sDate As Variant
Input = Worksheet("Data Insert")
Detail = Worksheet("Detail")
sDate = Input.Range("c2").Value
Now this is what I dont know how to do
Select Column From Detail Where Cell.Value = sDate
As when starting a Variable what type can be used to represent a Column?