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

 

[MARK858]

and its showing the macros message

Can you post the message that you are getting now please

 

[nachobear]

Can you post the message that you are getting now please

sorry, i click enable and i get a blank excel screen

 

[MARK858]

XL2BB is there in your ribbon, just click File and New or File and the workbook you want open

 

[nachobear]

so once i open the file within the XL2BB what do i do next?

 

[MARK858]

You select the range you want to show and Click the XL2BB icon.... The instructions on usage are in the XL2BB page in the link

 

[nachobear]

HI so I get the 3000 cells message

 

[Asbestos_Jen]

Try selecting a smaller set, say 12-15 columns and 10-20 rows. If there are a bunch of data entry rows (or columns) and then calculations at the bottom (or right), hide most of the data rows so we can see the calculations.

 

[nachobear]

HI So when i try to hide the rows or anything it gets replaced with more rows etc

 

[Asbestos_Jen]

Do you have any formulas to the far right or bottom of your data?

Does the workbook have more than one worksheet (tab) of data in it?

 

[nachobear]

Do you have any formulas to the far right or bottom of your data?

Does the workbook have more than one worksheet (tab) of data in it?

Hi unsure how to tell/see if there's formulas, this workbook does have other tabs