Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations KootK on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Autogenerate Typical Rows based on input value

Status
Not open for further replies.

Histor

Electrical
Mar 2, 2022
70
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.
Auto_Generate_wyb8gc.png
 
Replies continue below

Recommended for you

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.

 
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
 
@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]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/sub]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor