View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default INSTR find copy sheet to sheet issue

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