How do I filter master list to multiple sheets?

M

megandonica

Hi,

I am working on a spreadsheet with about 2,000 rows in the master and 9 separate tabs. In the master, I have each row color-coded for its tab but am wondering if it is possible to link a color on the master with its respective tab? The content of the spreadsheet is names and contact info.

Thanks so much
 
M

megan

Hi,

I am working on a spreadsheet with about 2,000 rows in the master and 9 separate tabs. In the master, I have each row color-coded for its tab but am wondering if it is possible to link a color on the master with its respective tab? The purpose of doing this would be to color code a row in the master, and have it automatically show up in the proper tab The content of the spreadsheet is names and contact info.

Thanks so much
Click to expand...



Hi,

I am working on a spreadsheet with about 2,000 rows in the master and 9 separate tabs. In the master, I have each row color-coded for its tab but am wondering if it is possible to link a color on the master with its respective tab? The content of the spreadsheet is names and contact info.

Thanks so much
Click to expand...



Hi,

I am working on a spreadsheet with about 2,000 rows in the master and 9 separate tabs. In the master, I have each row color-coded for its tab but am wondering if it is possible to link a color on the master with its respective tab? The content of the spreadsheet is names and contact info.

Thanks so much
Click to expand...
 
D

Don Guillett

Hi,

I am working on a spreadsheet with about 2,000 rows in the master and 9 separate tabs. In the master, I have each row color-coded for its tab but am wondering if it is possible to link a color on the master with its respective tab? The content of the spreadsheet is names and contact info.

Thanks so much
Click to expand...

I would have to see the file.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to Format Multiple Sheets based on "Master" Format 0
Macro to Combine Data from Multiple Sheets with Cell References 4
Macro to Compile Data from Different Sheets 2
Visio 2013: how do I auto-colour Shapes in alignment with pre-entered Shape Data? 0
Linking a multiple spreadsheets to a master spreadsheet 2
Converting excel to PDF, single page converts to multiple HELP! 1
Copy range from multiple files in multiple folders to single sheet in master WB 10
Macro to C&P from all Sheets 1

Top