Array copy under another array with macros

[kosc95]

Hello everyone. I need some help with my project where i want to copy array and past it to another sheet. Array is a daily base of consumption for different materials, so would like to copy it to another sheet that i manually name it for a month its made. The problem is i just don't know macros, and i don't know how to copy that array to another sheet under another array..

array_day1
array_day2
array_day3
.
.
.
that would be in spreadsheet january, same goes for other months..as i said i would name them manually.

Any help would be really appreciated.

 

[NdNoviceHlp]

U don't need to copy and paste an array. Just load it from 1 sheet then unload it in another sheet. HTH. Dave

 

[NdNoviceHlp]

Here's an example...

Sub test()
Dim Arr() As Variant, Cnt As Integer, Cnt2 As Integer
ReDim Arr(5)
For Cnt = 1 To 5
Arr(Cnt - 1) = Sheets("sheet1").Cells(Cnt, "A")
Next Cnt
For Cnt2 = LBound(Arr) To UBound(Arr)
Sheets("sheet2").Cells(Cnt2 + 1, "A") = Arr(Cnt2)
Next Cnt2
End Sub

Sheet1 A1:A5 loads to array then unloads to Sheet2 A1:A5
Dave