Hi. Hello everyone. I'm looking forward to being active in this forum.

In the meantime I have a data import problem.

A database is generating an excel workbook (called "postings.xls"). I have no control over the DB method of export. The data is simply dumped in a sheet with no headers. The exported data is always in the same format & column locations but the column lengths can be any number of rows. I am only interested in the information in column H from the postings sheet. My problem is when I import the whole postings.xls sheet into a table in my new worksheet (RevenueChecker.xlsx). The new table for some inexplicable reason changes the position of the columns. For example the original column H import can end up in column I one day and then column P the next, I've had the information I want appear in virtually any column from B to I.

All I want to do is create a new imported sheet, within my RevenueChecker workbook, which is an exact copy of the exported postings.xls sheet. I've checked all the DB exported postings.xls sheets and the info I need is always in column H. Yet as mentioned, once imported into my RevenueChecker it can appear in any column. I have tried creating links direct to the postings.xls workbook, column H, but again the problem is that the update is hit and miss and I end up with #ref errors. So to summarise, I need to create a foolproof link to the info in postings.xls, column H, which is available to my RevenueChecker.xlsx workbook.

The workbook (as mentioned), is automatically generated by a proprietary DB each night. The RevenueChecker workbook is then opened by my colleague who is IT illiterate. The RevenueChecker (which I have created) is returning spurious data because #ref errors are produced when the location of the column H data cannot be found consistently.

Any help on this problem would be greatly appreciated.