Copying and pasting a long row has issues

N

nachobear

New Member
Joined
Feb 1, 2024
Messages
25
Office Version
  1. 365
Platform
  1. Windows
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
 
Sort by date Sort by votes
nachobear said:
Hi unsure how to tell/see if there's formulas, this workbook does have other tabs
Click to expand...
Once you have the data pasted into the cells, does something change somewhere else? You can see formulas in the top bar labelled "fx".


For now, just select 10 rows and 15 columns, then use the XL2BB to copy them and paste them into a forum post, something like this.

2024-03-05.xlsx
DEFGHIJKLMNOPQRSTUV
11-Feb-242-Feb-243-Feb-244-Feb-245-Feb-246-Feb-247-Feb-248-Feb-249-Feb-2410-Feb-2411-Feb-2412-Feb-2413-Feb-2414-Feb-2415-Feb-2416-Feb-2417-Feb-2418-Feb-24
2LabelThuFriSatSunMonTueWedThuFriSatSunMonTueWedThuFriSatSun
3Thing 16.46.65.41.67.36.34.29.54.74.5113.8
4Thing 27.94.89.168.9353.39.767.510.2
5Thing 32.32.410.58.910.91.38.47.17.78.59.37.9
6Thing 435.49.9119.43.96.275.52.436.6
7Thing 57.42.42.25.43.710.18.52.97.910.67.65.4
8Thing 63.510.4101.41.32.33.89.57.22.379.5
9Thing 75.16.99.72.58.47.86.16.23.42.885.4
10Thing 88.13.21.44.84.910.91110.15.32.73.49
11Thing 91.98.31.61.74.96.61.33.79.61.72.29.7
12Thing 108.77.127.19.42.710.52.64.91.81.69.3
13Thing 118.17.71.41.91.25.15.62.48.71.38.610.3
14Thing 122.94.34.51.63.54.77.57.145.63.69.7
15Thing 131.466.58.13.72.561.310.67.19.16.5
16Thing 147.59.46.33.34.33.26.63.38.67.110.810.4
17Thing 154.99.75.66.410.5103.22.36.78.98.17
18Thing 165.97.28.910.69.39.97.88.71.59.72.78.2
Destination
Cell Formulas
RangeFormula
F1:V1F1=E1+1
E2:V2E2=TEXT(WEEKDAY(E1,1),"Ddd")
 
Upvote 0

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
yes somethings do change since there will be calculations done

1709850788378.png




i don't see formulas at the top where there's an FX

I think im doin this wrong

APS:SELECT SCHOOL
Time Reporter:
December 2023
0104050607081112131415
POSITIONEMPLOYEEFMTWTHFMTWTHF
TPS3.10
PS
PS
PW
PW
PW
adjustments:
0.0​
TPS
3.10​
0.00​
0.00​
0.00​
0.00​
0.00​
0.00​
0.00​
0.00​
0.00​
0.00​
0.00​
0.00​
0.00​
SELECT SCHOOL
 

Attachments

  • 1709850712179.png
    1709850712179.png
    27.2 KB · Views: 7
Upvote 0
Calculations are formulas.

What you have posted is not copied using XL2BB's mini sheet tool. Please refer to the usage instructions as Mark858 recommended in post #25. The red-circled button in the screenshot below is how you get the formulas and other features to copy to your clipboard so you can paste here.

1709857069434.png
 
Upvote 0
the Too Many Cells message i get when i click the mini sheet

1709857417547.png
 

Attachments

  • 1709857372603.png
    1709857372603.png
    50.8 KB · Views: 7
Upvote 0
Asbestos_Jen said:
What range are you selecting?
Click to expand...

I think I did it right now, for the highlight, i was starting my highlights from the bottom right of the selection, I thought i had to select from the top or left side of the excel

though the paste is different

test.xlsx
ABCILMNOPSTUVWAO
1APS:0SELECT SCHOOL
2Time Reporter:0
4December 2023
60104050607081112131415TOTAL:
7POSITIONEMPLOYEEFMTWTHFMTWTHF
8TPS3.103.10
90.00
10PS0.00
110.00
12PS0.00
130.00
14PW0.00
150.00
SCHOOL 8
Cell Formulas
RangeFormula
S1S1=Top!D28
C1:C2C1=Top!D13
A4A4=Top!D11&" "&Top!D12
I6I6=Days+1+DATE(Calendar1Year,Calendar1MonthOption,1)-WEEKDAY(DATE(Calendar1Year,Calendar1MonthOption,1),WeekdayOption)
L6:P6L6=Days+8+DATE(Calendar1Year,Calendar1MonthOption,1)-WEEKDAY(DATE(Calendar1Year,Calendar1MonthOption,1),WeekdayOption)
S6:W6S6=Days+15+DATE(Calendar1Year,Calendar1MonthOption,1)-WEEKDAY(DATE(Calendar1Year,Calendar1MonthOption,1),WeekdayOption)
AO8:AO15AO8=SUM(D8:AN8)
Press CTRL+SHIFT+ENTER to enter array formulas.
Named Ranges
NameRefers ToCells
'SCHOOL 8'!WeekStart='SCHOOL 8'!$D$5S6:W6, L6:P6, I6
Cells with Conditional Formatting
CellConditionCell FormatStop If True
A8:A31Cell Value=$BD$6textNO
A8:A31Cell Value=$BC$6textNO
A8:A31Cell Value=$BB$6textNO
A8:A31Cell Value=$BA$6textNO
A8:A31Cell Value=$AZ$6textNO
A8:A31Cell Value=$AY$6textNO
A8:A31Cell Value=$AX$6textNO
A8:A31Cell Value=$AW$6textNO
A8:A31Cell Value=$AV$6textNO
A8:A31Cell Value=$AU$6textNO
A8:A31Cell Value=$AT$6textNO
A8:A31Cell Value=$AS$6textNO
A8:A31Cell Value=$AR$6textNO
E8:AO24Expression=INDIRECT("BC"&ROW())="UPDATED"textNO
C1:C2Cell Value=0textNO
A2Cell Value=0textNO
D8:AN24Cell Value>=10textNO
D6:AN6Expression=MONTH(D6)<>Calendar1MonthOptiontextNO
A8:A31Cell Value=$AQ$6textNO
A8:A31Cell Value=$AP$6textNO
Cells with Data Validation
CellAllowCriteria
A8:A15List=$BE$8:$BE$22
 
Upvote 0
Glad you got it figured out! Unfortunately, based on the formulas I can see, that's the reason you get the "array" error when trying to delete columns.

If you can't modify the layout of your source data, it may be easiest to make a blank workbook to paste the data from your source into, then insert the two columns missing from each week into that, then paste, then copy again and paste into your destination. The only other solution I see without messing up your destination sheet is to copy the data five columns at a time and then paste them into the right cells.

My only other suggestion would be to talk to someone else in your organization (if possible) and ask them how they go about it.

Sorry I don't have any better options for you.
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Solved
copy paste and the window pops up
Replies
3
Views
105
Alex Blakenburg
A
K
  • Question Question
Increasing row before the macro runs again
Replies
1
Views
211
kbk
K
A
  • Question Question
VBA Copy/Paste New Data Only
Replies
0
Views
434
ah2024_2024
A
P
  • Solved
What does this code do or mean
Replies
2
Views
166
Perrister
P
FrumpyJones
  • Question Question
Is there a way to stop COPY/PASTE but still allow manual entries and use of drop down lists.
Replies
5
Views
253
FrumpyJones
FrumpyJones

Forum statistics

Threads
1,223,909
Messages
6,175,310
Members
452,634
Latest member
cpostell

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top