jordanburch
Active Member
- Joined
- Jun 10, 2016
- Messages
- 440
- Office Version
- 2016
Hey Guys,
I have looked at other threads but just cant seem to figure it out
Range("ao2:ao6000").SpecialCells(xlCellTypeVisible).Formula = "=+MATCH(RC[-1],'MAY FY20 IDARRS'!C[6],0)"
I have the above formula I am trying to replace the MAY FY20 IDARRS with
ThisWorkbook.Worksheets("Variables").Range("A7").Value & " " & ThisWorkbook.Worksheets("Variables").Range("A3").Value & " IDARRS"
I have what the variables are below.
data_wbk3 = Right(data_wbk2, 5)
'ThisWorkbook.Worksheets("Variables").Range("A2").Value = data_wbk3
'data_wbk1 = "FY" & Right(data_wbk3, 2)
ThisWorkbook.Worksheets("Variables").Range("A3").Value = data_wbk1
data_wbk7 = Left(data_wbk3, 3)
'ThisWorkbook.Worksheets("Variables").Range("A7").Value = data_wbk7
data_wbk2 = InputBox("Enter month I.E. 08-MAY20", Default:="08-MAY20")
'ThisWorkbook.Worksheets("Variables").Range("A1").Value = data_wbk2
any help is greatly appreciated!
Jordan
I have looked at other threads but just cant seem to figure it out
Range("ao2:ao6000").SpecialCells(xlCellTypeVisible).Formula = "=+MATCH(RC[-1],'MAY FY20 IDARRS'!C[6],0)"
I have the above formula I am trying to replace the MAY FY20 IDARRS with
ThisWorkbook.Worksheets("Variables").Range("A7").Value & " " & ThisWorkbook.Worksheets("Variables").Range("A3").Value & " IDARRS"
I have what the variables are below.
data_wbk3 = Right(data_wbk2, 5)
'ThisWorkbook.Worksheets("Variables").Range("A2").Value = data_wbk3
'data_wbk1 = "FY" & Right(data_wbk3, 2)
ThisWorkbook.Worksheets("Variables").Range("A3").Value = data_wbk1
data_wbk7 = Left(data_wbk3, 3)
'ThisWorkbook.Worksheets("Variables").Range("A7").Value = data_wbk7
data_wbk2 = InputBox("Enter month I.E. 08-MAY20", Default:="08-MAY20")
'ThisWorkbook.Worksheets("Variables").Range("A1").Value = data_wbk2
any help is greatly appreciated!
Jordan