Does this need require a macro or VBA?

[ibddude]

I have a worksheet containing rows of data (say 30-40 columns). What I need to do is when I find certain values within a particular column, I need to insert X number of new rows below it containing other information (sub parts) to the main value. Say S12 contained XYZBundle, I would then want to insert 4 rows of additonal data pertaining to XYZBundle right below it, then move to the next value (say S12 + 4, or S17)..and so on.

Do you need a macro or VBA to "Insert" rows of data? I'm imagining a VLOOKUP function to determine if it needed rows inserted and then a table to say how many and the content...

ANy ideas would be helpful

THanks
Ibddude

 

[buxtongt]

Sounds like it would require a macro to me. Something like a loop that goes through all the cells in that column you have your data in and if it finds one of the preset values inserts a certain number of rows with the set data you want in them. Hope this helps.

 

[ibddude]

Thanks. I actually haven't done a macro, but Is this something where you record say a part of the operation (like inserting rows) and then you combine it with other fuctions like VLOOKUP to create a complete "macro"

THanks for your response