Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic refresh in linked worksheet if row is added
I have two worksheets, one is the master sheet, the second is linked
to the master such that specific columns in the master sheet appear in the second worksheet. This is primarily so that I can sort dates and create a gantt chart in the second sheet without using alot of the unnecessary info in the master sheet. However, if I add a new row in the master sheet, the new data does not appear in the second sheet unless I retype the link in the first cell of the column, and click and drag down the column every time. Is there a better way of doing this so that any new data that is added (at the end of, in the middle of) the master sheet will refresh and appear in the second sheet automatically? Thank you |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic refresh in linked worksheet if row is added
=index(sheet1!$a:$a,row())
"Bleuberry" wrote in message ... I have two worksheets, one is the master sheet, the second is linked to the master such that specific columns in the master sheet appear in the second worksheet. This is primarily so that I can sort dates and create a gantt chart in the second sheet without using alot of the unnecessary info in the master sheet. However, if I add a new row in the master sheet, the new data does not appear in the second sheet unless I retype the link in the first cell of the column, and click and drag down the column every time. Is there a better way of doing this so that any new data that is added (at the end of, in the middle of) the master sheet will refresh and appear in the second sheet automatically? Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i get an automatic refresh of a worksheet in excel | Excel Worksheet Functions | |||
Automatic row added in when there is Charge of more than $0. | Excel Discussion (Misc queries) | |||
How can I 'Enable Automatic Refresh' for Query Refresh by default | Setting up and Configuration of Excel | |||
Rows added after refresh not in formula | Excel Worksheet Functions | |||
Query Refresh-Enable Automatic Refresh Dialogue Box | Excel Discussion (Misc queries) |