Macro loop through table and create lsit on a different sheet

[mkron]

Hello,

I am trying to create a macro to loop through a table with 3 columns and create a list of drawing numbers on another sheet based on if the other 2 columns are equal to specific cells.

I do not know how to code in VBA but this is what I would expect it to set the steps to be.


Sub DWG_FINDER()

r = range(TableL[DWG])
Row = 3

For i in r:
----if TableL[LH] == Sheet1!C26:
-------->if TableL[RH] == Sheet1!D26:
------------>worksheet(Sheet1!).Cells(row, 8).value(Table[DWG])
------------>Row = Row + 1
-------->End If
----End If

End Sub


Thank you very much and any feedback/tips on how to learn VBA would be greatly appreciated!
-MK

 

[Fazza]

have you looked at excel's advanced filter? ALT-D-F-A
maybe these help

Introduction to Excel Advanced Filters - What are they & How to use them | Chandoo.org - Learn Microsoft Excel Online
http://www.contextures.com/xladvfilter01.html

and there is a macro recorder. ALT-T-M-R to get you started

to learn VBA will depend on what works best for you. for me a great book - one (there is basically a version for each Excel version) of John Walkenbach's Power Programming titles

 

[mkron]

I was able to figure it out with a few YouTube videos and forum posts.
Thanks for the resources!

 

[Fazza]

congrats, MK. well done