VBA Copy and Paste if specific criteria into master sheet

[jmurray394]

Hi!

I could really use some VBA help since I’m very much a beginner. I have a workbook that has a master worksheet and 13 subsequent tabs. The master tab lists the names of people working in my department from columns A – P. The 13 tabs that follow all have the same layout of two columns: the person’s name and purchase their responsible for. I’m trying to get it where the code goes through each tab and if it comes across a specific criteria (the person’s name in Column A) it will then automatically copy the purchase type (Column B Value) and paste it under their name in the master sheet.

 

[Rijnsent]

Hi J,
that sounds like a simple macro challenge to start with, how far did you get yourself? Please post the code you wrote here (as this site is not a free coding service). This is some code that could help you (untested):

Sub LoopSheetsEtc
Set Wb=ActiveWorkbook
For each Sht in Wb.Worksheets
  LastRw = Sht.Range("A1").End(XlDown).Row
  For Rw = 1 to LastRw
    ...
  Next Rw
Next Sht
End Sub

And if you want to learn a bit more, try e.g. recording a macro or following a course like Excel VBA Programming - a free course for complete beginners , VBA Training | Wise Owl etc.
Cheers,
Koen