Hi All,
I am new to VBA and I am looking for some help to complete the following tasks in Excel 365. As you can see my template has 3 tabs which will work together to create the information that I require. The tabs include: 1. InputScreen, 2. Search Template, 3. Raw Data Dump.
Once I have input all of the required information into the InputScreen Tab I am looking to automate the following tasks in VBA:
1. Generate an advance filter search in the Search Template based on a raw data search from the Raw Data Tab
2. Copy the search results into a new tab at the end of the sheets
3. Rename the new tab to the name of the cell referenced from the InputScreen tab
4. Update the formula reference to the next cell on the Input Screen within the Search Template and generate a new Advance filter search
5. Create a do loop or If loop to repeat this process over and over again based on search data within the InputScreen until the cell is empty.
Please see the file attached for an indication of what I am trying to do. I have attached some of the VBA code that I am prepared to set the stage but it is pretty basic.
Any guidance that you can provide would be great.
ExceloratorAdam
Bookmarks