+ Reply to Thread
Results 1 to 7 of 7

need help wiht VBA code inseting row value from sheet1 to sheet2 with repeat function?

  1. #1
    Registered User
    Join Date
    06-07-2021
    Location
    india
    MS-Off Ver
    2011
    Posts
    39

    need help wiht VBA code inseting row value from sheet1 to sheet2 with repeat function?

    Hi

    I have excel with sheet1 and sheet2 (image and excel attached) for better understanding
    Sheet1 have column D & F with some input values
    In sheet2 column A (Row 1 to 6) the in already mentioned value come default
    Row 7 value comes from Sheet1 D1
    Row 8 value comes form sheet1 F1
    row 9 value comes from sheet1 F1
    row 10 values come default
    Row 11 value comes from Sheet1 D2
    Row 12 value comes form sheet1 F2
    row 13 value comes from sheet1 F2
    row 14 values come default

    its function should repeat entire column D &F of sheet1
    test3.PNGtest4.PNG
    Attached Files Attached Files

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,613

    Re: need help wiht VBA code inseting row value from sheet1 to sheet2 with repeat function?

    Try:

    Please Login or Register  to view this content.
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    06-07-2021
    Location
    india
    MS-Off Ver
    2011
    Posts
    39

    Re: need help wiht VBA code inseting row value from sheet1 to sheet2 with repeat function?

    Hi its not working
    exactly my requirement is sheet 1 have value in column D&F, using that value I want to make the output sheet2 column A
    image attached for reference
    Attachment 735709

    my excepted output in image file.

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,613

    Re: need help wiht VBA code inseting row value from sheet1 to sheet2 with repeat function?

    THe attachment does not open - see the yellow banner on the top of the page with attachment instructions.

    The code in the file is called test2 (as you already had test in your file).
    Attached Images Attached Images
    Attached Files Attached Files

  5. #5
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,613

    Re: need help wiht VBA code inseting row value from sheet1 to sheet2 with repeat function?

    or may be the following:

    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    06-07-2021
    Location
    india
    MS-Off Ver
    2011
    Posts
    39

    Re: need help wiht VBA code inseting row value from sheet1 to sheet2 with repeat function?

    hi its working fine thanks a lot....

  7. #7
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,613

    Re: need help wiht VBA code inseting row value from sheet1 to sheet2 with repeat function?

    Thanks for reputation point.

    As the answer (as I understand) takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VB Code to summarize hours from sheet1 to sheet2
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-05-2019, 07:38 PM
  2. [SOLVED] Vba code to extract specific data from sheet1 to sheet2.
    By xlhelp7 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-27-2016, 07:18 AM
  3. [SOLVED] Run Code on All Worksheets Except Sheet1 and Sheet2
    By Tellm in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-07-2016, 01:15 PM
  4. Replies: 6
    Last Post: 07-25-2013, 02:58 PM
  5. [SOLVED] Need micro compare code in sheet2 and sheet3 with code in sheet1
    By jamalmail in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-21-2013, 05:15 PM
  6. Refine Code to Copy Row From Sheet1 to Sheet2
    By berkley in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-31-2010, 11:07 AM
  7. code tweak to copy data from sheet1 to sheet2
    By imatomic in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-28-2010, 02:18 PM

Tags for this Thread

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