Forum Discussion
I'm new and need some help
I'm working on a list of all national parks with junior ranger badges in them. It's listed state by state. I'm making this so anyone can use it and put the date they earned their junior ranger badge. But I'm having trouble figuring out a couple things I want it to do and I need help. I do have everything protected except where they can add the date and where they can add special junior ranger badges.
1 - When I update the list, like a different version, how can their dates be saved in the correct spot when they save the new version?
2- Some junior rangers can be earned at different parks, different states. How can they put in the date in one spot but automatically be put in the other spots?
3 - How can I put this out there so anybody can download or save it, but they can still be able to get the new version?
Thanks for your help. If it's just a link to where to go to figure it out that would be great. I've tried to figure it out but I'm not using the correct terminology so I'm not getting anywhere.
Here is a step-by-step guide to create a list of national parks with junior ranger badges using Microsoft Excel and make it accessible for anyone to download or save (Steps developed by the AI):
- Open Microsoft Excel and create a new workbook.
- In the first row of the worksheet, create the headers for your columns. For example, you can create columns for "National Park", "State", "Junior Ranger Badge", "Date Earned", and "Special Badge Earned".
- Add the names of national parks, their states, and the corresponding junior ranger badges to the worksheet.
- In the "Date Earned" and "Special Badge Earned" columns, you can format the cells as "Text" to allow users to input text without Excel trying to format it as a date or number.
- To automatically populate the dates and special badges earned in other spots where the same junior ranger badge can be earned, you can use Excel's VLOOKUP function. Create a separate worksheet with a list of all the junior ranger badges and the parks where they can be earned. In this worksheet, create columns for "Junior Ranger Badge" and "National Parks", and add the corresponding values.
- Go back to the original worksheet and add a VLOOKUP function in the "Date Earned" and "Special Badge Earned" columns. The formula should look something like this: =VLOOKUP(A2,[Badge List.xlsx]Sheet1!$A$2:$B$10,2,FALSE) where A2 is the name of the junior ranger badge in the current worksheet, [Badge List.xlsx]Sheet1!$A$2:$B$10 is the range of cells in the separate worksheet that contains the list of all junior ranger badges and their corresponding parks, 2 represents the second column (National Parks), and FALSE ensures that an exact match is found.
- To share the Excel file, save the file to a cloud storage service like Microsoft OneDrive or SharePoint. Once you have saved the file, you can right-click on the file and select "Share". From there, you can choose who you want to share the file with and whether you want to give them edit or view-only access.
- You can also create a shared folder where you can upload the updated Excel file. Anyone who has access to the folder can download the latest version of the list.
- To track changes made to the Excel file, you can turn on the "Track Changes" feature in Excel. To turn on this feature, go to the "Review" tab in the Excel ribbon, and click on "Track Changes". You can choose to track changes made by "Everyone" or "Specific People", and choose how you want to highlight the changes.
I hope this step-by-step guide helps you create your list of national parks with junior ranger badges and make it accessible for others to download or save.
I hope this helps!
