Excel Query Problems, Not Getting All Data

murphy00 · Apr 17th, 2002, 10:54 AM

I have a macro getting info from another workbook from columns A thru D. On some sheets the query will return all of the data. On others it will not return data from column B. I have checked the source workbook that is being queried and it does have data that it is not getting.

Anyone have any ideas on how to fix this?

murphy00 · Apr 17th, 2002, 11:24 AM

The column the data will not come from contains Room numbers. I have found that it will return anything that looks like text. If the data is a number it will not return it. Example: it will return 33/16 but won't return 100.
I have formatted the source column as general and have tried text. Neither work.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 17th, 2002, 10:54 AM	#1
murphy00 New Member Join Date: Feb 2002 Posts: 15	I have a macro getting info from another workbook from columns A thru D. On some sheets the query will return all of the data. On others it will not return data from column B. I have checked the source workbook that is being queried and it does have data that it is not getting. Anyone have any ideas on how to fix this?

Apr 17th, 2002, 11:24 AM	#2
murphy00 New Member Join Date: Feb 2002 Posts: 15	The column the data will not come from contains Room numbers. I have found that it will return anything that looks like text. If the data is a number it will not return it. Example: it will return 33/16 but won't return 100. I have formatted the source column as general and have tried text. Neither work.