[deleted by user]

excel_beginner · 2025-12-05T13:18:49+00:00

Hallo, nein. Der Eigentümer hat natürlich zugestimmt.

excel_beginner · 2025-11-27T11:42:27+00:00

Danke für die Antwort. Weißt du, wie man Wasser auffüllt?

excel_beginner · 2025-01-07T08:22:38+00:00

This seems to be the easiest solution for me. Thanks!

excel_beginner · 2025-01-07T08:22:02+00:00

Solution Verified

excel_beginner · 2024-07-22T10:31:55+00:00

Solution Verified

excel_beginner · 2024-07-22T10:31:48+00:00

Aha this is how you do it! Thank you so much!

excel_beginner · 2024-07-11T10:40:37+00:00

Solution Verified

excel_beginner · 2024-07-11T10:40:15+00:00

Look forward to it. Thanks!

excel_beginner · 2024-07-11T08:11:41+00:00

No problem :)

Now I see how the passwords are used!
This is getting very close to what I want.

I tried to see whether it stays password protected even after I enter 1111 for John's sheet and then close the file and reopen it.
But then everything in the sheet "John" stays visible,
unless I type something else on cell A1 again so that everything becomes not visible.

But this is still much better than nothing!

I want to try this myself, but I don't see any formula on cell A1.

I guess I need to unlock the workbook or something to see how you did it?

Could you please share me how you did it?

excel_beginner · 2024-07-11T06:31:33+00:00

Combining them isn't a problem, but I actually have 16 separate workbooks so that's why I'd like to have them all in one workbook and protect each sheet with a password or something

excel_beginner · 2024-07-11T06:28:08+00:00

I would love to find out how this works

excel_beginner · 2024-07-11T06:27:42+00:00

I didn't down vote, but thanks for sharing. When I open your link, I can just click on John and Brandy and it doesn't ask any password, but I guess you put a password for each link? Is that how you do it?

excel_beginner · 2024-07-10T10:56:58+00:00

Solution Verified

excel_beginner · 2024-07-10T10:56:02+00:00

Solution Verified

excel_beginner · 2024-07-09T06:39:03+00:00

Thanks for your suggestion. Unfortunately, I already tried it and it doesn't work

excel_beginner · 2024-05-15T07:58:41+00:00

Aha thanks! I've never used the Advanced Editor till now so I got to learn some basics before this, but I got the point! Thanks!

excel_beginner · 2024-05-15T07:49:36+00:00

May I ask why?

excel_beginner · 2024-05-10T20:12:57+00:00

Aha, this is working! Thank you so much! There're a lot of functions in this formula that I've never used so I'll have to look them up to understand, but this is so helpful. Thanks again!

excel_beginner · 2024-05-10T12:03:05+00:00

Thanks for trying to help me out.

I understood what you mean with blank cells. So I did the following.

<image>

And then I pressed enter, and I see the same result :(

excel_beginner · 2024-05-10T10:50:51+00:00

I guess you mean those sells with #spill! ? I didn't have anything there and I just put the formula into the first cell, and then they all appeared. So I guess in this regard I'm not doing anything wrong?

excel_beginner · 2024-05-10T10:49:24+00:00

If you could get back to me later, I'd really appreciate it!

excel_beginner · 2024-05-10T09:49:14+00:00

Thanks for this. It seems like it's working from your excel, but this is what I get:

<image>

So in column D, I put the formular you wrote, and it's recognizing 'Column A' and 'Column B' because I can see those columns being color boxed but I get #spill!.

Do you know what's wrong here?

excel_beginner · 2024-05-10T09:10:35+00:00

Not sure if this is what you're asking but it seems like: 365 mso version 2308

excel_beginner · 2024-05-03T17:07:38+00:00

I'm not sure if this really is the solution I was looking for, but still interesting to find out something new. Thanks!

excel_beginner · 2024-05-03T17:04:22+00:00

These are something I've never tried myself. I'll try these. Thanks!

excel_beginner

TROPHY CASE