Forum Discussion

beikme's avatar
beikme
Brass Contributor
Oct 10, 2020

AUTO COPY AND PASTE

Hi all i need help with some vba or micro    so i just need to copy one cell to another   lets just say i need cell to be paste in E3  but the list is in row F it could be anything from 1 up to 1...
excel
Macros and VBA
Rajesh_Sinha's avatar
Rajesh_Sinha
Iron Contributor
Oct 10, 2020
It's kind of hypothetical question, please share some sample data, and be specific about, "i need something that can auto detect if the cell have anything in it and copy one buy one to E3 cell "!!
  • beikme's avatar
    beikme
    Brass Contributor
    Oct 21, 2020

    Rajesh_Sinha 

     

    Hi

     

    So do you have any idea how i can get this working ?

    • Rajesh_Sinha's avatar
      Rajesh_Sinha
      Iron Contributor
      Oct 21, 2020

      beikme 

       

      Check the column F in attached sheet, find the formula in cell F4 downwards,, I hope that you are looking for this.

       

      In cell F3, you need to enter number smaller/prior than H3, like is 1 then 0. This will copy automatically in H4:H54, this may vary depends on the set of numbers to want to get.

       

      Remember cell H4:H54  has formula ,, need to be handled carefully.

      • beikme's avatar
        beikme
        Brass Contributor
        Oct 21, 2020

        Rajesh_Sinha 

         

        I'm using this vba to print 

         

         

        Private Sub Worksheet_Change(ByVal Target As Range)
        Dim KeyCells As Range

        Set KeyCells = Range("F3")

        If Not Application.Intersect(KeyCells, Range(Target.Address)) _
        Is Nothing Then

        ActiveSheet.PrintOut


        End If
        End Sub

         

    • Rajesh_Sinha's avatar
      Rajesh_Sinha
      Iron Contributor
      Oct 21, 2020
      You mean to say that you want to copy data from H2:H48 into F3 downwards ,, and this you want to automate,, like as soon you fill F3 with H2, then you are expecting excel to fill the sequence or you yourself wanna fill it ?
  • beikme's avatar
    beikme
    Brass Contributor
    Oct 10, 2020

    Rajesh_Sinha 

     

    something like this 

    So when i paste all the  data in H like starting from one and down ( 1-2-3-4-5-6-7-8 are like example )

    it would start copying from H2 down 

    copy one cell at the time to F3 so i can print it as son **bleep** its detect the call F3 have change 

    I need to print these labels 

    i dint know how many i get every  time so need something that would auto detect and would not copy empty cells 

     

    Hope this helps 

Resources