Having a hidden little flaw in my Event code. Please have look at my workbook.

https://www.dropbox.com/s/pis3ctcd30...heet.xlsm?dl=0

Two sheets, with a drop down on Product sheet that refers to a named range, the range is on sheet Lot, column C (Dynamic).

The sheet Lot is the data sheet.

Select a item in the drop down and all "like" items are copied from Lot sheet to Product sheet, along with associated info.

Works almost as it should except if the item selected in the drop down is one that starts with "Talking". If code worked correctly there should be 4 "Talking" entries brought from Lot sheet to Product.

Instead, the entire list from Lot is copied to Product(minus the fourth Talking item). That should be some sort of clue, but does not register with me.

Select any other item and all those "like" items are copied correctly.

There are groups of Radio Controlled, Remote Controlled, Radio Button and the misbehaving group Talking Clock.

I'm probably looking right at it but I ain't seeing it.

Thanks,

Howard

Hi Howard,

Am Wed, 18 Nov 2015 06:04:54 -0800 (PST) schrieb L. Howard:

https://www.dropbox.com/s/pis3ctcd30...heet.xlsm?dl=0

please have a look
https://onedrive.live.com/redir?resi...=folder%2cxlsm
for "Copy" and download the file


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Hi Howard,

Am Wed, 18 Nov 2015 06:04:54 -0800 (PST) schrieb L. Howard:

https://www.dropbox.com/s/pis3ctcd30...heet.xlsm?dl=0

I guess I misunderstood your problem.
If you want to look for a substring you have to change the values in
Item_Desc
Please have another look for the workbook "Copy" in OneDrive. I improved
my mistake.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Hi Claus,

Thanks for taking a look.

Two things, first I need the entire contents of the Lot sheet column C values, and second I also need all instances of say "Talking..." or "Radio Controlled..."
etc.

So if I select any Radio Button... entry in the drop down, then there should be 5 Radio Button entries copied to Product instead of just the one selected. That would be Lot sheet rows 16, 17, 18, 19, 20 and all content for the C column cells and the resized cells also.

It looks like you split the contents at the number embedded in the text, but those are just numbers to help me identify the individual entries, to be sure the correct ones are being copied.

Howard

Hi Howard,

Am Wed, 18 Nov 2015 09:22:24 -0800 (PST) schrieb L. Howard:

So if I select any Radio Button... entry in the drop down, then there should be 5 Radio Button entries copied to Product instead of just the one selected. That would be Lot sheet rows 16, 17, 18, 19, 20 and all content for the C column cells and the resized cells also.

did you look for the improved workbook?


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

On Wednesday, November 18, 2015 at 9:44:29 AM UTC-8, Claus Busch wrote:
Hi Howard,


did you look for the improved workbook?


Hi Claus.

Yes, much closer. The groups seem to be working but don't want any subsets within the text.

The copies from Lot sheet to Product should look like the one in my linked workbook. Need ALL the text from C column cells when copied over to Product sheet.

Also need ALL C column entries in the drop down.

Matching the Left(xxx, 7) of the drop down and the C column cells seems to be a workable and again not looking for any subsets.

Howard

Hi Howard,

Am Wed, 18 Nov 2015 09:59:02 -0800 (PST) schrieb L. Howard:

Yes, much closer. The groups seem to be working but don't want any subsets within the text.

The copies from Lot sheet to Product should look like the one in my linked workbook. Need ALL the text from C column cells when copied over to Product sheet.

please have another look in OneDrive


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Hi Claus,

I just reviewed my original sheet and I am screwed up.

The values coming to Product are ended at the numbers I use for reference. There is a carriage return in each cell and it seems to be only the upper text string.

Not sure what to do with that.

The return should look much like the test string shown in my drop down, pretty long and way past the number that are mid way.

???
Howard

Hi Claus,

Please put a halt to this post.

I need to get the facts and stuff better sorted out.

I need to review what the actual out come is exactly supposed to be.

I have myself confused right now.

Sorry.

I'll post back if I get my ducks in a row.

Howard

Hi Claus,

I was able to fix what I thought was the a problem. Mostly lost track of what the sheet was supposed to be doing.

This works as I was shooting for.

https://www.dropbox.com/s/cldxiv88yw...v1 .xlsm?dl=0

With a drop down in B4, select an entry and "Like" values from sheet Lot are assembled to Product.

I am not sure, but you probably offered a solution as such and I was mixed up on what it should be.

Very sorry for the rat race post.

Thanks.

Howard

Hi Howard,

Am Wed, 18 Nov 2015 12:39:30 -0800 (PST) schrieb L. Howard:

This works as I was shooting for.

https://www.dropbox.com/s/cldxiv88yw...v1 .xlsm?dl=0

you have all product in the validation list. Many of them are almost the
same with only a small difference. If there are more products in the
sheet you lose track of thiings.
Please look he
https://onedrive.live.com/redir?resi...=folder%2cxlsm
for "Copy"
That is a suggestion with shorter and unique values in the validation
list.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional