Excel Movement
Closed
Jon
-
Feb 8, 2010 at 10:16 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Feb 8, 2010 at 09:10 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Feb 8, 2010 at 09:10 PM
Related:
- Excel Movement
- Excel free download - Download - Spreadsheets
- Excel marksheet - Guide
- Number to words in excel - Guide
- Excel date format dd.mm.yyyy - Guide
- Kernel for excel - Download - Backup and recovery
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Feb 8, 2010 at 09:10 PM
Feb 8, 2010 at 09:10 PM
little confused. you have validation list in column Y in sheet called "total inforamtion". You select any one of these cells choose one from the list for e.g Y5 and the activecell(Y5) value is "sheet2"--Y5 is the activecell.
you want the whole row of Y6 that is 5th row to copied in sheet2.
If this assumption is correct use this macro
you want the whole row of Y6 that is 5th row to copied in sheet2.
If this assumption is correct use this macro
Sub test() Dim sh As String With Worksheets("total information") sh = ActiveCell.Value ActiveCell.EntireRow.Copy With Worksheets(sh) .Cells(Rows.Count, "a").End(xlUp).Offset(1, 0).PasteSpecial End With Application.CutCopyMode = False End With End Sub