+ Reply to Thread
Results 1 to 7 of 7

Alter Code for Copy and Paste of Data to Created New Sheets.

  1. 05-04-2014, 06:24 PM #1
    Ortz
    Ortz is offline
    Registered User
    Join Date
    09-15-2011
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    82

    Alter Code for Copy and Paste of Data to Created New Sheets.

    Hello Everyone.

    I have used VBA code found on another thread within this great site for use with a Workbook I use at work.

    I was hoping someone would be able to help with tweaking the code for me as my knowledge of VBA is very limited.

    I have attached a sample workbook that usually contains about 600-700 entries a month.

    The code works ok but is anyone able to alter it so that the created sheets only have the data from columns A to I. At the moment the first 3 sheets also includes the data from Column L which I would prefer not to be present, and I have no idea why that is.

    Help would be very much appreciated.

    Many Thanks

    Ortz
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-04-2014, 07:33 PM #2
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Alter Code for Copy and Paste of Data to Created New Sheets.

    Hi Ortz

    Replace this line of Code 
    Please Login or Register  to view this content.
    with this 
    Please Login or Register  to view this content.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
    Reply With QuoteRegister To Reply
  3. 05-04-2014, 07:43 PM #3
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,463

    Re: Alter Code for Copy and Paste of Data to Created New Sheets. 

    Please Login or Register  to view this content.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  4. 05-04-2014, 07:49 PM #4
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,463

    Re: Alter Code for Copy and Paste of Data to Created New Sheets.

    Oh, and the reason that the first three sheets include column L is that column L will have visible cells when the AutoFilter selects the first three members of staff. That's because the unique entries output from the Advanced Filter will go down to row 8, so includes John, Peter and Michael but not the others because the unique list rows will all be hidden.


    Slight improvement on the code:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 05-04-2014, 08:38 PM #5
    Ortz
    Ortz is offline
    Registered User
    Join Date
    09-15-2011
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    82

    Re: Alter Code for Copy and Paste of Data to Created New Sheets.

    Thanks TMS and Jaslake, they both do what I needed. That was so quick.

    Very much appreciated and thanks for the help

    Ortz
    Reply With QuoteRegister To Reply
  6. 05-04-2014, 08:57 PM #6
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,463

    Re: Alter Code for Copy and Paste of Data to Created New Sheets.

    You're welcome. Thanks for the rep.
    Reply With QuoteRegister To Reply
  7. 05-04-2014, 10:32 PM #7
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Alter Code for Copy and Paste of Data to Created New Sheets.

    You're welcome...glad I could help. Thanks for the Rep.
    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. Code to place code into newly created sheets???
    By brucemc777 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-29-2014, 11:52 AM
  2. [SOLVED] Copy and paste cells of relative position ,then copy to others w'o alter
    By lokwungkwung in forum Excel General
    Replies: 14
    Last Post: 10-29-2013, 01:09 PM
  3. [SOLVED] VBA Code to copy data from one sheet and paste to multiple other sheets
    By JimmyG. in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-17-2013, 04:25 AM
  4. copy sheets (with exception) and paste with line break (have code)
    By Armitage2k in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2009, 03:11 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