macros
Hi,
This will copy A1 - A10 to H1 - H10 in every worksheet
Sub Stantial()
For x = 1 To Worksheets.Count
Sheets(x).Range("A1:A10").Copy Destination:=Sheets(x).Range("H1")
Next
End Sub
Mike
"kilo" wrote:
I want to copy excel information from same cells in different sheets and
paste unto the same sheet , how can I use macro or anything else to do this
without repeating the process for the many sheets I have. thanks
|