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
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
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
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
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