| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Partially refreshing spreadsheet
I have a spreadsheet in which columns A-L are populated by SQL query through
an ODBC connection. Columns M-P are for data that I update manually. When I refresh the spreadsheet and records are added or removed, the fields in columns A-L move up or down accordingly, but columns M-P stay in place, causing mismatches between records. Is there any way to tie columns M-P to A-L so that blank fields are inserted when a new record is inserted and the fields are deleted when a record is deleted? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Scrolling Partially Through a Cell | Excel Discussion (Misc queries) | |||
| Partially fill cells | Excel Discussion (Misc queries) | |||
| partially protecting a worksheet? | Excel Discussion (Misc queries) | |||
| Auto refreshing and printing a form with data from each row of a spreadsheet | Excel Discussion (Misc queries) | |||
| How can I maintain spreadsheet formating when refreshing import da | Excel Discussion (Misc queries) | |||
Linear Mode
