Attached are images. Base is what the master sheet looks like. Find is using the find function. With is using with function.
I have tried these sequences and was unsuccessful.
Essentially I have a master list and I want to find information of (07b3, 07c9, etc.) from column c. I then want to copy the entire rows containing 07b3 into the 07b3 worksheet (same with 07c9). I would like to make it all one button if possible, i.e. click the macro and it auto-populates data from sheet("Master") to the corresponding sheets. If need be I can deal with multiple macro buttons to run this.
Once I have the general code format I can fill in the etc. I am just stuck on the initial format.
Thanks in advance.
I have tried these sequences and was unsuccessful.
Essentially I have a master list and I want to find information of (07b3, 07c9, etc.) from column c. I then want to copy the entire rows containing 07b3 into the 07b3 worksheet (same with 07c9). I would like to make it all one button if possible, i.e. click the macro and it auto-populates data from sheet("Master") to the corresponding sheets. If need be I can deal with multiple macro buttons to run this.
Once I have the general code format I can fill in the etc. I am just stuck on the initial format.
Thanks in advance.