First Thread; Create overview from table

[Interflower]

Hello,

This is my first time on a forum, but I outgrew the knowledge of other collegues in excel, so I want to learn more from others around the world.

A collegue had the problem that he had to fill in a lot of data, so he tried to simplify it. He made a table in which he has an X and Y axis.
Both the X and the Y axis have a name which can be combined with eachother (I think its a pivot table, but I am not sure); e.g.:
X = Red / White / Blue
Y = Orange / Purple / Yellow
X1Y1 = Red-Orange
X3Y2 = Blue-Purple

Now, every time he wants one of these combinations in use for his project, he fills in a "1" in the crossing of the X and Y axis (in the table).
He wants, when he fills in a "1", that a new row is made which fills in the information:
Cell A1 = "Option number 1"
Cell B1 = Red
Cell C1 = Orange

Cell A2 = "Option number 2"
Cell B2 = Blue
Cell C2 = Purple


Now you add a "1" in between these options: X2Y3 (White-Yellow)
Now:

Cell A1 = "Option number 1"
Cell B1 = Red
Cell C1 = Orange

Cell A2 = "Option number 2"
Cell B2 = White
Cell C2 = Yellow

Cell A3 = "Option number 3"
Cell B3 = Blue
Cell C3 = Purple



I think the easiest way to accomplish this is by a macro which keeps running when you turn it on.
Can you guys follow my idea a bit? Or guide me?

Thanks in regard.

[FDibbins]

Hi, welcome to the forum

Not sure I understand

Are you saying you already have a 2-d table containing data, and you want to return a value from within the table, based on an X and Y value?

[Interflower]

excel forum.png
excel forum 2.png

Thanks for the reply and the welcome message!

I will do my best to explain.
As you can see at image 1, I already have a 2-d table containing data indeed. If I fill in a 1 here, then I want a row to be created at image 2 (other worksheet) with the infomation.
I want the rows to be created in the order of the tables (from left to right, up to down, like a book)

But if a part of the table isn't filled in (blanc), then no row should be created (and if it goes from 1 to blanc, the row must be cleared / removed)

[FDibbins]

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.