I am stuck. I am trying to get my spreadsheet to move to/select a row, based upon a selection either through combo box or drop down list (customer 1, customer 2, etc.). Each customer has a table of data that needs to be displayed. A pivot table will not work in this circumstance. I just cannot get my macro quite correct. Can someone please help? Working with Excel 2007. I do not know how to load an image from a URL. ?? Please help me out here! Thanks in advance..
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Trying to select/jump to A row based upon "list selection" or combo box: PLEASE ASSIST
- Thread starter wilsol4
- Start date
Michael M
Well-known Member
- Joined
- Oct 27, 2005
- Messages
- 21,834
- Office Version
- 365
- 2019
- 2013
- 2007
- Platform
- Windows
In that case you will need to provide some more details of what you want.
Also, have a look at my tag and use the HTML Maker to enable you to paste a sample of your data back here, or upload your workbook to a hosting site like dropbox or mediafire, then post a link to that site back here.
Keep in mind though that a lot of posters (like me) can't / won't visit external sites.
Also, have a look at my tag and use the HTML Maker to enable you to paste a sample of your data back here, or upload your workbook to a hosting site like dropbox or mediafire, then post a link to that site back here.
Keep in mind though that a lot of posters (like me) can't / won't visit external sites.
Upvote
0
I have a large spreadsheet with 5 sets of data, all in a list. Each has a header, Diamond, Noble, Hercules, Transocean and Rowan. I am trying to find a way to jump to each dataset by making a selection at the TOP of the spreadsheet. I do not mind how the data is selected: either drop down or combo (or other method if you know better solution). But after making the selection, my estimators need to jump to the data set, without having to scroll through potentially 1,000 lines of data to get to the customer they want. Thank you for your help.
Upvote
0
| SELECT CUSTOMER PAINT SYSTEM BELOW: | -- removed inline image --- | combo box | ||||||||||
| Diamond | ||||||||||||
| Diamond | ||||||||||||
| Percent waste = | 0.3 | |||||||||||
| K 9.1A - System 1A -DECKS (pipe racks, mud house roofs, mud sacks decks, walways, etc) | ||||||||||||
| Coat | Product | Film Thickness per coat | % Solids | SF / Gal (theoretical) | SF / Gal (30% waste) | $/Gallon | $/SF | Total System Price/SF | ||||
| wet | Dry | |||||||||||
| 1st | Jotomastic 80 Aluminum | 8 | 6 | 80 | 214 | 149.8 | $ 22.71 | $ 0.15 | $2.14 | |||
| Stripe | Jotamastic 80 Green | 8 | 6 | 80 | 214 | 149.8 | $ 22.71 | $ 0.15 | 1 | |||
| 2nd | Jota Armour Gray | 45 | 45 | 90 | 36 | 25.2 | $ 42.77 | $ 1.70 | ||||
| 3rd coat | Hardtop XP | 4 | 3 | 63 | 337 | 235.9 | $ 31.98 | $ 0.14 | ||||
| K 9.1B - System 1B - DECKS (where 91.a not required, most interior decks | ||||||||||||
| Coat | Product | Film Thickness per coat | % Solids | SF / Gal (theoretical) | SF / Gal (30% waste) | $/Gallon | $/SF | Total System Price/SF | ||||
| wet | Dry | |||||||||||
| 1st | Jotomastic 80 Aluminum | 8 | 6 | 80 | 161 | 112.7 | $ 22.71 | $ 0.20 | $0.93 | |||
| Stripe | Jotamastic 80 Green | 8 | 6 | 80 | 161 | 112.7 | $ 22.71 | $ 0.20 | 2 | |||
| 2nd | Jotamastic 80 Buff -(mix w/) Joda anti skid($21.38) | 8 | 6 | 80 | 161 | 112.7 | $ 44.09 | $ 0.39 | ||||
| 3rd coat | Hardtop XP Grey 4218 | 5 | 3 | 68 | 337 | 235.9 | $ 31.98 | $ 0.14 | ||||
| Noble | ||||||||||||
| 1604.00 | ||||||||||||
| 10.1.A - Hull Below Waterline (preferred system) | ||||||||||||
| Coat | Product | DFTR | % Solids | Coverage/Gal @ 1 mil | Theoretical SF per DFTR | Paint $ per Gallon | Thinner $ per gallon | Total $/Gal | SF/G (30% waste) | $ per SF | Total PRICE / SF | |
| Prime | Interzone 954 Buff, Red Oxide or White; stripe coat applied wet on wet | 12 | 85 | 1363.00 | 113.58 | $ 37.30 | $ - | $ 37.300 | 113.58 | $ 0.33 | $ 0.67 | |
| Finish | Interzone 954 Black | 12 | 85 | 1363.00 | 113.58 | $ 38.49 | $ - | $ 38.490 | 113.58 | $ 0.34 | ||
| Finish | Interfine 979 Color C-936 Noble Blue | 6 | 76 | 1219.00 | 203.17 | $ 87.00 | $ - | $ 87.000 | 203.17 | $ 0.43 | ||
| HERCULES | ||||||||||||
| BOP - (Hand and Power Tools) | ||||||||||||
| Coat | Product | Film Thickness per coat | % Solids | Coverage/Gal @ 1 mil | SF / Gal (theoretical) | SF / Gal (30% waste) | $/Gallon | Thinner $/Gal | Total $/Gal | $/SF | ||
| wet | Dry | |||||||||||
| Full | Carbozinc 11 Green | 5.0 | 3.0 | 62% | 0 | 0 | 0 | $ 44.00 | $ - | $ 44.00 | #DIV/0! | |
| Transocean | ||||||||||||
| Area 1: Submerged areas, Splash Zones, Jack up Legs & Spud Cans - (all systems) | ||||||||||||
| Coat | Product | DFTR | % Solids | Coverage/Gal @ 1 mil | Theoretical SF per DFTR | Paint $ per Gallon | Thinner $ per gallon | Total $/Gal | SF/G (30% waste) | $ per SF | Total PRICE / SF | |
| Full | Amercoat 4069 deck screed | 80.0 | 68% | 0 | 0.00 | $ 22.51 | $ - | $ 22.51 | 0.00 | #DIV/0! | ||
| Full | Amercoat 450 Series | 2.0 | 67% | 0 | 0.00 | $ 33.55 | $ - | $ 33.55 | 0.00 | #DIV/0! | ||
| ROWAN | ||||||||||||
| 1604 | ||||||||||||
| System 1A: Hull Bottom Plate - Polyurethane finish | ||||||||||||
| Full | Interthane 990 | 3.0 | 57% | 0 | 0.00 | $ 29.05 | $ - | $ 29.050 | 0.00 | #DIV/0! |
Upvote
0
| SELECT CUSTOMER PAINT SYSTEM BELOW: | -- removed inline image --- | combo box | Drop Down Selections | ||||||
| Diamond | Diamond | ||||||||
| List Selection | Noble | ||||||||
| Hercules | |||||||||
| Transocean | |||||||||
| Rowan | |||||||||
| Diamond | |||||||||
| K 9.1A - System 1A -DECKS (pipe racks, mud house roofs, mud sacks decks, walways, etc) | |||||||||
| Coat | Product | Film Thickness per coat | % Solids | SF / Gal (theoretical) | SF / Gal (30% waste) | ||||
| wet | Dry | ||||||||
| 1st | Jotomastic 80 Aluminum | 8 | 6 | 80 | 214 | 214 | |||
| Stripe | Jotamastic 80 Green | 8 | 6 | 80 | 214 | 214 | |||
| 2nd | Jota Armour Gray | 45 | 45 | 90 | 36 | 36 | |||
| 3rd coat | Hardtop XP | 4 | 3 | 63 | 337 | 337 | |||
| K 9.1B - System 1B - DECKS (where 91.a not required, most interior decks | |||||||||
| Coat | Product | Film Thickness per coat | % Solids | SF / Gal (theoretical) | SF / Gal (30% waste) | ||||
| wet | Dry | ||||||||
| 1st | Jotomastic 80 Aluminum | 8 | 6 | 80 | 161 | 161 | |||
| Stripe | Jotamastic 80 Green | 8 | 6 | 80 | 161 | 161 | |||
| 2nd | Jotamastic 80 Buff -(mix w/) Joda anti skid($21.38) | 8 | 6 | 80 | 161 | 161 | |||
| 3rd coat | Hardtop XP Grey 4218 | 5 | 3 | 68 | 337 | 337 | |||
| Noble | |||||||||
| 1604.00 | |||||||||
| 10.1.A - Hull Below Waterline (preferred system) | |||||||||
| Coat | Product | DFTR | % Solids | Coverage/Gal @ 1 mil | Theoretical SF per DFTR | Paint $ per Gallon | |||
| Prime | Interzone 954 Buff, Red Oxide or White; stripe coat applied wet on wet | 12 | 85 | 1363.00 | 113.58 | $ 37.30 | |||
| Finish | Interzone 954 Black | 12 | 85 | 1363.00 | 113.58 | $ 38.49 |
Upvote
0
Similar threads
- Question
- Question
- Solved
