• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Paste data n number of times

N

neeraj2050

Member
Greetings!!

I want to paste data n number of times. Is it possible without VBA?

If no, then please suggest VBA

Regards
Neeraj Agarwal
 
Hi ,

Please upload a workbook with data in it , and specify which data you want pasted how many times.

Without specific data , it is anyone's guess what is possible and what is not.

Narayan
 
Greetings!!
File has been uploaded. I want each of them to get pasted 75 times and if possible get them loaded into a single column.
I have mentioned the requirements into the attachment enclosed herewith
Thanks in advance!!
 
That's really great!!

But I am unable to catch this formula. In case if more names are added then how can that be linked.
Also please suggets name of such kind of formula so I could Google and understand

Thanks once again for your time!!
 
Hi ,

A named range called List has been defined , and it refers to the range of cells B3:E3 ; in case you add more data , do so in the range F3 onwards to the right , and then make a change in the definition of the named range List , so that it includes the newly added data.

Another named range called Limit has been defined , and I have entered the value 75 in it. If you want to change this , you can do it.

The formulae have already been entered till row 700 ; in case you want to copy the formulae down , do so , and if data is available , the cells will be populated , otherwise they will remain blank.

Narayan
 
Hi ,

The correct way to access named ranges is through the Name Manager ; F5 will display only those named ranges which have been defined so that Excel can navigate to them.

In this case , the definition of List is :

=TRANSPOSE(Sheet1!$B$3:$E$3)

Because of the TRANSPOSE , you cannot really navigate to this named range ; similarly , Limit is a named range which has a static value 75 ; you cannot navigate to this named range.

Always use the Name Manager to access named ranges.

Narayan
 
You must log in or register to reply here.
Back
Top