Posts by arm

Re: copy data from a set column in a workbook to rows in a different workbook

Hi Dangle,

Apologies , I think my code finally worked with the same technique of puttinf pastespecial at teh end. Probably was doing something wrong earlier .

Thanks ,

Re: copy data from a set column in a workbook to rows in a different workbook

Hi Dangle,

Will bother you just once more if you can help . What if i want to only paste the value to the target sheet in the above code . I tried adding pastespecial xlpasteall at the end of the code but it gives me an error.

Thanks again for all the help. This forum is really good for beginners like me.

Regards,
ARM

Re: copy data from a set column in a workbook to rows in a different workbook

Thanks a ton !

Re: copy data from a set column in a workbook to rows in a different workbook

Hi Dangle ,

Many thanks for the reply. It works perfect but just one thing , i need to copy it in another workbook . How do i add that to the above code?

Regards,

Re: copy data from a set column in a workbook to rows in a different workbook

any replies anyone ? i am kinda stuck with this code

Thanks in advance for all the help

Hi everyone ,

I want to copy 750 rows of data in range ("D4:BE753") in one workbook to another workbook such that data ("D4:BE6") is copied in rows 30,31,32 of the other workbook , thn ("D7:BE9") is copied to rows 67,68,69 in this other workbook ( it is copied after every 35 rows of data) till row 9500 ..i can link them using the normal excel offset function but then i need to do it 250 times till row 9500. Thought vba may be faster and i am new to vba.So need help .

Many Thanks in advance and apologies if this thread was there earlier for i did search before posting a new one.

forum.ozgrid.com/index.php?attachment/45249/Hello Everyone,

I am a pretty new Vba user. I am currently working on a sheet where i need to copy data from range("A3:E490") down . Column 1 is teh only dyanamic column , rest other columsn are static data . Column 1 has the scenario number which changes after every 488 rows.the remaining columns has the same data and will remain the same .

i need to do it for 100 scenarios.

I know how to do it for the columns seperately with the forum's help last week but is there a way to do it all together with one single vba code ?

I am attaching the file for ease of understanding .

Thanks a lot.

Re: code to Copy numbers 1 to 100 in the same column repeating 5 times

this worked brilliantly . Thanks a lot jproffer. I spent like 2 hours trying to do it and this did it in 10 seconds . I am new to vba and very hopeful that wil speed up my learning with this forum. This is an excellent place .

Thanks everyone.

Re: Vba code to copy values down in the same column

Hi All ,

Thanks for the solution ..it worked perfectly fine . Apologies for te double posting . Was the first time i was posting and hence the mistake . Will take care in future . Thanks everyone.

Re: code to Copy numbers 1 to 100 in the same column repeating 5 times

sorry that was a double posting by me , i just joined the forum . Still waiting if someone can help me with this

Re: Fill cells down column x number of time with repeating numbers

what code do i use if i want to add the numbers 1 to 100 in column A repeating each number 5 times . The above code does when i used was giving me the same value throughout . Sorry i am new to vba .

Hi , i am new to vba and right now struggling to get small codes correct.

I need to write a code which gives me numbers 1 to 100 in the same column with each number repeated 5 times before i move to the next number like
1
1
1
1
1
2
2
2
2
2
till 100 .

Request help .

I need to copy numbers from 1 to 100 in the same column repeating each number 5 times before moving to the next number .
like

1
1
1
1
1
2
2
2
2
2
till 100

Please help