Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Connecting a master sheet to other sheets within the same workbook
Hello,
I have been trying to figure this one simple question (or not so simple) out. Is it possible to tie information contained on a master sheet within one Excel workbook to a different sheet in the same workbook? For example, I have a master list with both the year 2009 and 2010 in it and I want to make it so that if information typed into this master list contains either 2009 or 2010 it goes to that specific sheet. So far, I have been filtering by year and manually cutting and pasting the information into the respective sheets. Is it possible to program Excel to automatically recognize this in the workbook? If so, all I need is the terminology used for this command and I can figure it out from there! If anyone happens to know, I would greatly appreciate it! Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Connecting a master sheet to other sheets within the same workbook
Hi Genevieve, yes, it is possible.
1. For example put 1 in cell A1 of Sheet1. 2. Do a CTRL-C to copy the info in cell A1. 3. Click in Sheet2. 4. Go to cell A1 (of Sheet2). 5. Home / Clipboard / Paste / Paste Link. Anything that you update in Sheet1 cell A1 will now be automatically updated in Sheet2 cell A1. There is an example of the above at:- www.pierrefondes.com - second example down (with the words JANEASH in it). If you look at Sheet2 and Sheet3 of this Workbook anything that is updated in Sheet2 is automatically updated in Sheet3. If my comments have been helpful to you please click Yes. Thanks! "~genevieve" wrote: Hello, I have been trying to figure this one simple question (or not so simple) out. Is it possible to tie information contained on a master sheet within one Excel workbook to a different sheet in the same workbook? For example, I have a master list with both the year 2009 and 2010 in it and I want to make it so that if information typed into this master list contains either 2009 or 2010 it goes to that specific sheet. So far, I have been filtering by year and manually cutting and pasting the information into the respective sheets. Is it possible to program Excel to automatically recognize this in the workbook? If so, all I need is the terminology used for this command and I can figure it out from there! If anyone happens to know, I would greatly appreciate it! Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Connecting a master sheet to other sheets within the same workbook
This is a simple macro recording of what you did manually (provided sheets
named "Master", "2009", "2010" exist). Sub Macro1() Sheets("Master").Select Selection.AutoFilter Selection.AutoFilter Field:=1, Criteria1:="2009" Selection.CurrentRegion.Select Selection.SpecialCells(xlCellTypeVisible).Select Selection.Copy Sheets("2009").Select Range("A1").Select ActiveSheet.Paste Sheets("Master").Select Application.CutCopyMode = False Selection.AutoFilter Field:=1, Criteria1:="2010" Selection.CurrentRegion.Select Selection.SpecialCells(xlCellTypeVisible).Select Selection.Copy Sheets("2010").Select Range("A1").Select ActiveSheet.Paste Sheets("Master").Select Application.CutCopyMode = False Selection.AutoFilter End Sub Re-run it, e.g. via a hot key, as required! Regards, Stefi €˛~genevieve€¯ ezt Ć*rta: Hello, I have been trying to figure this one simple question (or not so simple) out. Is it possible to tie information contained on a master sheet within one Excel workbook to a different sheet in the same workbook? For example, I have a master list with both the year 2009 and 2010 in it and I want to make it so that if information typed into this master list contains either 2009 or 2010 it goes to that specific sheet. So far, I have been filtering by year and manually cutting and pasting the information into the respective sheets. Is it possible to program Excel to automatically recognize this in the workbook? If so, all I need is the terminology used for this command and I can figure it out from there! If anyone happens to know, I would greatly appreciate it! Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste all sheets into one master sheet | Excel Worksheet Functions | |||
Other sheets to pick data from master sheet | Excel Discussion (Misc queries) | |||
Generating Master sheet from child sheets | Excel Discussion (Misc queries) | |||
Getting info from individual sheets into master sheet | Excel Worksheet Functions | |||
Getting info from individual sheets into master sheet | Excel Discussion (Misc queries) |