Learner123
08-25-2011, 07:44 AM
Hi,
I am faced with a dilemma when importing data into Excel 2007.
A simplified version of my problem:
I am importing a table from a database (also Excel 2007) that has data in column A. The data imports into column A of the new workbook, which works fine.
The problem occurs in column B of the new workbook. Columns B in the new workbook requests a manual entry, which the user enters based on the data that is imported into columns A of the same row. The new workbook is saved and closed. Now if the database is adjusted by deleting an existing data cell in column A, the new workbook refreshes column A but column B does not adjust to the change. Is it possible to have Column B inputs adjust accordingly to the change in imported data?
Basically, what happens is that when one cell of data is deleted from the database, the import range shifts up causing a misalignment between column A and B. Any clever way to address this?
Thank you in advance for your help!
I am faced with a dilemma when importing data into Excel 2007.
A simplified version of my problem:
I am importing a table from a database (also Excel 2007) that has data in column A. The data imports into column A of the new workbook, which works fine.
The problem occurs in column B of the new workbook. Columns B in the new workbook requests a manual entry, which the user enters based on the data that is imported into columns A of the same row. The new workbook is saved and closed. Now if the database is adjusted by deleting an existing data cell in column A, the new workbook refreshes column A but column B does not adjust to the change. Is it possible to have Column B inputs adjust accordingly to the change in imported data?
Basically, what happens is that when one cell of data is deleted from the database, the import range shifts up causing a misalignment between column A and B. Any clever way to address this?
Thank you in advance for your help!