Hi guys,
This has been driving me crazy and I am currently working on a censored version I can post here but let me explain the issue.
I have 3 worksheets
- Timesheets
- Temps
- Data
All the cells in the timesheets worksheet with user inputted data in have formulas pointing to the data spreadsheet. So basically I import my data from my database into the data worksheet and timesheet worksheet picks it all up from there. Simple.
The temps timesheet is a huge list of worker details, these worker details match the details in the data sheet; so what happens is:
- Input data in data sheet
- Timesheets worksheet picks up the reference number from the data sheet
- Does a vlookup on the temp sheet to match the right record
Ok so it was all working 100% fine until I started using my real data. The ref number in the data sheet appears in the box on the timesheets sheet but the vlookup doesn't work!
The weirdest thing about it is that if I go to the temps sheet, copy a list of reference numbers and paste them in on the data sheet it works!!! although the numbers are exactly the same!!!!!!!
This have probably confused you but has anybody experienced the same problem? At least until I upload a sample workbook.
Thanks in advance.
Dan
Bookmarks