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,


Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Watch MrExcel Video

Forum statistics

Latest member

This Week's Hot Topics