Mini database with possibility to adding new documents to 1 row data

[jaryszek]

Hi,

i am doing little "database" in Excel where user will input for each column desired data (surname, name, age). It is ok:

Screenshot_54.png

problem i have is that in column Document user can have to input :
Document name and cost.

And he can input how many he wants to.
And now how to do this to still have data in 1 row for 1 input?

I could add many columns (Document name, costs) but it would be just ugly
I could have another small table created for every row and open separated mini table for each name.
I could have only text string like : Document1:40USD;Document2:20USD,Document3:60USD and allow user to input only this kind of format (with regex maybe validation?)
Or not allow to input thismanually - just add mini userform row cell and open possibility to add more documents and input only what we allow. But this column has to be protected somehow....

Do you Guys have any proper solution for situation like this?
What you can advice?

Please help,
Jacek

[Logit]

.
The posted workbook is empty. No code ... no description of what you are seeking ... no example of what you are doing. That is not acceptable - it does not provide anything for
a volunteer to work with to assist you.

See if this example (download the workbook) does what you are seeking. Keep in mind this is an example only ... you will need to edit the code so it fits your needs.
The code, as is, is not already written to provide data in the rows/columns you have depicted in your image.

https://www.amazon.com/clouddrive/sh...jDXFX5rWjPSgR6

[jaryszek]

Thank you Logit,

i provided example and described issue - if is not clear - let me know what information i could provide.

For now, thanks! I figured it out based on your example!!

Jacek

[Logit]

Glad you have an answer.