Results 1 to 6 of 6

Macro to move data from one sheet to multiple sheet

Threaded View

  1. #1
    Registered User
    Join Date
    09-25-2012
    Location
    abu dhabi
    MS-Off Ver
    Excel 2010
    Posts
    28

    Macro to move data from one sheet to multiple sheet

    Hi

    I am having a shared file in which multiple users shall input the data in the sheet "Allocate". I need a macro to move the data when they submit the button "Allocate" to the respective sheets based on the criteria selected from the drop down list " Jan 2015" or "Feb 2015" etc. The users can enter the data in any of the rows in the column(B:N) and it can be single row or multi rows.
    I have attached the sample file better understanding
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 11-15-2019, 02:57 AM
  2. [SOLVED] Macros To Move Multiple Rows To Another Sheet And Macro To Move Single Rows To DAX Table
    By jcaynes in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-22-2013, 05:08 PM
  3. [SOLVED] macro to auto copy data from multiple sheet to one master sheet
    By roger556 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-30-2012, 01:52 AM
  4. [SOLVED] Move data from one sheet to multiple sheets
    By aznan79 in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 10-11-2012, 11:13 PM
  5. Replies: 2
    Last Post: 10-09-2012, 04:40 PM
  6. How to write macro for copy data from multiple sheet to a single sheet.
    By Santoshmoni in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-16-2011, 04:39 AM
  7. Need macro to copy data from sheet 1 to multiple pages on sheet 2 in correct cells
    By iturnrocks in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-16-2009, 03:33 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