Ask Your Question

Calc: Need help with macro, formula or other method to automate changes [closed]

asked 2012-12-13 10:18:50 +0200

Deranged gravatar image

I have a row of data that I would like to duplicate and make into many rows of data, with certain specific changes to certain cells.

For example, I have something like this: 101 101 xyzabc101 other data...

I would like to increment each of those 101's so I get additional sequential new rows as follows: 102 102 xyzabc102 other data... 103 103 xyzabc103 other data... Perhaps 30 new rows so that my final row is: 130 130 xyzabc130 other data...

How can I accomplish this goal without manually making 90 changes? The first two columns I have a decent idea of how I can do it. The combination of text and number in the third column is the real problem. I was thinking maybe somehow segregate the text and number somehow and then combine with a new final result... but I have no idea how to do that. I believe Excel had some sort of text format function but I can't remember what it's called, nor do I know if Calc has something similar. Finally I'm not sure it would work for what I want. So really stuck here. I suppose in javascript something like for (i=101; i<131; i++) {colA=i; colB=i; colC="xyzabc"+i;} might do the trick, but I don't know how to get from here to there. Never programmed with calc before.

Thank you

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-19 13:09:20.924366

2 Answers

Sort by » oldest newest most voted

answered 2012-12-13 12:42:02 +0200

JohnSUN gravatar image

Maybe so?


edit flag offensive delete link more


Відмінне рішення - Libre Calc has many surprising features. Thanks for showing us this one.

vbas96 gravatar imagevbas96 ( 2012-12-17 01:23:35 +0200 )edit

answered 2012-12-16 20:01:28 +0200

Deranged gravatar image

That's brilliant! Thank you!

edit flag offensive delete link more

Question Tools


Asked: 2012-12-13 10:18:50 +0200

Seen: 356 times

Last updated: Dec 16 '12