| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Same Column on Two Sheets (Auto-update / match)?
Hi. I have two sheets in the same workbook. I need a column on the 2nd
sheet to match a column on the 1st sheet. So that when data is entered into this column on sheet1 it is also entered automatically on sheet2. Is this possible? I tried to set the column on sheet2 to =Sheet1!A1, but when I delete/add rows to sheet1 it does not update sheet2. Any advice would be greatly appreciated! Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto update helper column | Excel Discussion (Misc queries) | |||
| Auto update the chart range for new sheets | Charts and Charting in Excel | |||
| HOW DO I GET COLUMN TOTALS TO AUTO UPDATE? | New Users to Excel | |||
| Auto Update Info from Different Sheets? | Excel Discussion (Misc queries) | |||
| Vlookup? to match column in two sheets | Excel Discussion (Misc queries) | |||
Threaded Mode
