My situation is that i need to copy data from one sheet to another. The data i am copying is to be added to a defined range. However this means that i need to use OFFSET in my macro so that i can add it to the next Available row and not a used one. However i do not no how to incorporate the offset into my macro.
Range("I10").Select
Selection.Copy
Sheets("Customers").Select
Range ("b16")
ActiveSheet.Paste
End Sub
This is what i have so far and would like to copy the data to the next available row and not a set one that will aventualy be used.
Bookmarks