 |
 Wide Angle Lens 043x X Canon 40D T3i 5D Mark II 1100D T2i 550D plus Macro $29.53 Time Remaining: 1d 1m |
 Vintage Tempo Plus Macro Camera Lenses SET Of 2 $49.99 Time Remaining: 18d 17h 28m Buy It Now for only: $49.99 |
 Rolev 52mm macro close up +2 plus 2 lens filter $6.00 Time Remaining: 6d 3h 54m Buy It Now for only: $6.00 |
 Sigma EX DC plus Macro 18 mm 50 mm F 28 Lens For Pentax $265.99 Time Remaining: 1d 3h 47m Buy It Now for only: $335.99 |
 Nice Zykkor Super Wide 042x with Macro Lens plus caps $30.00 Time Remaining: 26d 5h 19m Buy It Now for only: $30.00 |
 Wide Angle Lens 043x X Canon 40D T3i 5D Mark II 1100D T2i 550D plus Macro $29.54 Time Remaining: 1d 22h |
 NIKON TAMRON 70 300mm f4 56 LD TELE MACRO LENS 90 DAY WARRANTY EXCELLENT PLUS $139.95 Time Remaining: 19d 1h 31m Buy It Now for only: $139.95 |
 Wide Angle Lens 043x X Canon 40D T3i 5D Mark II 1100D T2i 550D plus Macro $29.54 Time Remaining: 2d 22h |
 New Tiffen 48mm +2 close up macro filter plus 2 Inv142 $4.99 Time Remaining: 6d 49m Buy It Now for only: $4.99 |
 MINOLTA MD MOUNT 80 200MM F4 MACRO 14 KIRON LENS EXCELLENT PLUS CONDITION $14.99 Time Remaining: 3d 5h 13m |
 New Tiffen 48mm +1 close up macro filter plus 1 Inv141 $4.99 Time Remaining: 6d 49m Buy It Now for only: $4.99 |
 TAMRON AF 18 200MM F35 56 MACRO LD IF FOR PENTAX EXCELLENT PLUS COND $102.00 (4 Bids) Time Remaining: 3d 5h 28m |
 Tiffen Photar Series VI 6 Plus 2 +2 Close Up Macro Lens Filter Used $6.00 Time Remaining: 6d 19h 14m Buy It Now for only: $6.00 |
 NEW NOS Telesar Japan 48mm plus 20 +20 close up or macro camera lens filter $18.00 Time Remaining: 28d 3h 11m Buy It Now for only: $18.00 |
 Wide Angle Lens 043x X Canon 40D T3i 5D Mark II 1100D T2i 550D plus Macro $29.57 Time Remaining: 4d 8m |
 Series 5 Enteco +1 close up macro filter plus 1 Inv143 $8.99 Time Remaining: 6d 49m Buy It Now for only: $8.99 |
 Wide Angle Lens 043x X Canon 40D T3i 5D Mark II 1100D T2i 550D plus Macro $29.56 Time Remaining: 4d 38m |
 Olympus 80 200mm One Hand Tele Zoom w Auto Diaphragm Plus Macro 91 $79.90 Time Remaining: 26d 22h 19m Buy It Now for only: $79.90 |
 Wide Angle Lens 043x X Canon 40D T3i 5D Mark II 1100D T2i 550D plus Macro $29.59 Time Remaining: 4d 22h 3m |
 ASIAN 49MM 3PC CLOSE UP CAMERA LENS SET PLUS +10 MACRO $19.95 Time Remaining: 15d 21h 8m Buy It Now for only: $19.95 |
 Wide Angle Lens 043x X Canon 40D T3i 5D Mark II 1100D T2i 550D plus Macro $29.58 Time Remaining: 4d 22h 33m |
 NIKON 35 135mm f35 45 Ai S MACRO ZOOM 90 DAY WARRANTY EXCELLENT PLUS COND $119.95 Time Remaining: 24d 6h 34m Buy It Now for only: $119.95 |
 Wide Angle Lens 043x X Canon 40D T3i 5D Mark II 1100D T2i 550D plus Macro $29.60 Time Remaining: 5d 22h 15m |
 QUANTARAY 52 mm Macro Filters +1 and +2 Plus Their Case Made in Japan $9.99 Time Remaining: 8d 7h 52m Buy It Now for only: $9.99 |
 Hoya 55mm Macro Lens Filter Set +1 +2 +4 Plus 52mm to 55mm Step up Ring Mint $39.99 Time Remaining: 8d 16h 58m Buy It Now for only: $39.99 |
 Wide Angle Lens 043x X Canon 40D T3i 5D Mark II 1100D T2i 550D plus Macro $29.61 Time Remaining: 5d 22h 45m |
 Nikon Micro Zoom 70 180 mm F 45 56 D AF ED Lens Macro Excellent Plus $1,718.98 Time Remaining: 28d 14h 35m Buy It Now for only: $1,718.98 |
 CANON MACRO FD 50MM 50 MM F 35 LENS PLUS 2X FD TELECONVERTER CAPS MINTY $99.95 Time Remaining: 6d 8h 5m Buy It Now for only: $124.95 |
 Canon EF L Macro USM 180 mm F 35 Lens with hood and case Excellent Plus $1,248.98 Time Remaining: 5d 31m Buy It Now for only: $1,248.98 |
 Wide Angle Lens 043x X Canon 40D T3i 5D Mark II 1100D T2i 550D plus Macro $29.62 Time Remaining: 6d 21h 50m |
 CANON ZOOM FDn 70 210mm f40 MACRO ZOOM LENS 90 DAY WARRANTY EXCELLENT PLUS $59.95 Time Remaining: 22d 6h 20m Buy It Now for only: $59.95 |
 Wide Angle Lens 043x X Canon 40D T3i 5D Mark II 1100D T2i 550D plus Macro $29.63 Time Remaining: 6d 22h 11m |
 Olympus OM Bellow Plus OM 80mm F4 Macro Lens Mint+ $799.95 Time Remaining: 3d 19h 12m Buy It Now for only: $799.95 |
How do I create a search tool (macro?) in an excel worksheet?
I am trying to create a little tool in excel to help some of the guys I work with find tools that they use. I have all the tools listed by name and location across a few pages of an excel worksheet. I want to create a front page which will have a field to be filled out to enter the tool name you are looking for, then you press 'search', and the tool location will be given in a seperate field on the same page (plus project name and any other required data).
Does this require a macro, and if so how do you do them, as I haven't got a clue. Any help would be greatly appreciated!!
you might want to use the find method. I have put below a link of using the Find method in a macro.
Adjust image warping using Image-Pro Plus software