Daniel Pineault
asked on
Can't copy content between 2 workbooks
I'm trying to copy 900 rows A through K of data from one workbook sheet to another workbook sheet and keep getting
Why?
I've done this 100s of time without issue, but now suddenly it won't work. Is there a known bug, some new feature change?
Why?I've done this 100s of time without issue, but now suddenly it won't work. Is there a known bug, some new feature change?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Can you supply a sample workbook?
ASKER
@Martin, sadly I cannot as this in under NDA.
@zorvek, I will go through the data looking for merged cells (there should be any, but I didn't make the workbook.
This workbook has given me all sorts of other headaches trying to import into Access, so there are definitely issue, but identifying them is the issue.
@zorvek, I will go through the data looking for merged cells (there should be any, but I didn't make the workbook.
This workbook has given me all sorts of other headaches trying to import into Access, so there are definitely issue, but identifying them is the issue.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
In amongst the rows there were 2 rows where they merged a couple columns.
You should also give credit to zorvek since he suggested the reason for the problem.
ASKER
@Martin - Entirely right. Thank you for pointing that out.
Kevin