Table Search -> Copy/Paste Code


New Member
Jun 18, 2017
Hey all,

I'm new to VBA coding and not quite sure where to start with this project nor do I know if it is 100% doable.

Below is a image for an overview of what my data looks like:
Imgur: The most awesome images on the Internet

What I'm trying to accomplish:

A table in the "Monthly Cals" worksheet that has data copy/pasted from "Master Sheet" data.

We have 494 instruments in our lab and they are required to be calibrated on a specific monthly cycle - 3, 6, 9, or 12 months. Each month I would like to be able to pull all necessarily calibrations into one sheet with less effort then filtering one-by-one in columns J:M.

I started with a PivotTable and soon realized that it as well would not let me filter multiple columns of data -- for example after I filter "First Cal" it shortens the list and when I try to filter "Second Cal" at this point it will show no data due to the fact that July will not be in both columns at once.

What I would like the code to do:

I would like the code to search columns J:M for a specific monthly value that I set - Jul for example. The code would search through the table in "Master Sheet" and then copy/paste all entries that match into a new table in "Monthly Cals". I'm not sure the easiest way to allow for user entry, whether it be Button/User Form or have a [Search:] ["enter value"] in A1:A2 on the "Monthly Cals" sheet. If it is possible to run the code using the computers internal calendar that would be fine as well. I'm open for ideas or possibilities here.

Any help would be great as I'm completely new to VBA coding and don't know quite where to start from.

Thank you in advance for any help,


Forum statistics

Latest member

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...