Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to shift a entire row down when offset is used?
I have a worksheet that contains data in one column(Column A) that is
populated into other worksheets. I use OFFSET to do this since we are always adding new data to this column that I want shared with in the other worksheet.The problem that I am running into is when I insert new data into WS1 Column A, it is shifting down the cells that are only in the OFFSET. I want to shift the entire row down in worksheet 2 since it contains other cells that are specific to specific cells from the offset. How can I associate these others cells with the offset column? Example: WS1 Row Column A Column B 1 Employee Date of Hire 2 Lisa 4-1-07 3 Lynn 4-2-07 4 Mark 4-2-07 WS2 Column A Column B Column A uses =OFFSET(AWEsinprogress!$A$1,ROW(B1)-1,COLUMN(B1)-1) 1 Employee Salary 2 Lisa 10 3 Lynn 20 4 Mark 30 for example: If I insert a new employee (alphabetically) in WS1 I will end up seeing the new entry (Liza) but the data from Column B does not move down with the shift. Row Column A Column B 1 Employee Date of Hire 2 Lisa 4-1-07 3 Liza 4-12-07 NEW 4 Lynn 4-2-07 5 Mark 4-2-07 WS2 Column A Column B Column A uses =OFFSET(AWEsinprogress!$A$1,ROW(B1)-1,COLUMN(B1)-1) 1 Employee Salary 2 Lisa 10 3 Liza 20 4 Lynn 30 5 Mark -- Priscilla |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
shift scheme | Excel Discussion (Misc queries) | |||
No entire view in edited shift dropdown list Nursing Schedule Exc | New Users to Excel | |||
Shift Cells Up | Excel Discussion (Misc queries) | |||
shift right 5 columns | Excel Worksheet Functions | |||
Auto Shift | Excel Discussion (Misc queries) |