hi, thanks for responding to my question, I appreciate it. the code should work like this, I select the data A44,B44,C44,D44,E 44, when I do this the range J45, N79 is the area in which the number will be found. for ex: A44 is the number 14 it will search in the range J45 to nN79 omitting the the J44,K44,L44,M44,N44. it will see the number 14 ( the first one it finds only beginning from the top below the selected number) and record it not as K46 but record it as B2 and this will be placed in the T46. Then the search for 15 will be found in k45 but will record it as B1 to T45. and so on until 5 numbers are recorded.
when you look on the workbook in the columns S T U V W You'll see the A B C D E 1-35 in each. this is just to use as a visual but when setting up program you can delete only the A B C D E 1-35 in the columns S
T U V W, This will be the hidden name of the range and this range will slide down a row below the selected number to be found in the range in J,K,L,M,N. I will be adding data in the spaces above so I want to be able to use this macro to allow me to shift the data to make more room and still work flawlessly. let me know if you can do this thanks