i've queried database which is created by sql server using query table and refresh, and all the data is pull out into sheet 'sht1', i tried to copy all the unique data on column E to sheet 'sht2' in vba code by using advanced filter, but doesn't work. code is right, no error message, but it seems it just cann't copy data from 'sht1' to 'sht2'. cos i even tried just copy value on range from sht1 to sht2 on column A in vba code, it won't able to paste the value unless i manully clicked on column A and press 'Enter' key, those values will appear.
also, i tried the other way, just query the database again in sht2 as the same way i queried in sht1 using querytable and refresh, but all the data just cannt be shown out. i have go to tool bar edit query, i saw all the data is pull out but not in worksheet, why, i really couldnt' figured out, please, any body can help me! thank u!
also, i tried the other way, just query the database again in sht2 as the same way i queried in sht1 using querytable and refresh, but all the data just cannt be shown out. i have go to tool bar edit query, i saw all the data is pull out but not in worksheet, why, i really couldnt' figured out, please, any body can help me! thank u!