Link to home
Start Free TrialLog in
Avatar of ADRIANA P
ADRIANA PFlag for United States of America

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
Avatar of Rahul Chamala
Rahul Chamala

After you open the workbook, activate the specific worksheet

Private Sub Workbook_Open ()

Dim i as Long

'Activating NUM-M Worksheet'
Worksheets("NUM-M").Activate
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").Activate
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
Avatar of ADRIANA P

ASKER

Rahul Chamala Thanks !! Good friend ! for you fast response

im not computer skill
can you provide an sample book?
this is the last file
29045909a--1-heading.xlsm
ASKER CERTIFIED SOLUTION
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Rahul Chamala
 i will closed this question but you are welcome to help any time !!
Great JOB Expert !!