Autogenerate Typical Rows based on input value

[Histor]

Hi All,

I want to know if there is any way to autogenerate the typical rows based on the input I give in Column A.
Please help me with your tips.

 

[Agent666]

What are the typical rows?
Where does the correct answer come from. What are we even looking at here?

You need a lot more specific information to be provided here to get an acceptable answer.

All I can really say to your question is yeah probably, but it may depend.

https://engineervsheep.com

 

[IRstuff]

The obvious answer for the obvious question is VBA to copy and paste "typical" rows into the required locations

TTFN (ta ta for now)
I can do absolutely anything. I'm an expert!

https://www.youtube.com/watch?v=BKorP55Aqvg

faq731-376 forum1529 Entire Forum list

http://www.eng-tips.com/forumlist.cfm

 

[IDS]

The INDIRECT function now works as an array function that returns a range, so I think that gives a simple option for this without VBA:

Set up the text for each input type on another sheet, and give each range a name, Input1 etc, or whatever you want to call them (without any spaces).
Enter the names (without spaces) in Column A as in your example.
In cells B1, B6, etc enter: =INDIRECT(B1)

This should return the text as entered from the range named in column A.

I am assuming you only need to change the text. If you need to change the graphics it will get more complicated.

Doug Jenkins
Interactive Design Services

http://newtonexcelbach.wordpress.com/

 

[SkipVought]

@Histor, where are you on this?

Did Doug's suggestion work for you?

Have you arrived at a workable solution?

If so, other members would like hear about your solution.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]