Need assistance creating a dynamic table

Hey All,

So what I would like to do is have a spread sheet that prompts the user to input a set of data related to one object. On completing this set, the data will then be added onto a new column in a separate table. From here, the next set of data can be entered, and so on. Could someone explain to me in simple terms how this could be achieved?

Cheers!
Chris

Welcome to the Forum chris.excel!

This requires a macro. What event do you want to trigger the prompt to the user? Here is an example that does it with a button.

Since I developed an answer to your question, you have edited your post to be a completely different question than the first one you asked. (This is not generally a good idea, better to start a new thread.) Please create an example of what you want this to look like. What does "new column in a separate table" mean? Are you creating a new separate table each time, or just a new column to an existing table?

Hi Chris and welcome to the forum,

Your question sounds like you need to learn about Dynamic Named Ranges.... See
http://www.bettersolutions.com/excel...G820716330.htm
for more info on that topic.

ok so i've got the main code ready as follows:

Sub TestMacro()
    
    Range("B" & "12").Select
    ActiveCell.FormulaR1C1 = InputBox("Name")
    Range("B" & "13").Select
    ActiveCell.FormulaR1C1 = InputBox("Northing")
    Range("B" & "14").Select
    ActiveCell.FormulaR1C1 = InputBox("Easting")
    Range("B" & "15").Select
    ActiveCell.FormulaR1C1 = InputBox("Transition Length (Ls)")
    Range("B" & "16").Select
    ActiveCell.FormulaR1C1 = InputBox("Minimum Radius (Rc)")
    Range("B" & "17").Select
    ActiveCell.FormulaR1C1 = InputBox("Central Angle (DELTA)")
End Sub

This works fine, however, when i have finished running the macro and would then like to re-run it, i need the next set to data to begin in the next empty column rather than replace column B. i.e C, then D and so on. Any thoughts?

Thanks

Chris, please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires "code" tags around code to preserve readability. I have added them for you because you're a new member. Here is the rule:

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE] [/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here