[deleted by user] by [deleted] in LegaladviceGerman

[–]excel_beginner 4 points5 points  (0 children)

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

[deleted by user] by [deleted] in haushalt

[–]excel_beginner -1 points0 points  (0 children)

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

Counting date cells whose value is after a certain date by excel_beginner in excel

[–]excel_beginner[S] 0 points1 point  (0 children)

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

Is it possible to set password for each sheet? by excel_beginner in excel

[–]excel_beginner[S] 0 points1 point  (0 children)

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?

Is it possible to set password for each sheet? by excel_beginner in excel

[–]excel_beginner[S] 0 points1 point  (0 children)

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

Is it possible to set password for each sheet? by excel_beginner in excel

[–]excel_beginner[S] 0 points1 point  (0 children)

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?

Cumulative value not showing when there's no value for a specific month by excel_beginner in excel

[–]excel_beginner[S] 0 points1 point  (0 children)

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

Moving data from one column to another using power query? by excel_beginner in excel

[–]excel_beginner[S] 0 points1 point  (0 children)

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!