I have a query set up on a master data Excel sheet to extract various columns and put the details on to a 'Timesheet' (again Excel). My problem is that the project nos are not all being pulled through. Some of them are a mixture of text and nos (eg XXX123) while others (the ones not being pulled over) are just five figure nos. Does anyone know a way around this? Thanks in advance for any help.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Problem with query
- Thread starter Mudface
- Start date
). Use text-columns on the existing data, format the column as text for any additional data added afterwards. Jeesh.Jack in the UK
Well-known Member
- Joined
- Feb 16, 2002
- Messages
- 3,215
Hi Mudface
sorry mate did not see this else could have advised worth remember t to c cover many issues in downloads.
watch them arrows lines can be off the mark thou:
sorry mate did not see this else could have advised worth remember t to c cover many issues in downloads.
watch them arrows lines can be off the mark thou:
Upvote
0
Similar threads
- Question
