Results 1 to 5 of 5

Copy ranges of cells using names from the Name Manager - Macro Needed

Threaded View

  1. #1
    Registered User
    Join Date
    12-23-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    28

    Copy ranges of cells using names from the Name Manager - Macro Needed

    Please see the attached spread sheet. Is it possible to have a macro that can use the list on the sheet "Items List" and match what it finds to a "Name" in excels Name Manager (this would select the range of cells I am needing) then run the macro "Copy_to_Takeoff" then go to the next item in the list and do the same, and so on, and so on until there is nothing left in the list?
    This would give me the ability to create any list I need and only run one macro.

    Step one: Open Sheet "Items List"
    Step Two: Use Cell B3 to match to a Name in Excels Name Manager
    Step Three: Run the macro "Copy_to_Takeoff"

    Step Four: Repeat Step one
    Step Five: Use Cell B4 to match to a Name in Excels Name Manager
    Step Six: Repeat Step Three

    and so on and so on...

    Thanks in advance to anyone willing to help. This will be a huge time saver for me.
    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. Macro needed: match names in different columns; then copy and paste range
    By msmith7113 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-08-2013, 11:56 AM
  2. [SOLVED] To use name manager or create dynamic ranges in VBA
    By chrisjames25 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-19-2013, 03:37 PM
  3. Having many dynamic ranges in Name Manager
    By gogita in forum Excel General
    Replies: 0
    Last Post: 09-05-2013, 04:26 AM
  4. Replies: 0
    Last Post: 07-13-2012, 06:01 AM
  5. [SOLVED] Defining Names in Name Manager
    By frksdf in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 12-26-2011, 03:06 AM

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