Copy the data using function

[Closed]
Report
-
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
-
Hello,

I want to copy the data from a1 to b5 at a10 to b15.
How can i copy that using function bcoz I have to paste that data many time in a Sheet.

Thnx..

1 reply

Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
486
Hi rvm,

It basicly depends if you have data in column B. If so, then macro will be better then function.

Let's assume column B is empty.
Formula in B5: =A1
Formula in B15: =A10

Now select B6:B15 and drag it down as far as needed.

Best regards,
Trowa