+ Reply to Thread
Results 1 to 5 of 5

Create, Copy, Paste to multiple Worksheets

  1. #1
    Registered User
    Join Date
    05-02-2009
    Location
    Eagan, MN
    MS-Off Ver
    Excel 365
    Posts
    59

    Create, Copy, Paste to multiple Worksheets

    I get a report every month that I have to manipulate before I send it out to the managers and would like to use a macro to automate. Attached is a shortend file that comes to me, I then have to create a tab for each catagory in column "C" and copy the entire line of information to that tab along with the header in row 1.
    Attached Files Attached Files
    Last edited by MSchibs; 10-20-2011 at 05:14 PM.

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Create, Copy, Paste to multiple Worksheets

    Do you copy mutiple lines where there are more than one line in each category?

  3. #3
    Registered User
    Join Date
    05-02-2009
    Location
    Eagan, MN
    MS-Off Ver
    Excel 365
    Posts
    59

    Re: Create, Copy, Paste to multiple Worksheets

    Yes, all of the "Brake" sales have to go on the tab that is created for that catagory.

  4. #4
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Create, Copy, Paste to multiple Worksheets

    This should do the trick

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    05-02-2009
    Location
    Eagan, MN
    MS-Off Ver
    Excel 365
    Posts
    59

    Re: Create, Copy, Paste to multiple Worksheets

    That did it, thanks so much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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