+ Reply to Thread
Results 1 to 6 of 6

Excel Macro to lookup sheet name with a range of cells and paste in the reference sheet

  1. 09-08-2013, 02:11 PM #1
    mishaq
    mishaq is offline
    Registered User
    Join Date
    04-24-2013
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2007
    Posts
    16

    Excel Macro to lookup sheet name with a range of cells and paste in the reference sheet

    Hello,

    I am struggling to have a macro so that it should lookup the sheet name with the range of colums in a summary sheet and then copy and paste the reference value in the matching sheet.

    Let me explain the situation in detail.....

    I have a workbook which has 120 worksheets. Sheet1 i.e., summary sheet has all the sheet names in colum A and the reference value in colum B. I am in need of a macro with which it should lookup the sheet name with the names available in colum A and copy & Paste the reference value from colum B in the matching sheet's cell "C1".

    Please somebody help me in getting this macro, I would appreciate the help. Thank you in advance.
    Reply With QuoteRegister To Reply
  2. 09-08-2013, 02:28 PM #2
    mehmetcik
    mehmetcik is offline
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Excel Macro to lookup sheet name with a range of cells and paste in the reference shee

    This should be relatively easy to do.

    Try This:
    Please Login or Register  to view this content.
    Last edited by mehmetcik; 09-08-2013 at 02:36 PM.
    Reply With QuoteRegister To Reply
  3. 09-08-2013, 02:36 PM #3
    mehmetcik
    mehmetcik is offline
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Excel Macro to lookup sheet name with a range of cells and paste in the reference shee

    That is a demonstration Version.

    But there is a faster Method.

    This will be a lot faster because it copies all the data from excel into an array and then pastes it back into the correct sheets.
    But there are a couple of more things that can be used to speed this up further:

    Please Login or Register  to view this content.
    Last edited by mehmetcik; 09-08-2013 at 02:45 PM.
    Reply With QuoteRegister To Reply
  4. 09-08-2013, 02:38 PM #4
    HaHoBe
    HaHoBe is offline
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Excel Macro to lookup sheet name with a range of cells and paste in the reference shee

    Hi, mishaq,

    Please Login or Register  to view this content.
    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you
    Reply With QuoteRegister To Reply
  5. 09-08-2013, 02:47 PM #5
    mehmetcik
    mehmetcik is offline
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Excel Macro to lookup sheet name with a range of cells and paste in the reference shee

    Ok

    This is basically the same as the last example

    but I have stopped it switching between sheets before pasting the data.


    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 09-08-2013, 02:55 PM #6
    mishaq
    mishaq is offline
    Registered User
    Join Date
    04-24-2013
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: Excel Macro to lookup sheet name with a range of cells and paste in the reference shee

    Hello mehmetcik

    You are superb.... Thanks a bunch.... I appreciate the help

    I got what I need through the macro you provided. Thank you once again...
    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. Macro to Copy Range with Merged Cells and Paste in the Empty Row in the Same Sheet
    By kaurka in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-22-2013, 10:34 AM
  2. Macro to Copy a range from one sheet and sellect where to paste in another sheet
    By Bud Wilkinsonn in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2013, 06:49 PM
  3. Macro to copy and paste range form one sheet to next available row in 2nd sheet
    By bajdr47 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-21-2012, 11:47 PM
  4. VBA macro to Find a dynamic range of cells, copy then paste to another sheet
    By Bmxerdude2087 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-24-2012, 02:36 PM
  5. [SOLVED] Macro to copy range of cells and paste into 1 sheet
    By Dean in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-19-2006, 08:55 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