+ Reply to Thread
Results 1 to 5 of 5

VPA copy Values

  1. 03-15-2021, 12:29 PM #1
    Excl3454
    Excl3454 is offline
    Registered User
    Join Date
    01-29-2021
    Location
    Canada
    MS-Off Ver
    2019
    Posts
    93

    VPA copy Values

    Few days I asked for help and thanks for responded and clear solutions.
    I asked if it is possible to copy some values in corresponded cells under each number and now I have a good working sheet.
    anything I insert will be copied under each number I wanted, But I have to enter a value into each cells [B]one by one[/B,] and click next cell to complete copy paste.
    wondering what if I want to copy few columns from notepad and insert in into A1:F5 ? it wont work and I have to go to each cell and click them again.
    is there any way VBA copy values without entering key into individual cells?
    Thank you so much
    screenshot.5871.jpg
    Attached Files Attached Files
    Last edited by Excl3454; 03-15-2021 at 01:01 PM.
    Reply With QuoteRegister To Reply
  2. 03-15-2021, 12:42 PM #2
    Marc L
    Marc L is offline
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Cool Try this !


    According to your attachment as a VBA starter :

    PHP Code: 
    Private Sub Worksheet_Change(ByVal Target As Range)
                 Dim Rc As Range
        With Application
                .EnableEvents = False
                .ScreenUpdating = False
            For Each Rc In Target
                If Rc.Column < 7 And Rc.Row > 1 And Application.IsNumber(Rc.Value2) Then Cells(Rc.Row, 7 + Rc.Value2).Value2 = Rc.Value2
        Next
                .EnableEvents = True
                .ScreenUpdating = True
        End With
    End Sub 
    ► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄
    Reply With QuoteRegister To Reply
  3. 03-15-2021, 12:43 PM #3
    p45cal
    p45cal is offline
    Forum Contributor
    Join Date
    08-26-2016
    Location
    UK
    MS-Off Ver
    O365
    Posts
    260

    Re: VPA copy Values 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 03-15-2021, 12:59 PM #4
    Excl3454
    Excl3454 is offline
    Registered User
    Join Date
    01-29-2021
    Location
    Canada
    MS-Off Ver
    2019
    Posts
    93

    Re: Try this !

    Quote Originally Posted by Marc L View Post

    According to your attachment as a VBA starter :

    PHP Code: 
    Private Sub Worksheet_Change(ByVal Target As Range)
                 Dim Rc As Range
        With Application
                .EnableEvents = False
                .ScreenUpdating = False
            For Each Rc In Target
                If Rc.Column < 7 And Rc.Row > 1 And Application.IsNumber(Rc.Value2) Then Cells(Rc.Row, 7 + Rc.Value2).Value2 = Rc.Value2
        Next
                .EnableEvents = True
                .ScreenUpdating = True
        End With
    End Sub 
    ► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄
    Thank you so much.. very nice of you
    Reply With QuoteRegister To Reply
  5. 03-15-2021, 01:00 PM #5
    Excl3454
    Excl3454 is offline
    Registered User
    Join Date
    01-29-2021
    Location
    Canada
    MS-Off Ver
    2019
    Posts
    93

    Re: VPA copy Values

    Quote Originally Posted by p45cal View Post 
    Please Login or Register  to view this content.
    Thank you, very nice and i have both code works fine now
    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. VBA copy based on a range (message box / user form) and copy values greater than 0
    By madi1004 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-25-2020, 09:05 AM
  2. Macro: Copy Active Sheet, Make Values Only, then Save Copy
    By brendangroff in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-10-2015, 04:34 PM
  3. Copy Cell Values in two Columns down x number of times then jump and copy some more.
    By scholly23 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-02-2014, 03:19 AM
  4. Excel Macro to select the each values from drop down list and copy-paste the values
    By Chito in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-14-2014, 12:52 AM
  5. VBA to copy cell (with formula) to next row and then copy and paste values in cells above
    By VIK1471 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-08-2013, 06:03 AM
  6. modify macro to copy values instead of copy and worbook instead of worsheet
    By sbab in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-11-2013, 08:43 AM
  7. [SOLVED] Copy/Paste how to avoid the copy of formula cells w/o calc values
    By Dennis in forum Excel General
    Replies: 10
    Last Post: 03-02-2006, 06:50 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1