Copying and pasting a long row has issues

[nachobear]

Hi

Wanted to see why I can't properly paste an entire row on cells like a few weeks worth from online excel to a die loaded excel file

The copy part isn't the issue only the paste part

And I think the message I get is

The data your pasting isn't the sane size as your selection. Do you want to paste this anyways?

This is related to my last post in a way that, but that post is answered.

Just that when I paste them I don't paste all the items that I have copied.

It only lets me copy and paste within a week, that's when there's no issues but when it's going pass the five days then the message pops up

 

[Alex Blakenburg]

How are you copying and pasting the data, manually or through code. If you are using code show us the code ?
If manual are you copying within the same workbook or to another workbook. Can you show us what your selection looks like when you hit copy (include column & row references in the screenshot) and what you have highlighted when you hit paste.

 

[nachobear]

online excel

copy

-------------------------------

after paste

downloaded file

the paste skipped 5, 6, 14,15,23,26

 

[nachobear]

online excel

copy

View attachment 107837



-------------------------------

after paste

downloaded file
View attachment 107838

the paste skipped 5, 6, 14,15,23,26

this is a manual copy and paste

copying from one online excel file and pasting to a different file

 

[Asbestos_Jen]

Neither of your pictures show the sheet's column labels. Are there any columns hidden in either sheet?

 

[nachobear]

the downloaded excel below has hidden stuff which are the weekends

---------------------------

copy screenshot

hoping these pics give more info

 

[Asbestos_Jen]

Does your source (copy from) sheet have the same columns hidden, or are the weekends just absent? When you unhide the weekends on your destination (paste to) sheet, can you see data pasted into them? If so, your problem is misalignment of the columns themselves.

 

[nachobear]

Does your source (copy from) sheet have the same columns hidden, or are the weekends just absent? When you unhide the weekends on your destination (paste to) sheet, can you see data pasted into them? If so, your problem is misalignment of the columns themselves.

my source (copy form) doesn't have the weekends, its absent

Yes your right when I unhide the Weekends there is info on there, how can i fix that it won't paste for the weekends?

Thank you

 

[Asbestos_Jen]

I don't know a way to do it all at once without making the columns match, either by deleting them from your destination or inserting them into your source.

 

[nachobear]

I don't know a way to do it all at once without making the columns match, either by deleting them from your destination or inserting them into your source.

how do I delete the weekends from the destination, new to excel