Need a little help in Excel Sheet
Hi to All!
I have an excel file that im trying to make but its very hard for me since i know just the basic excel stuff. I'm trying to create 3 spreadsheets. The first spreadsheet is for entering usernames and passwords, my guess this would require some kind of VBA or MACRO code to help it(this sheet would act as a security before anyone can select the next sheet. The second spreadsheet should allow the user nos search and retrieve all information under his/her name(this would act as a search page like google or something but with the available data and limited searchs. The third page is all easy, that would be where all the data is coming from. That i have done, even made it automatic and a simple so that data can be entered quickly.
So if anyone knows anything or even a bit of something, i'd definitly appreciate the help. thank you all for your time.
This is a tricky one to answer since the best software for this is undoubtedly Access. However, it is a very difficult program to learn (for anyone new to it, and even old hands). It is totally possible to do it using Excel VBA and that would be what I would d but that is because I love programming Excel. But for someone with no experience it would be a very steep learning curve too.
Have you done any programming before?
Setting up a password in Excel to protect a sheet or a workbook is relatively easy and doesn't necessarily need VBA but the other stuff you describe really requires user forms and VBA.
There are plenty of resources on the net for VBA but you have set yourself quite a task. You'll need to be very clear and specific about what you want.
You are looking at a VBA enabled excel sheet. BTW, which excel version are you running?If 2007, then it will be extremely easy.
Writing macros in excel can be done, but it is annoying, you could just set this up in access, you are making a database, and that is what access is for. But usernames and passwords with a locked screen will get a little convoluted trying to program a search query other than the find function already present.