Forum

@Hans Hallebeek, Thanks again. I just have no clue why it is saving BOTH of these files. I am sure it must be something simple, but I just cannot...

@Hans Hallebeek, I made the modifications per your suggestion. However, I am still encountering one challenge. The file is saving in BOTH the ind...

@Hans Hallebeek, I made a change, and now what happens it BOTH my Audit file with the correct name generated from the cell values AND the template ...

@Hans Hallebeek, This past week has been all kinds of crazy! and 4 new projects dumped on me that required completion yesterday! Okay I will look...

@Hans Hallebeek, Sorry about that. First the Dropdown menus are currently in the sample file as they exist in my live file. The dropdown options ...

@Cedric McKeever, Yes, problem has been solved. I marked your post as "Answered Post". Thanks again for all your help!!

@Riny van Eekelen & @Cedric McKeever, Thanks so much, I really appreciate all your help. I just could not figure this out as it was not a "sta...

@Riny van Eekelen, I was just attempting to walk thru the steps in your query so I could understand what you did. I need to convert it to the form...

@Riny van Eekelen, That is exactly what I was trying to create! But I simply had no clue as to how to create a query such as this. One final ques...

@Riny van Eekelen, The issue is that the entitles column contains multiple. It is possible that the records lists entities that are not on our lis...

@Hans Hallebeek, I honestly don't know if it will work on my live data. I tried to use the macro on a copy of my workbook, and I just had the "spi...

@Hans Hallebeek, I am somewhat new to VBA and do not understand how to debug and step thru the code as of yet. Attached is a sample file. I left...