I have two excel files. One is "Ferien" one is "Book 1"
From "Ferien" i take data in "Book 1" but not all data is in there.
Ferien excel.jpg This is from "Ferien"
book.jpg And this is from "Book 1"
Can you tell me why in column H there is not data?
Thank you
Last edited by Anto_BT; 01-18-2016 at 07:30 AM. Reason: Solved
We cannot see your spreadsheet; just a picture of one. That's not really much use.
Please attach a sample workbook. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!
Just before you submit your post, click on GO ADVANCED (near the bottom) and EITHER click "Manage Attachments" OR use the paperclip icon to open the upload window.
The paperclip icon
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
I've uploaded two files so Ferien needs to be open when i refresh.
Thank's for response
Password for Ferien is ok00
Which macro are you using to import the data from ferien?
I've just connected in Data Connection with Ferien. After that the macro is to insert all data fro each town in other sheet and to save in different workbook.
Everything is working perfect just when I refresh there is nothing in column H in Book 1 and in Ferien it is data. Filter San Antonino.
Thank's
The problem was solved.
I've replaced empty columns with "-" and then it was working.
Thank's
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks