+ Reply to Thread
Results 1 to 4 of 4

Need a macro that well copy paste mutiple input cells across everal different worksheets

  1. 12-25-2012, 10:04 PM #1
    brockmane
    brockmane is offline
    Registered User
    Join Date
    07-06-2009
    Location
    Baltimore, Maryland
    MS-Off Ver
    Excel 2003
    Posts
    6

    Post Need a macro that well copy paste mutiple input cells across everal different worksheets

    Hello,

    I pray that everyone is having a great holiday! Much needed for me, but still working! smile! anyway, I need some assistance -- I need to find a way to consoldated the attached Macro. I have one workbook with several worksheets, the problem I am having is that the data in sheet1 -- has to populate the rest of the worksheets in difference cell locations. I wanted to try vLookup and hLookup, I just don't have the time to learn it. i.e.

    Made up example -- see attachment!

    Sheet1
    A3 = username
    C4 = Job Role
    etc...
    I need to copy & paste A3 to Sheet2:B5; Sheet3:A9; Sheet4:E17 etc.. and C4 across Sheet5:C7; Sheet 14:A8 etc... Can anyone assist me with this.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-26-2012, 12:24 PM #2
    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: Need a macro that well copy paste mutiple input cells across everal different workshee

    Hi, brockmane,

    nice idea to copy the code into a worksheet and color the code. IŽd preferred to have a sample of how the workbook looks like.

    Instead of Copy&Paste like you use it by now you could try to simplify the code to something like
    Please Login or Register  to view this content.
    which will leave you on the active sheet and avoid all the selecting, switching and copying (code produced by macro recorder).

    Alternatives might be a loop or arrays for the columns to which to copy.

    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
  3. 12-27-2012, 02:43 AM #3
    brockmane
    brockmane is offline
    Registered User
    Join Date
    07-06-2009
    Location
    Baltimore, Maryland
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Need a macro that well copy paste mutiple input cells across everal different workshee

    Hey Ciao,

    Thanks so much -- I really do appreciate your support! this means a great deal to me. I plan to post some of my code as I finished different modules. I have seveal more questions that I can use help wtih regarding consolidating some of these coded modules!

    Eric B.
    Reply With QuoteRegister To Reply
  4. 12-27-2012, 12:19 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: Need a macro that well copy paste mutiple input cells across everal different workshee

    Hi, Eric,

    youŽre welcome. And good luck for your project.

    Ciao,
    Holger
    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)

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