Auto filling row based on drop down list( i am open to VBA code,Vlookup, anything that will make this possible.

C

Copan1795

New Member
Joined
Mar 20, 2015
Messages
43
Hello,

What I am trying to build is a spread sheet with tasks based on the the job. I have a dropdown list in A1 with about 29 jobs.When I pick one of thoses jobs I want a list of tasks to auto fill below A2:A40. QA lab tech is from the list of jobs.below is sheet2 the jobs and the task asisned to the job. The tasks are fill words i fill the real tasks in once i know that this will work. I am open tp any ideas

sheet1
QA lab Tech

<colgroup><col style="width: 154pt; mso-width-source: userset; mso-width-alt: 7497;" width="205"><tbody>
</tbody>
Sheet2
LumperBottle WasherCapper OperatorMoens OperatorAmbec OperatorLabel InspectorJanitorFloor ScrubberBrite StackerSeamerCaserSamplesLabel Machine Operator 1Paste DeliveryFiller OperatorPackage QA InspectorLabel ClerkPackaging Relief OperaotorParts Room AttendantSanitorCook 2Label machine Operator 2Full Case Pallitizer 2QA lab Tech Forklift OperatorRecondition Lead CoordinatorWaste Water OperatorCook3Lead1Lead2
MOVINGMOVINGMOVINGMOVINGMOVINGMOVINGMOVINGMOVINGMOVINGMOVINGMOVINGMOVINGMOVINGMOVINGMOVINGMOVINGMOVINGMOVINGMOVINGMOVINGMOVINGMOVINGMOVINGMOVINGMOVINGMOVINGMOVINGMOVINGMOVINGMOVING
UPUPUPUPUPUPUPUPUPUPUPUPUPUPUPUPUPUPUPUPUPUPUPUPUPUPUPUPUPUP
DOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWN
SIDESIDESIDESIDESIDESIDESIDESIDESIDESIDESIDESIDESIDESIDESIDESIDESIDESIDESIDESIDESIDESIDESIDESIDESIDESIDESIDESIDEUPSIDE
RED RED RED RED RED RED RED RED RED RED RED RED RED RED RED RED RED RED RED RED RED RED RED RED RED RED RED RED DOWNRED
BLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKSIDEBLACK
UPUPUPUPUPUPUPUPUPUPUPUPUPUPUPUPUPUPUPUPUPUPUPUPUPUPUPUPRED UP
DOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNDOWNBLACKDOWN
SIDESIDESIDESIDESIDESIDESIDESIDESIDESIDESIDESIDESIDESIDESIDESIDESIDESIDESIDESIDESIDESIDESIDESIDESIDESIDESIDESIDEGREENSIDE
RED RED RED RED RED RED RED RED RED RED RED RED RED RED RED RED RED RED RED RED RED RED RED RED RED RED RED RED YELLOWRED
BLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKLOWBLACK
GREENGREENGREENGREENGREENGREENGREENGREENGREENGREENGREENGREENGREENGREENGREENGREENGREENGREENGREENGREENGREENGREENGREENGREENGREENGREENGREENGREENHIGHGREEN
YELLOWYELLOWYELLOWYELLOWYELLOWYELLOWYELLOWYELLOWYELLOWYELLOWYELLOWYELLOWYELLOWYELLOWYELLOWYELLOWYELLOWYELLOWYELLOWYELLOWYELLOWYELLOWYELLOWYELLOWYELLOWYELLOWYELLOWYELLOWRIGHTYELLOW
LOWLOWLOWLOWLOWLOWLOWLOWLOWLOWLOWLOWLOWLOWLOWLOWLOWLOWLOWLOWLOWLOWLOWLOWLOWLOWLOWLOWLEFTLOW
HIGHHIGHHIGHHIGHHIGHHIGHHIGHHIGHHIGHHIGHHIGHHIGHHIGHHIGHHIGHHIGHHIGHHIGHHIGHHIGHHIGHHIGHHIGHHIGHHIGHHIGHHIGHHIGHINHIGH
RIGHTRIGHTRIGHTRIGHTRIGHTRIGHTRIGHTRIGHTRIGHTRIGHTRIGHTRIGHTRIGHTRIGHTRIGHTRIGHTRIGHTRIGHTRIGHTRIGHTRIGHTRIGHTRIGHTRIGHTRIGHTRIGHTRIGHTRIGHTOUTRIGHT
LEFTLEFTLEFTLEFTLEFTLEFTLEFTLEFTLEFTLEFTLEFTLEFTLEFTLEFTLEFTLEFTLEFTLEFTLEFTLEFTLEFTLEFTLEFTLEFTLEFTLEFTLEFTLEFTALEFT
ININININININININININININININININININININININININININININBLACKIN
OUTOUTOUTOUTOUTOUTOUTOUTOUTOUTOUTOUTOUTOUTOUTOUTOUTOUTOUTOUTOUTOUTOUTOUTOUTOUTOUTOUTCOUT
AAAAAAAAAAAAAAAAAAAAAAAAAAAADA
BLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKBLACKEASTBLACK
CCCCCCCCCCCCCCCCCCCCCCCCCCCCWESTC
DDDDDDDDDDDDDDDDDDDDDDDDDDDDNORTHD
EASTEASTEASTEASTEASTEASTEASTEASTEASTEASTEASTEASTEASTEASTEASTEASTEASTEASTEASTEASTEASTEASTEASTEASTEASTEASTEASTEASTSOUTHEAST
WESTWESTWESTWESTWESTWESTWESTWESTWESTWESTWESTWESTWESTWESTWESTWESTWESTWESTWESTWESTWESTWESTWESTWESTWESTWESTWESTWESTWEST
NORTHNORTHNORTHNORTHNORTHNORTHNORTHNORTHNORTHNORTHNORTHNORTHNORTHNORTHNORTHNORTHNORTHNORTHNORTHNORTHNORTHNORTHNORTHNORTHNORTHNORTHNORTHNORTHNORTH
SOUTHSOUTHSOUTHSOUTHSOUTHSOUTHSOUTHSOUTHSOUTHSOUTHSOUTHSOUTHSOUTHSOUTHSOUTHSOUTHSOUTHSOUTHSOUTHSOUTHSOUTHSOUTHSOUTHSOUTHSOUTHSOUTHSOUTHSOUTHSOUTH
MOVINGUPDOWNSIDERED BLACKGREENYELLOWLOWHIGHRIGHTLEFTINOUTABLACKCDEASTWESTNORTHSOUTH

<colgroup><col style="width: 154pt; mso-width-source: userset; mso-width-alt: 7497;" width="205"> <col style="width: 77pt; mso-width-source: userset; mso-width-alt: 3730;" width="102"> <col style="width: 155pt; mso-width-source: userset; mso-width-alt: 7570;" width="207"> <col style="width: 86pt; mso-width-source: userset; mso-width-alt: 4205;" width="115"> <col style="width: 205pt; mso-width-source: userset; mso-width-alt: 9984;" width="273"> <col style="width: 258pt; mso-width-source: userset; mso-width-alt: 12580;" width="344"> <col style="width: 224pt; mso-width-source: userset; mso-width-alt: 10898;" width="298"> <col style="width: 48pt;" span="11" width="64"> <col style="width: 266pt; mso-width-source: userset; mso-width-alt: 12982;" span="12" width="355"> <tbody>
</tbody>


Jobs and the taskes asigned to that job on another worksheet. The job list is in A1:20 and the Tasks are in B1
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
Sort by date Sort by votes
Hi Copan1795,

Put this formula into cell A2 of Sheet1...

=HLOOKUP($A$1,Sheet2!$A$1:$AD$29,ROW(),FALSE)

...and fill down as required. You may have to alter the range in Sheet2 in the formula as well.

Regards,

Robert
 
Upvote 0
You must log in or register to reply here.

Similar threads

R
  • Question
VBA Graded Color Scale - changes based on value in another cell
Replies
2
Views
1K
RobRiotUK
R
J
  • Solved
Need Help on VBA Code to Cut or Split Cell and Copy Row Based on Commas in Cell
Replies
1
Views
305
mumps
mumps
M
  • Question
Help with FilterXML formula
Replies
0
Views
928
montex01
M
N
  • Solved
Separate One Cell Data into Multiple Rows
Replies
6
Views
595
Fluff
Fluff
C
  • Question
How to create a drop down list that will move a shape from cell to cell
Replies
2
Views
328
Cquake
C

Forum statistics

Threads
1,206,752
Messages
6,074,728
Members
446,082
Latest member
fgiron83

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top