Post a data to an other sheet.

Closed
sohail - Jun 17, 2010 at 05:52 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jun 17, 2010 at 06:25 AM
Hello,

i have a date that contain 8 column and 26 rows, i want to post this data to an other excel sheet through a botten

1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Jun 17, 2010 at 06:25 AM
Sub test()
Worksheets("sheet1").UsedRange.Copy Worksheets("sheet2").Range("a1")
Application.CutCopyMode = False
End Sub


create a button from the forms window and assign this macro to it
1