Adjust VBA code to work with more data

[sy898661]

Hi!!

I have this code (from an Excel Forum user so you know its good!!!! ) that creates a unique list from a main table and brings that and another connected column into a new table. When it is bringing over one source of data (from the main table) it works fine, but when there is multiple sources of data (in the main table) it stops working. What I mean is pretty much the list of data is just longer... but won't work

Here's the portion of code -- the line in RED is the line that I keep getting an error message one "1004: The extract range has a missing or invalid field name"

Please Login or Register  to view this content.

I know there isn't much context and I am so sorry for that, I'm hoping someone can read/understand this without looking at the file. I cannot share the data and creating a mock version would be a little difficult (but if absolutely needed of course I will try), but hopefully someone can just notice what's going on! Ahh!


I can share the full code of what this comes from if needed but will have to change the names of some variables.

Thanks in advance!

Update: someone in my company was able to help me (I was having a hard time taking all the IP out of my file to post on here) but I will make a comment with the new code in case anyone was interested!

[CEO76]

my guess is the ListObjects("MasterBOM2") has ony one column and you try to copy column 2

[sy898661]

The table has 15+ columns, that's what I thought the issue was at first too like I had put the wrong number or whatever but it works when I do it with a shorter list! It's really weird

[CEO76]

Can you load the file?

[sy898661]

Someone in my company--a truly amazing excel-guru--was able to help write me a new code that works better with my new data!!! I tried fixing my file to not show IP but it was damn near impossible without ruining the file for everyone else to understand.
Attachment 631691