A Master Sheet?
Hello,
I am working on a large project, I currently have a 'master' sheet with columns from A - BX. with different titles, the information inputted is a range of numbers and contact details. I am hoping to split the information into 2 further tabs, to make it easier for a user to view the data/information needed.
The information in the further 2 tabs, I wish to display different columns of information. I hope this all makes sense. Let me know if I need to explain it more.
Many thanks,
Jake
Please include a sample workbook without sensitive data. It will be easier to see and recommend a solution.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
You could make use of the OUTLINE feature of Excel to show/hide columns of data to make it easy to read without having to have more worksheets that could make your workbook at least twice as large.
Here are instructions on making groups
https://support.office.com/en-us/art...ine_of_columns
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks