+ Reply to Thread
Results 1 to 10 of 10

Macro needed to copy data from master sheet to a number of specific sheets

  1. #1
    Registered User
    Join Date
    02-02-2014
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    54

    Macro needed to copy data from master sheet to a number of specific sheets

    I am looking for a macro which will copy data from a mastersheet (basically a refresh from Essbase based on country selected from a dropdown list). I have a number of tabs for each country. I need the data from the mastersheet to then be copied to specific country tab. I have attached a simplified workbook which should help me. So I have the 'Engine' tab which is the essbase download. I have a dropdown menu on the mastersheet (Engine) for countries, based on which I get the data. If I pick France and get the data for France, I want the data to populate the 'France' tab. Worksheet layout is going to be the same for the Master sheet as well as for country tabs.


    Appreciate any help on this. Thank you.

    Krish
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    07-11-2012
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    144

    Re: Macro needed to copy data from master sheet to a number of specific sheets

    Hi krish2503 ,

    Here is your solution please see the attachment.

    Attachment:Fshbet Copy to other Sheet.xlsm
    Ravikumar,

    * Please Add Reputation if solved.

  3. #3
    Registered User
    Join Date
    02-02-2014
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    54

    Re: Macro needed to copy data from master sheet to a number of specific sheets

    Hi Fshbet,

    Thanks for the quick response. That's awesome. Is it possible to have the cells copied across as values rather than copy formulae across as well.

    Rgds

    Krish

  4. #4
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,803

    Re: Macro needed to copy data from master sheet to a number of specific sheets

    Try this code
    Please Login or Register  to view this content.
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  5. #5
    Registered User
    Join Date
    02-02-2014
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    54

    Re: Macro needed to copy data from master sheet to a number of specific sheets

    Hi Yasser, Thanks for that...works well. I will run it tomorrow on my actual file at office and will come back if there are any issues. Thanks to you and Fshbet for the quick response.

  6. #6
    Forum Contributor
    Join Date
    07-11-2012
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    144

    Re: Macro needed to copy data from master sheet to a number of specific sheets

    HI Yasser,

    Please change the last line to
    Please Login or Register  to view this content.
    this will paste only values not all.

  7. #7
    Registered User
    Join Date
    02-02-2014
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    54

    Re: Macro needed to copy data from master sheet to a number of specific sheets

    Thanks, Fshbet. Will work out both options at office and let you know if I run into any problems or if I need any further tweakings.

  8. #8
    Registered User
    Join Date
    02-02-2014
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    54

    Re: Macro needed to copy data from master sheet to a number of specific sheets

    Hi all...apologies as I got pulled into other projects and this one took a back seat. Now I am back taking a look at the above issue. To recount, I am looking for a macro which will help copy data from the master sheet to a number of specific sheets. The macros provided by Ravi(fshbet) and Yasser worked absolutely fine..thanks for that. However I need a further tweak. The macros provided by Yasser and fshbet require me to pick a country from the dropdown list and then it populates that particular country's tab with the data. I now want the macro to be iterative i.e. pick the first country in the dropdown menu on the 'Engine' tab, copy the data to that country's tab, then pick the second country from the dropdown menu and copy that data to the second country's tab and so on until there are no more countries in the drop down menu. I am attaching the file. I have included a 'data' tab to put some numbers into the 'Engine' tab but in reality, the data on the 'Engine'tab will be a retrieval from Essbase (I can plug in the essbase retrieval macro wherever necessary). So the way the template works is
    1. pick first country from dropdown list
    2. refresh data from essbase
    3. copy data (only values)to that country's tab
    4. go to Country 2 on the dropdown list
    5. refresh data
    6. copy data (values) to the second country's tab....and so on until the last country in the dropdown menu is reached.
    Could really do with some help from the aces.
    Thanks
    Attached Files Attached Files

  9. #9
    Forum Contributor
    Join Date
    07-11-2012
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    144

    Re: Macro needed to copy data from master sheet to a number of specific sheets

    Hi krish2503,

    Copy to other Sheet Macro.xlsm

    Check the attached file.

  10. #10
    Registered User
    Join Date
    02-02-2014
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    54

    Re: Macro needed to copy data from master sheet to a number of specific sheets

    Hi fshbet,

    Thank you so much for your help. The macro worked fine. Really appreciate your help and the quick turn around.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] [Urgent] Creating a Macro to Copy Time sheets Data of employees into Master Sheet
    By kkcmania in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-12-2014, 01:12 AM
  2. [SOLVED] VBA / Macro help needed to create separate sheets from Master sheet by year
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-09-2013, 08:34 AM
  3. [SOLVED] Macro to combine specific sheets into master sheet
    By JakubPrchal in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-16-2012, 08:34 AM
  4. [SOLVED] Macro to copy data from multiple sheets to one (new) master sheet
    By nhtodd in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-24-2012, 02:30 AM
  5. Search Macro Needed
    By O0J0E in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-15-2012, 11:19 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1