Hello,
I am totally new at VB and I am trying to copy and paste a list from column H, that will grow and that is called OutletsCanada, from sheet "align" to paste in column A of "Sheet1" under existing data - that will not be the same lenght neither.
In each sheet, there is an array that is called:
OutletsCanada in align - using an OFFSET formula
stores in Sheet1 - using an OFFSET formula This list is the list to be appended with data from "align".

Once the data are pasted under the existing data in column A, I have to drag down the formulas in columns B to G till the end of this list - that represents the cumulated data.

Here is what I got but it doesn't work, it says that the list is empty... The code I got is from parts I picked-up from Internet... THANK YOU SO MUCH FOR YOUR HELP!!!


Sub GetOutletsAndCanada()
Dim rng1 As Range
Dim rng2 As Range


Set rng1 = Sheets("align").Range("OutletsCanada")
Set rng2 = Sheets("Sheet1").Range("stores")


Sheets("align").Activate
Sheets("align").Select
ActiveSheet.Range("OutletsCanada").Copy
Sheets("Sheet1").Select
Sheets("Sheet1").Activate
ActiveSheet.Range("stores").End(xltodown).Offset(1, 0).Select
ActiveSheet.Paste
Range("B42:G42").Select
Application.CutCopyMode = False
Selection.AutoFill Destination:=Range("B42:G200")
Range("B42:G300").Select
Range("A43:G43").Select
Selection.Delete Shift:=xlUp





End Sub