+ Reply to Thread
Results 1 to 2 of 2

Macro to Copy/Paste Data from Reference Sheet

Hybrid View

  1. #1
    Registered User
    Join Date
    01-11-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    10

    Macro to Copy/Paste Data from Reference Sheet

    Hello all,

    I am trying to find a macro that will copy the exact layout, groupings, Text color, etc from sheet 3 to sheet one when the code type is selected from the drop down menu on sheet 1.

    I have two types of codes "How Malfuntioned Codes" and "Work Unit Codes" that are numerous so I grouped them in sheet 3 for easier navigation. Now I want to be able to reference those and keep the grouping when selected in the drop down menu on sheet 1.

    I know this needs to be a macro I just don't know enough to write it. Any help would be greatly appreciated!

    Attached is my spreadsheet.
    Attached Files Attached Files
    Last edited by Dredger; 01-14-2011 at 01:41 PM.

  2. #2
    Registered User
    Join Date
    01-11-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Macro to Copy/Paste Data from Reference Sheet

    Bump,

    Still trying to figure this out. Any ideas are welcome!

+ 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