copy data from one sheet to end of range on another

**LiLi1** · 02-20-2012, 04:18 PM

It feels like this should be super simple but I have tried like 5 different things and it still won't work. It's likely I am just missing something completely obvious to try .
I am trying to have dept. W jump from one worksheet to another in same workbook to copy/paste between them once it reviews the data it needs to that was previously placed there.
Dept. W needs to copy a section from one sheet that is pushed from outlook by dept.X and has a default usage region of A2:O50 and just paste that list unto another worksheet that has a running list already started for the month that is controlled by dept Y.

I want to use VBA via a pushbutton because there are dozen's of worksheet pages and the pages are password controlled so not everyone "sees" all the pages. Regardless if I do F8 and step through the code it works fine until it actually needs to paste all the potentially copied rows. If gives an error message instead of pasting data. Any suggestions appreciated. Thanks in advance!

Please Login or Register  to view this content.

**LiLi1** · 02-20-2012, 04:58 PM

I am pretty sure it would work as an array and then I would write each line of the array on the next page..but to define/write each variable of the array line A thru O would be several lines of code

like:
active.offset.value = workArray(1)
active.offset.value = workArray(2)

and would just offset to the right as you fill from A to O

There has got to be a better way ...

**LiLi1** · 02-20-2012, 07:00 PM

I played around with the array idea but as there are not predefined cells as in there would be a varied amount in selected range on the first page .. the only way I could come up with is like ~10 array choices per line.. just not feasible