View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
hotherps[_23_] hotherps[_23_] is offline
external usenet poster
 
Posts: 1
Default Need help with an array

Tom, first off let me thank you for helping me out. I really want t
learn this type of coding but is a little out of my reach at th
moment. I'm attaching a copy of the file I'm working in in there ther
are 3 tabs One that has the result of my code, one with yours and th
original data for copying over if nessecary.

I got a strange result on yours. It only added numbers to a few of th
locations, in most cases it looks like the PA and PPI string have bee
joined without the location number?

Probably my fault by not exoplaining it correctly. If you look at m
tab, as each person is assigned a location my numbers increment. Th
problem is the increment too much and begin repeating themselves. Th
main goal is to assign all of the given locations per column withou
repeating a location number in the same column.

Thank you very much Tom for your assistance I'm really stranded here a
th emoment.

:

--
Message posted from http://www.ExcelForum.com