In the example their are 5 columns each populated from seperate Tables (tables are not shown for simplicity see the explanation of the formulas used). I would like to produce 1 unique dynamic list of the manufacturers displayed in the data.
Jim O
In the example their are 5 columns each populated from seperate Tables (tables are not shown for simplicity see the explanation of the formulas used). I would like to produce 1 unique dynamic list of the manufacturers displayed in the data.
Jim O
Last edited by JO505; 06-11-2015 at 05:42 PM.
Hello Jim,
With Vba?
Please Login or Register to view this content.
Last edited by HSV; 06-07-2015 at 05:49 PM.
Kind regards, Harry.
Harry,
Thank you for the response. I ran the code as written and it works fine on the example. I then tried to adapt it to my actual file (not shown for file size) and I have a problem Error 400.
The code below shows the changes I tried.
The columns I am using are BE, BH, BK, BN, and BQ which should be 56, 59, 63, 66 and 69. The column for my result is BT or column 72.
When I run this code I
Jim OPlease Login or Register to view this content.
Please refer to attachment
Hello Jim,
I can't reproduce it.
There was a small mistake in the code.
Perhaps this code works better.
Please Login or Register to view this content.
I think I may have stumbled on an issue with this.
The columns 57, 60, 63, 66 and 69 are populated using an Index/Match formula. I don't know if this should be a problem or not but, using the first code I have a sheet that works fine with that code unless I populate a column with the Index/Match formula, then I get a popup window error 400. If I remove the formulas it works just fine.
Jim O
Try this.
Please Login or Register to view this content.
HSV,
That appears to do the trick. If I run into any other issues I will post again.
Thank you very much for your time and expertize with this.
Jim O
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks