+ Reply to Thread
Results 1 to 2 of 2

Transfer Data from one sheet to Another Using VBA

  1. #1
    Registered User
    Join Date
    10-10-2012
    Location
    Mumbai
    MS-Off Ver
    Excel 2003
    Posts
    51

    Transfer Data from one sheet to Another Using VBA

    Hi Friends,

    I got an error "Procedure Too Large" when i run a macro in below attached file:

    I have Two Sheet, Working & September 2015. In Working sheet you will find the table which have date, stream name (Case Initiation (EAD-AP/STEM) etc & Associate Name (Vijay, Jaffar, Aniket, etc)

    In September 2015 you will find the same table which is there in Working sheet, but here date wise.

    I have a Button Transfer Data to transfer data from Working sheet to September 2015 sheet basis on date. If you change the date it will transfer the date to a particular date table.

    Now when i clicked on Transfer Data button, it give me an error "Procedure Too Large". This is the urgent can anyone help me out in this thing.

    Regards,
    HD
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor Kamboj's Avatar
    Join Date
    09-25-2014
    Location
    India
    MS-Off Ver
    2003 - 2010
    Posts
    430

    Re: Transfer Data from one sheet to Another Using VBA

    because this is a large procedure but you can put your code into 2 or 3 procedure and you can call them into this macro.
    Kamboj
    _________________________________________________________________________________
    Mark the thread as SOLVED if my answer satisfy you.

+ 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] Issue regarding recorded Macro to transfer data from Input sheet to Storage sheet
    By Hirad001 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-29-2015, 04:26 PM
  2. Replies: 5
    Last Post: 12-30-2014, 12:41 PM
  3. Transfer data from input sheet to data sheet by using command button
    By vinh1985 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-17-2014, 12:17 AM
  4. Replies: 5
    Last Post: 02-09-2014, 08:29 PM
  5. How to transfer data from a daily input sheet to a separate monthly total sheet
    By Jcooper71 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-25-2014, 02:37 PM
  6. Replies: 1
    Last Post: 03-11-2013, 05:37 AM
  7. Replies: 1
    Last Post: 02-13-2013, 01:32 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