ADRIANA P
asked on
look up Num 3 all
need query column G location 7
and show 13 set coulmns L , M , N
in sheet NUM-M and NUM-M_VER
29045909--1-.xlsm
and show 13 set coulmns L , M , N
in sheet NUM-M and NUM-M_VER
29045909--1-.xlsm
ASKER
Rahul Chamala Thanks !! Good friend ! for you fast response
im not computer skill
can you provide an sample book?
im not computer skill
can you provide an sample book?
ASKER
this is the last file
29045909a--1-heading.xlsm
29045909a--1-heading.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Rahul Chamala
i will closed this question but you are welcome to help any time !!
i will closed this question but you are welcome to help any time !!
ASKER
Great JOB Expert !!
Private Sub Workbook_Open ()
Dim i as Long
'Activating NUM-M Worksheet'
Worksheets("NUM-M").Activa
MsgBox "Value at G7 is " & Range("G7").Value
'Getting values from row 2 to 13 for column L
For i = 2 To 13
MsgBox "Value at Row" & i "and column L is" & Cells(i, "L").Value & vbNewLine
Next i
MsgBox & vbNewLine ' New Line
'Getting values from row 2 to 13 for column M
For i = 2 To 13
MsgBox "Value at Row" & i "and column M is" & Cells(i, "M").Value & vbNewLine
Next i
MsgBox & vbNewLine
'Getting values from row 2 to 13 for column N
For i = 2 To 13
MsgBox "Value at Row" & i "and column N is" & Cells(i, "N").Value & vbNewLine
Next i
MsgBox & vbNewLine
'Activating NUM-M_Ver worksheet
Worksheets("NUM-M_Ver").Ac
MsgBox "Value at G7 is " & Range("G7").Value
For i = 2 To 13
MsgBox "Value at Row" & i "and column L is" & Cells(i, "L").Value & vbNewLine
Next i
MsgBox & vbNewLine ' New Line
For i = 2 To 13
MsgBox "Value at Row" & i "and column M is" & Cells(i, "M").Value & vbNewLine
Next i
MsgBox & vbNewLine
For i = 2 To 13
MsgBox "Value at Row" & i "and column N is" & Cells(i, "N").Value & vbNewLine
Next i
MsgBox & vbNewLine
End Sub