F
FB
I am using a query to import data from an Access database into an Excel
spreadsheet. I want to type additional data in columns adjacent to the
imported data. This typed in data is not in the Access database. However,
whenever I update the imported data the rows of imported data shift up and
down to make room for new info but the data typed in does not stay with the
appropriate entry. Is there a way to make a cell stay in the same row as
specific imported data? In other words when imported data needs to be added
how do I make the entire row move not just the imported part?
spreadsheet. I want to type additional data in columns adjacent to the
imported data. This typed in data is not in the Access database. However,
whenever I update the imported data the rows of imported data shift up and
down to make room for new info but the data typed in does not stay with the
appropriate entry. Is there a way to make a cell stay in the same row as
specific imported data? In other words when imported data needs to be added
how do I make the entire row move not just the imported part?