Creating a Excel workbook templat help needed

mattman1149

New Member
Joined
Dec 21, 2016
Messages
7
Hello,

I need help here as well. I will assume what you all have discussed in these commits will satisfy what I need.

I am in need of a template which I can create that will consist of multiply tabs.
(Each of the tabs will be for an individual client)

If what I am trying to understand in the comments above, I should be able to create with the Macros above?


I will have one master list which list all of my clients and I would like to be able to click on a client on this master list and it take me directly to this page in the Excel work book. The number of clients will be over 100 which is why I am asking if I can make the excel work book easy access to an individual page.

I am reading that I will need to go to my XL start up. However, I am having trouble location this as well.


Please if anyone can help provide more assistance it will be greatly appreciated.

Thank you all in advance for your help
 
Now you are confusing me.
From post #1
I will have one master list which list all of my clients and I would like to be able to click on a client on this master list and it take me directly to this page in the Excel work book. The number of clients will be over 100 which is why I am asking if I can make the excel work book easy access to an individual page.

i proposed a way to do that and you responded in post #4
I do like the layout, however I am looking to make this for my own needs.

Now you give me a workbook with two sheets tagged Sheet1 and Sheet2 with very similar content. What do you expect me to do with that? Where is the master sheet? Where do all of these column values come from?
 
Upvote 0

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Forum statistics

Threads
1,216,210
Messages
6,129,525
Members
449,515
Latest member
lukaderanged

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top