+ Reply to Thread
Results 1 to 6 of 6

Excel 2007 : How to Fill multiple Colums in worksheet A from Worksheet B using a list with titles?

  1. #1
    Registered User
    Join Date
    05-17-2012
    Location
    McConnellsburg, PA
    MS-Off Ver
    Excel 2007
    Posts
    3

    How to Fill multiple Colums in worksheet A from Worksheet B using a list with titles?

    We have a bi-weekly timesheet in excel that we need to enter our daily work activities from a list of 33 types of activities. Each activity has a 4 column set of codes stored on the codes sheet that needs to be entered into the timesheet for our budgeting department to know where the funding comes. Manual entry and even copy and paste from one worksheet to another is resulting in many errors. I want to create a look up list that will allow the user to pick the work type and have the 4 columns fill in automatically from the codes sheet.

    I tried using Data Validation but I can't seem to fill more than one column at a time and I want al 4 to fill with one selection .... Any ideas how to do this?

    Thanks!

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: How to Fill multiple Colums in worksheet A from Worksheet B using a list with titles?

    Hi, and welcome to the forum.

    Difficult to comment without seeing your system in detail but it sounds like you should be using data validation to select the work type and then use VLOOKUP() formulae in the other four columns.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: How to Fill multiple Colums in worksheet A from Worksheet B using a list with titles?

    Do you have a sample file that you can attach?

    To Attach a File:

    1. Click on Go Advanced.
    2. In the frame Attach Files you will see the button Manage Attachments
    3. Click the button.
    4. A new window will open titled Manage Attachments - Excel Forum.
    5. Click the Browse... button to locate your file for uploading.
    6. This will open a new window File Upload.
    7. Once you have located the file to upload click the Open button. This window will close.
    8. You are now back in the Manage Attachments - Excel Forum window.
    9. Click the Upload button and wait until the file has uploaded.
    10. Close the window and then click Submit.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  4. #4
    Registered User
    Join Date
    05-17-2012
    Location
    McConnellsburg, PA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: How to Fill multiple Colums in worksheet A from Worksheet B using a list with titles?

    Attached is the file that I am working with.
    Attached Files Attached Files

  5. #5
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: How to Fill multiple Colums in worksheet A from Worksheet B using a list with titles?

    Its very simple. Put these formulae -
    In F5 =IF($E5="","",VLOOKUP($E5,Codes!$A$11:$E$44,2,0))
    In G5 =IF($E5="","",VLOOKUP($E5,Codes!$A$11:$E$44,3,0))
    In I5 =IF($E5="","",VLOOKUP($E5,Codes!$A$11:$E$44,5,0))

    Drag down as required. If you do not want them to touch the formulae, password protect the 3 columns.

  6. #6
    Registered User
    Join Date
    05-17-2012
    Location
    McConnellsburg, PA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: How to Fill multiple Colums in worksheet A from Worksheet B using a list with titles?

    Oh that is awsome ... I knew it should be simple but I just couldn't put the pieces together in help. Thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1