Hello and thank you in advance for your help. I am new to excel. I need to allow a user to enter 5 sotre number and then click a button. Once the button is clicked, the program needs to look at each record the user entered and find all the relevant data in a different worksheet and copy it to a designated worksheet.
Sheet1: (user enters)
a1
123
456
789
Sheet2: (Data)
a b c d
123 alksfhalskdf kjhklhlkjh klhkljhkljhk
123 alksfhalskdf kjhklhlkjh klhkljhkljhk
456 alksfhalskdf kjhklhlkjh klhkljhkljhk
789 alksfhalskdf kjhklhlkjh klhkljhkljhk
999 alksfhalskdf kjhklhlkjh klhkljhkljhk
999 alksfhalskdf kjhklhlkjh klhkljhkljhk
789 alksfhalskdf kjhklhlkjh klhkljhkljhk
888 alksfhalskdf kjhklhlkjh klhkljhkljhk
RESULTS: (Differetn worksheet)
a b c d
123 alksfhalskdf kjhklhlkjh klhkljhkljhk
123 alksfhalskdf kjhklhlkjh klhkljhkljhk
456 alksfhalskdf kjhklhlkjh klhkljhkljhk
789 alksfhalskdf kjhklhlkjh klhkljhkljhk
789 alksfhalskdf kjhklhlkjh klhkljhkljhk
Hope this is pretty straighforward....THANK YOU!
Bookmarks