98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Links
Links
Resolved · Urgent Priority · Version 2016
Mon 3 Aug 2020, 13:57Delegate Clare said...
Clare has attended:
Excel Intermediate course
Links
Hi,
I have created a spreadsheet with a list of businesses. I want to be able to click on the name one of the businesses and it bring up another sheet with their contact details, size of company, number of stores and addresses etc (all the information I will source and input).
How can I do this please? I was looking at pivot tables but that seems to be just to compare different data etc. I dont want to compare any data, just be able to open and close each one so there isnt a huge amount of data just on the initial spreadsheet.
Thanks
Clare
Mon 3 Aug 2020, 15:19Trainer Ron said...
RE: Links
Dear Clare,
Thank you for your question in our forum. My name is Ron and I am part of STL's training team.
To be able to click a business name in your list to then make the details for the company come up in another sheet you will need to program that yourself i.e. create a macro.
Macros involve programming business processes with Visual Basic for Applications which is a whole new realm of learning.
What you could possibly do instead is create a named range for each business' details and then create a hyperlink to the named range from your main list. Depending on the size of the list of businesses this could be a lengthy process.
There are no other built in tools in Excel that will give you 'Click Access'
I am sorry to disappoint you but at least you know that now.
For information about macros please click the following links.
https://www.stl-training.co.uk/syl/134/excel-vba-introduction-1-day.html
https://www.stl-training.co.uk/syl/135/excel-vba-intermediate-1-day.html
Kind regards
Ron Oldeboom
Learning and Development Consultant
STL training
Mon 10 Aug 2020: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Filtering Data in an Excel 2010 WorksheetWhen you have an Excel Worksheet with masses of data, it's not going to be easy to sift through it. So, in order to view sections of data, you can use the filter tool. Select the cells you want to filter (no need to select the column headers), then click the Home tab on the Ribbon, click Sort and Filter (you will find this in the Editing Section) then click Filter. |
