I am new to posting so hopefully this is clear.
I am writing a macro in Excel 2010 that will copy a value from a list on one sheet and paste it into a pivot table filter in the next sheet. I need this to loop until it reaches the bottom of the list and the list will be different values each time. As I have it now, It will not continue after the first several I recorded and it is bringing the specific values into the code so when the values change it uses the original value in the code.
Any help would be awesome.