Forum Discussion
How to Link Excel Data across Multiple Sheets
I have some questions for you:
- I don't see any passwords on any of the three sheets. Where are they?
- What is the purpose of each of the three sheets? (I'm asking for the distinct purpose for each sheet)
- What is the purpose or goal of the entire workbook?
My reason for asking the last two questions is that it would seem to me (as a person who has designed a number of databases over the years) that a single table might serve your purposes. Granted you may need different kinds of sorts--those are all easily accomplished with a single database (single table).
And a security question: if you're doing this to keep track of all your passwords for all the websites you visit--a task well worth undertaking--are you aware that you might be setting yourself such that a determined hacker could pretty easily gain access. Excel's password protection on spreadsheets is not as secure as some apps you could get (1Password, for example: https://1password.com/ ).
That said, 1Password--which I use--has a single file for login information on the hundreds of such combinations of user id and password that I have. There are also separate "windows" for, oh, credit cards, passports, drivers licenses, etc etc....but the kind of info you're collecting is all in one spot, with extra fields for notes, URLs, etc. So if you're determined to go ahead and create your own, that's fine, but let's see if we can help you develop the most effective way to organize it.