[Help Requested] Manual data won't allign with query data in a table.

[TbSpoekie]

Hello everyone.

This is my first time posting to this site so I apologize for any trouble this may cause in terms of what might be expected and what not.

Anyways. I'm currently having a problem where I have both data from an ODBC query and data that was manually put into a table. This works fine till the query starts to refresh and it either removes or adds new entries. The query will expand or shrink but the manual data will just sit there on the same rows they were put in before the refresh.

What I've tried so far is to see what the different options do when I right click on the table and go to Table>Data Range Properties. Sadly, they didn't help all that much.

So my question is, how can I get the manual data to allign with the query?

The only solution I can think of is to create a macro that copies the manual input into another sheet with the reference numbers and replacing the column of the manual input with a vlookup formula that refers to that data upon either saving or exiting the workbook. Upon refreshing the table the final step would be for the formulas to be converted to definite values.

Thank you for your time and I hope someone knows a better solution for this.

 

[hiker95]

TbSpoekie,

Welcome to the MrExcel forum.

What version of Excel are you using?

Can you post a screenshot of the raw data worksheet, and, post a screenshot of the worksheet results (manually formatted by you) that you are looking for?

To post your data, you can download and install one of the following two programs:
Excel Jeanie
MrExcel HTML Maker


If you are not able to give us screenshots:
You can upload your workbook to Box Net,
sensitive data changed
mark the workbook for sharing
and provide us with a link to your workbook.