+ Reply to Thread
Results 1 to 9 of 9

Copying a specific Row from another sheet depending on a cell value

  1. 09-18-2013, 11:14 AM #1
    OAKLEY
    OAKLEY is offline
    Registered User
    Join Date
    09-27-2012
    Location
    Northampton, England
    MS-Off Ver
    excel 2016
    Posts
    64

    Copying a specific Row from another sheet depending on a cell value

    hello - im hoping someone will be able to help me!

    on one sheet within my workbook I have a column with the week numbers in then the other columns with the working days date in - so for instance the first row is - week 40, 30/09/2013, 01/10/2013, 02/10/2013, 03/10/2013, 04/10/2013 and then the next row is week 41 etc.

    so what I want on my working sheet is - one cell I select from a drop down list (kind of irrelevant!) the week number - and I want the rest of that row to display the dates for that week.

    im sure there must be some easy formula to do this but just cannot work it out!

    Be glad of someones help! MANY THANKS!
    Reply With QuoteRegister To Reply
  2. 09-18-2013, 11:47 AM #2
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Copying a specific Row from another sheet depending on a cell value

    Try this.

    In A1 of your result sheet put the drop down list. Then in B1 and copy across, use this.

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.
    Reply With QuoteRegister To Reply
  3. 09-18-2013, 12:09 PM #3
    Ursul
    Ursul is offline
    Forum Contributor
    Join Date
    08-14-2013
    Location
    Here and there
    MS-Off Ver
    Excel 2010
    Posts
    376

    Re: Copying a specific Row from another sheet depending on a cell value

    Hey working on Fotis1991 suggestion I have attached a sample for you:

    Week Dates.xlsx
    Reply With QuoteRegister To Reply
  4. 09-18-2013, 12:28 PM #4
    Gandalf2524
    Gandalf2524 is offline
    Registered User
    Join Date
    09-04-2013
    Location
    richardson, tx
    MS-Off Ver
    Excel 20037
    Posts
    28

    Re: Copying a specific Row from another sheet depending on a cell value

    Fontis1991, Ursul

    Looks like the $ is misapplied in the array index of the INDEX() command. I believe the code should read 
    Please Login or Register  to view this content.
    gandalf2524
    Reply With QuoteRegister To Reply
  5. 09-19-2013, 03:35 AM #5
    OAKLEY
    OAKLEY is offline
    Registered User
    Join Date
    09-27-2012
    Location
    Northampton, England
    MS-Off Ver
    excel 2016
    Posts
    64

    Re: Copying a specific Row from another sheet depending on a cell value

    Book2.xlsxMany thanks both of you.....however - its just returning 0 at the moment? I may have done something wrong!
    I have attached the sheet with the example in - u can see on sheet named September - in B5 is the drop down list of the weeks and then I want the date to appear below the days.
    many thanks
    Reply With QuoteRegister To Reply
  6. 09-19-2013, 03:43 AM #6
    OAKLEY
    OAKLEY is offline
    Registered User
    Join Date
    09-27-2012
    Location
    Northampton, England
    MS-Off Ver
    excel 2016
    Posts
    64

    Re: Copying a specific Row from another sheet depending on a cell value

    sorry - please ignore last post! I have done it!!
    many thanks Ursul for the working example
    Reply With QuoteRegister To Reply
  7. 09-19-2013, 03:44 AM #7
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Copying a specific Row from another sheet depending on a cell value

    Hi

    Same suggestion. See the example pls.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  8. 09-19-2013, 03:48 AM #8
    Debraj Roy
    Debraj Roy is offline
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: Copying a specific Row from another sheet depending on a cell value

    or may be without referring sheet2...

    =($B$5-1)*7+DATE(2013,1,-1)+COLUMN(A1)
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...
    Reply With QuoteRegister To Reply
  9. 09-19-2013, 03:52 AM #9
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Copying a specific Row from another sheet depending on a cell value

    As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED,as per Forum Rule #9. Thank you.

    Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro problem - copying specific cell's from one sheet to another
    By Mrgud in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-12-2012, 02:27 PM
  2. Copying specific cell ranges from a worksheet multiple times to a new sheet
    By kaz8772 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-10-2009, 03:54 PM
  3. copying data from one sheet to another sheet depending on critirea.
    By pvk296 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-12-2009, 04:48 PM
  4. copying cell values to specific area in sheet
    By Reinder in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-12-2007, 09:55 AM
  5. [SOLVED] Open specific sheet depending on cell contents
    By monkey harry in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-02-2006, 11:50 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1