Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Master spread sheet to manage then show info on seperate tabs
I have a master spread sheet - info grouped under various managers who are
responsible. I want to maintain the master spread which then shows on indiviual tabs grouped by the above managers playing around with the following formula biut not sure if its the best thing to be using. =IF($A2="","",VLOOKUP($A2,ALL_CONTRACTS!$A:$B,2,FA LSE)) cheers Pete |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to copy/paste info into the protected sheet | Excel Discussion (Misc queries) | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Tabs accross of bottom of sheet are not showing | Excel Discussion (Misc queries) | |||
Sheet tabs disappear sometimes in Internet Explorer | Excel Discussion (Misc queries) | |||
how do changes made on shared sheets show up in a master sheet? | Excel Worksheet Functions |