+ Reply to Thread
Results 1 to 5 of 5

Transferring information to multiple worksheet in the same workbook using a drop down list

Hybrid View

  1. 11-04-2013, 04:35 PM #1
    ExcelGigs
    ExcelGigs is offline
    Registered User
    Join Date
    11-04-2013
    Location
    USA
    MS-Off Ver
    Excel 2007 and 2010
    Posts
    4

    Question Transferring information to multiple worksheet in the same workbook using a drop down list

    Hi! I started a new job and am dealing with a worksheet that I have to copy paste the same information into multiple worksheets. I have created a master workbook in which I want to have equations that link to the different locations automatically and hide the equations so they cannot be changed or viewed but still allow input in the cell if possible. In my "working" worksheet I have created a drop down that shows the different locations that I want the information to transfer to. What I also would like to do is have the information transfer when an option is selected. For example, if I need an offer to also be shown on the homepage then I would select the location "Row1 Offer1" in the drop down for homepage placement and I would need cells B7:F7 to copy over to the cells in the homepage tab. All the cells have the same headings so they can literally copy over in the same order but I don't know how to get it over without a long nested equation for every option. There is also a tab called ATG promos that would carry over information that I select "Y" in the drop down list. I know this sounds crazy and I hope I'm explaining it well. I have attached the file for reference. My working tab is the "Regular Banners" and the ones I need the information to carry over to is the "Homepage", "Super Banners" and "ATG Promos". You will see the drop down lists I created in columns r,s,t to select the information to be transferred to each area. I would appreciate any help you can offer. I have been researching this for two weeks now on and off using Google and haven't had much luck. Thank you so much for all your help!!!
    Attached Files Attached Files
    Last edited by ExcelGigs; 11-05-2013 at 01:55 PM.
    Reply With QuoteRegister To Reply
  2. 11-06-2013, 09:18 AM #2
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Transferring information to multiple worksheet in the same workbook using a drop down

    I am not seeing the working worksheet in your sample file.
    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]
    Reply With QuoteRegister To Reply
  3. 11-06-2013, 01:07 PM #3
    ExcelGigs
    ExcelGigs is offline
    Registered User
    Join Date
    11-04-2013
    Location
    USA
    MS-Off Ver
    Excel 2007 and 2010
    Posts
    4

    Re: Transferring information to multiple worksheet in the same workbook using a drop down

    Thank you for your quick response arlu1201! The working sheet is the one labeled "regular banners". Is it not there?
    Reply With QuoteRegister To Reply
  4. 11-13-2013, 10:50 AM #4
    ExcelGigs
    ExcelGigs is offline
    Registered User
    Join Date
    11-04-2013
    Location
    USA
    MS-Off Ver
    Excel 2007 and 2010
    Posts
    4

    Re: Transferring information to multiple worksheet in the same workbook using a drop down

    Workbook Template in Progress.xlsxI am reloading the file in case there were any issues. I have attempted several things with formulas but I'm still not getting it right. I just need the information to copy over if a certain selection is chosen from the drop down list in the Regular Banners tab. I would really appreciate any help/advice I can get. Thank you all for your time!!
    Reply With QuoteRegister To Reply
  5. 11-25-2013, 06:21 AM #5
    ExcelGigs
    ExcelGigs is offline
    Registered User
    Join Date
    11-04-2013
    Location
    USA
    MS-Off Ver
    Excel 2007 and 2010
    Posts
    4

    Exclamation Re: Transferring information to multiple worksheet in the same workbook using a drop down

    I have researched some more and still can't seem to find a solution. I have simplified the workbook to make it easier to manage. I am working off one worksheet(Office Supplies Regular Banners). At the end of each row there are drop down lists to indicate additional location for those offers. If the Homepage Location is marked as "Rotator 1" I would like the information in cells B7:F7 to automatically show in B6:F6 for Rotator 1 of the Homepage tab. I want to do the same thing for Super Banner where if the drop down list indications Row 1 Offer 1 it transfers B7:F7 into B6:F6 in Row 1 Offer 1 row in the Super Banners tab. In the ATG Promos if Office Supplies 1 is selected I just want C7(the offer) to go into A14.

    Since the drop down list can change based on different selections, I was trying different equations to basically get it to say if the drop down list indicates x location then copy Bx:Fx into those cells. These are the equations I was trying based on some information I found. They are not transferring over the information so I'm not sure if these are the best type of formulas.
    =MATCH("Rotator 2",'Office Supplies Regular Banners'!R6:R216,'Office Supplies Regular Banners'!B6:B216)
    =SUM(INDEX('Office Supplies Regular Banners'!B6:F246,MATCH("Rotator 3",'Office Supplies Regular Banners'!R6:R246,0),))
    =INDEX('Office Supplies Regular Banners'!B6:F246,MATCH(TRUE,INDEX("Rotator 4",'Office Supplies Regular Banners'!R6:R246,),0))

    I hope this makes sense a little more. I am just looking for a way for the information to transfer over to all the individual worksheets without copy pasting everything a bunch of times. I would appreciate any help I can get!!
    Attached Files Attached Files
    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. [SOLVED] Taking information from worksheet and transferring it to Userform textboxes
    By Spritz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-04-2013, 12:08 PM
  2. Transferring information from a master worksheet into secondary worksheets.
    By NFregia in forum Excel General
    Replies: 2
    Last Post: 04-05-2012, 12:35 PM
  3. Transferring Data from Userform Listbox to Drop-down list in Worksheet
    By f5awp in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-30-2011, 12:22 AM
  4. Transferring information from multiple sheets into 1 sheet
    By kazi1212 in forum Excel General
    Replies: 0
    Last Post: 08-16-2010, 12:27 PM
  5. Drop Down List isn't transferring in new row
    By sratkins in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-31-2008, 01:42 PM

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