| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking a reference from one worksheet to another, in the same book(without moving when a row is added)
Hello,
I am having trouble locking a reference from one worksheet to another, in the same book (without moving when a row is added). I want to be able to input data on the first page and it automatically populate the second page in a different order. My problem occurs when I insert a row on the first page, the second page doesnt note the change. If I re-drag the reference formulas down each time, it will change... but I would prefer to not have to do that. An example, with sheet names (1st page and only page that has data ever input) SchedC and 2nd page (automatically populates in a different order) Catalog would be perfect. Thank you! EggHeadCafe - Software Developer Portal of Choice WPF DataGrid Custom Paging and Sorting http://www.eggheadcafe.com/tutorials...tom-pagin.aspx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Moving worksheets to another book - 2nd book will not appear | Excel Discussion (Misc queries) | |||
| automatically change the worksheet reference when new sheet added | Excel Worksheet Functions | |||
| Moving a sheet from one work book to another? | Excel Worksheet Functions | |||
| Moving worksheets in a book | Excel Worksheet Functions | |||
| Using a cell reference to refernce worksheet in another work book | Excel Worksheet Functions | |||
Threaded Mode
