Previous Topic Next Topic

Formula to copy 1 cell by number in another

Solved/Closed
tanz25 Posts 4 Registration date Tuesday 13 July 2010 Status Member Last seen 14 July 2010 - 12 Jul 2010 à 23:58
tanz25 Posts 4 Registration date Tuesday 13 July 2010 Status Member Last seen 14 July 2010 - 14 Jul 2010 à 17:34
I have a spread sheet with text and numbers in a1 to c1 and then in d1 is a number that i need it copy and pasted by

E.G

Hello 3
Stuff 6
hannah 2

I need 3x hello 6x stuff 2xhannah however in my spread sheet that i need done i have about 3000 records i need this done for

Any one know how to do this.

Hope this makes senses
Related:

2 responses

Réponse 1 / 2
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
13 Jul 2010 à 21:51
see this

https://ccm.net/forum/affich-333050-how-to-repeat-rows-by-x-number-of-times
tanz25 Posts 4 Registration date Tuesday 13 July 2010 Status Member Last seen 14 July 2010
13 Jul 2010 à 22:15
unfortunately this doesn't make since to me
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
14 Jul 2010 à 17:12
That's a macro that does 100% exactly what you seek
tanz25 Posts 4 Registration date Tuesday 13 July 2010 Status Member Last seen 14 July 2010
14 Jul 2010 à 17:34
Thank you i have figured out how to use this now.

Similar discussions

What is my confirmation code for Facebook?
leah -
bongloiGobas -

5 responses
My laptop n,b,space,2,? mark keys not working
hshahul04 -
xpcman -

3 responses
Some keys stopped working i.e.B, N, Space, Arrows
shreeraj365 -
Elaf_tauqir -

11 responses
Laptop some keys on my keyboard are not working
niko -
Ambucias -

12 responses
laptop b,n, space bar,arrow keys are not working
madel -
Ambucias -

1 response
Auto insert 'x' rows depending on value 'y'
nephilim3uk -
rizvisa1 -

6 responses