Insert cells for new data, delete unused cells

dstone8484

New Member
Joined
Jun 20, 2012
Messages
1
I have about 6 external access queries linked on 1 excel sheet. For the external properties I have chosen Insert cells for new data, delete unused cells, dont adjust column widths, and keep cell formating.

Adding and losing rows ussallys works OK except when there is no data in one of the queries. When there is no data, 1 record stays and replaces the header row. (Even though the queries does not come back with any results). The header row is the one being deleted instead of the record row

Can anyone help with this
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

pbornemeier

Well-known Member
Joined
May 24, 2005
Messages
3,881
Run the queries sequentially to retrive data to the "Transfer" worksheet as follows
Clear the Transfer worksheet.
Run the first query.
Code code to check if more than 1 row present.
If more than 1 present, copy to appropriate spot on the original destination worksheet.
Repeat for next query.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,370
Messages
5,595,774
Members
414,018
Latest member
quang118

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top