Previous Topic Next Topic

Formula to copy 1 cell by number in another

Solved/Closed
tanz25 Posts 4 Registration date Tuesday July 13, 2010 Status Member Last seen July 14, 2010 - Jul 12, 2010 at 11:58 PM
tanz25 Posts 4 Registration date Tuesday July 13, 2010 Status Member Last seen July 14, 2010 - Jul 14, 2010 at 05:34 PM
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

Answer 1 / 2
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jul 13, 2010 at 09:51 PM
see this

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

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