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) |