Database import
I have imported data to a worksheet from a query. No problems there.
Then I've manually input data into columns to the right of the imported data. I'd like to keep the imported data and the data manually input on the same rows, so i've check the "Insert entire rows for new data, clear unused cells" option from the Data Range Properties menu. However, when the imported data is refreshed, it only adds cells instead of an entire row. Can anyone help with this problem? |
Database import
Then I've manually input data into columns to the right of the
imported data. *I'd like to keep the imported data and the data manually input on the same rows Is the manual data based on calculations of queried fields? Cliff Edwards |
Database import
Is the manual data based on calculations of queried fields? Cliff Edwards No, it is just additional information on each entry. |
Database import
I believe that MS Query will clear any cells in rows in the query
range that aren't part of the query or formulas. You may have to make some sort of lookup table to get the manual information on the correct rows. I usually keep seperate query sheets in my projects that only contain the query and formulas that calculate additional fields, then copy pertinent info to summary or report sheets. If you resolve without using either of these methods, please post. Cliff Edwards |
All times are GMT +1. The time now is 07:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com