+ Reply to Thread
Results 1 to 6 of 6

Information transfered between sheets by macro

  1. 07-12-2013, 08:21 AM #1
    wolf50
    wolf50 is offline
    Registered User
    Join Date
    07-12-2013
    Location
    Sibiu, Romania
    MS-Off Ver
    Excel 2010
    Posts
    6

    Information transfered between sheets by macro

    Hallo everibody

    Need your help to repair a macro...

    I've two sheets :"Validare" and "Materials", and many others.
    In "Validare", after introducing manual a code: ex "52082011", I've picked some informations from second sheet "Materials" (with LOOKUP...bla, bla)...and from other sheets
    Based to these infos I decide to introduce two new informations in sheet "Materials", by manual insert of values in two cells (sheet "Validare") and with a button (Macro)...

    The problem is that I can't repet the job, because all informations remains from first usage of macro...
    Here you have the macro, please advice me what to change to be able to "52082011", Q6404" and "R6404" from attachement as variables each time.
    Thanks in advance.

    Please Login or Register  to view this content.
    Last edited by arlu1201; 07-16-2013 at 01:45 PM.
    Reply With QuoteRegister To Reply
  2. 07-13-2013, 01:36 AM #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: Information transfered between sheets by macro

    Hi, wolf50,

    welcome to ExcelForum. I´m quite sure we could help with your problem if you could wrap the procedure in Code-Tags for better readability and attach a sample workbook with some data for a better understanding stating the data as is as well as a description/worksheet of the expected result.

    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. 07-16-2013, 09:08 AM #3
    wolf50
    wolf50 is offline
    Registered User
    Join Date
    07-12-2013
    Location
    Sibiu, Romania
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Information transfered between sheets by macro

    Hallo HaHoBe
    Thanks for answer and sorry for delay...
    Because I'm not sure what means code-tag in this issue, I've sent a model of my file, in which button "OK" must transfer info’s from K15 and k17/sheet "Validare" (insert by me) on sheet "Materials" on specific line, columns M and N. Be aware that complete file will have more than 75000 lines on sheet "Materials".
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 07-16-2013, 01:45 PM #4
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Information transfered between sheets by macro

    wolf50,

    Welcome to the forum.

    I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]
    Reply With QuoteRegister To Reply
  5. 07-17-2013, 01:11 AM #5
    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: Information transfered between sheets by macro

    Hi, wolf50,

    maybe try this code and see if it does what you want:

    Please Login or Register  to view this content.
    Ciao,
    Holger
    Reply With QuoteRegister To Reply
  6. 07-17-2013, 04:06 AM #6
    wolf50
    wolf50 is offline
    Registered User
    Join Date
    07-12-2013
    Location
    Sibiu, Romania
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Information transfered between sheets by macro

    Hallo Holger
    It works!
    thanks
    mfg
    wolf50
    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