RRJha, I want to be able run a macro where i can select a combo of five numbers that are found in columns A,B,C,D,E on row 44, upon selecting these numbers it will select the range of numbers in column J45 to N79. the number 14 will be first number to be found after row 44 in this range and is to record it where it appears next for ex: K46 but instead of recording the actual row and and column it will record as B2 and place it to the right on the column T 46. http://ge.tt/3HbnWnn/v/0?c
Welcome back.I have downloaded the file and I am looking at it now...
It is not clear which data is part of the original file and which data you have plugged in to explain the question. So first I will need the file that has ON:LY the original data "as is" before the macro is run (without showing any results or instructions). Could you send me that file please
http://ge.tt/5XEaLon/v/0?c ok here is the link. thanks
the link is not pulling up with what you had went ahead and done
also i stated that the user selects A 44 through E 44. then macor wil select the data in columns J 45 and N 79. it will run a search for ex: the number 14 selected in A 44 will be found in k46, this will be recorded not as k46 but the range that is selected will have hidden template range of A1 to E35. so will be recorded B2.
it searches each number in selected A44 B44 C44 D44 E44 from the range of data down one row J45 through N79. as stated above the 14 was search and first one found was in the K46 so then the macro goes to the next number in B44 which is 15 which is found on K45 but will be recorded as B1.
your not telling me if you understand my question, i dont want to happen what happened last time I had paid double for the one question because you went ahead and set up program before asking the details. that is why i am requesting another tutor. thanks
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
Ok, should I clear the output range S45 to W79 before the macro is run? It means you would loose outputs from previous search.
yes that was just to show the visual. so everytime a select a combo it find the number and label acording to where it would be on this range. so when i go down to select another combo this range would drop down a row , so it follows what i do.
ok let me know if you need more information, thanks
ok it works! but please put the result of first number in s44 then the result for the second number in t44 and so on; so it reads left to right as apposed to being scattered. thanks good work!
ok I did, if i selected the 5th combo down then the ABCDE should be one row down from that so everytime i select a combo each combo has its own ABCDE. then place the results on the right where you had placed them so one line as not to be scattered. thanks.
ok good! I downloaded it, and ran it, now can you enable this so I can use on the entire list of combos? iask cause i went to the very bottom and it came up with menu saying end or debug. then this will be complete. thanks
ok, thanks :)
ok doing it now
ok doing it now, it works! do you see how i left space above when i enter new data
i should be able to run though data i add from row 42 to 1. so everytime i get new data i can run this macro not just on old data. thanks
ok ill do that now, if i run out of space above can i cut data and paste lower as to leave room above for new data and run macro?
ok, good thanks! When I have more questions I will send them to you. Good job! thank you :)
ok, just need to post payment and tip and leave rating. Thanks Again!