User Profile

Collapse

Profile Sidebar

Collapse
blurtoad
blurtoad
Last Activity: Jun 27 '07, 07:02 AM
Joined: Jun 6 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • blurtoad
    started a topic Filter then copy
    in Visual Basic

    Filter then copy

    Hi.

    I have the following data in columns A, B and C of Worksheet1

    Student_Name Best_Subject Age
    AAA English 13
    BBB Math 14
    CCC English 13
    DDD English 14
    ... ... ... ... ...
    ZZZ Science 15

    I have created a drop down list in Worksheet2...
    See more | Go to post
    • blurtoad
      started a topic Copying a column in Worksheet A into Worksheet B
      in Visual Basic

      Copying a column in Worksheet A into Worksheet B

      HI, I am trying to copy all the contents in Column A of Worksheet "Input" into Column A of Worksheet "In_Matrix" , starting from Cell "A2". I am a beginner and I tried this code but (as expected) it didnt work. Please help. Thank you very much.

      Private Sub CommandButton1_ Click()

      Worksheets("Inp ut").Range("A2" ).Select
      Range("A2").End (xlDown).Copy...
      See more | Go to post
      No activity results to display
      Show More
      Working...