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

 

[Asbestos_Jen]

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

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
	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1		1-Feb-24	2-Feb-24	3-Feb-24	4-Feb-24	5-Feb-24	6-Feb-24	7-Feb-24	8-Feb-24	9-Feb-24	10-Feb-24	11-Feb-24	12-Feb-24	13-Feb-24	14-Feb-24	15-Feb-24	16-Feb-24	17-Feb-24	18-Feb-24
2	Label	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun
3	Thing 1	6.4	6.6			5.4	1.6	7.3	6.3	4.2			9.5	4.7	4.5	11	3.8
4	Thing 2	7.9	4.8			9.1	6	8.9	3	5			3.3	9.7	6	7.5	10.2
5	Thing 3	2.3	2.4			10.5	8.9	10.9	1.3	8.4			7.1	7.7	8.5	9.3	7.9
6	Thing 4	3	5.4			9.9	11	9.4	3.9	6.2			7	5.5	2.4	3	6.6
7	Thing 5	7.4	2.4			2.2	5.4	3.7	10.1	8.5			2.9	7.9	10.6	7.6	5.4
8	Thing 6	3.5	10.4			10	1.4	1.3	2.3	3.8			9.5	7.2	2.3	7	9.5
9	Thing 7	5.1	6.9			9.7	2.5	8.4	7.8	6.1			6.2	3.4	2.8	8	5.4
10	Thing 8	8.1	3.2			1.4	4.8	4.9	10.9	11			10.1	5.3	2.7	3.4	9
11	Thing 9	1.9	8.3			1.6	1.7	4.9	6.6	1.3			3.7	9.6	1.7	2.2	9.7
12	Thing 10	8.7	7.1			2	7.1	9.4	2.7	10.5			2.6	4.9	1.8	1.6	9.3
13	Thing 11	8.1	7.7			1.4	1.9	1.2	5.1	5.6			2.4	8.7	1.3	8.6	10.3
14	Thing 12	2.9	4.3			4.5	1.6	3.5	4.7	7.5			7.1	4	5.6	3.6	9.7
15	Thing 13	1.4	6			6.5	8.1	3.7	2.5	6			1.3	10.6	7.1	9.1	6.5
16	Thing 14	7.5	9.4			6.3	3.3	4.3	3.2	6.6			3.3	8.6	7.1	10.8	10.4
17	Thing 15	4.9	9.7			5.6	6.4	10.5	10	3.2			2.3	6.7	8.9	8.1	7
18	Thing 16	5.9	7.2			8.9	10.6	9.3	9.9	7.8			8.7	1.5	9.7	2.7	8.2
Destination

Cell Formulas
Range	Formula
F1:V1	F1	=E1+1
E2:V2	E2	=TEXT(WEEKDAY(E1,1),"Ddd")

 

[nachobear]

yes somethings do change since there will be calculations done

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

01

04

05

06

07

08

11

12

13

14

15

POSITION

EMPLOYEE

F

M

T

W

TH

F

M

T

W

TH

F

TPS

3.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

 

[Asbestos_Jen]

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.

 

[nachobear]

the Too Many Cells message i get when i click the mini sheet

 

[Asbestos_Jen]

What range are you selecting?

 

[nachobear]

What range are you selecting?

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
	A	B	C						I			L	M	N	O	P			S	T	U	V	W																		AO
1	APS:		0																SELECT SCHOOL
2	Time Reporter:		0
4	December 2023
6									01			04	05	06	07	08			11	12	13	14	15																		TOTAL:
7	POSITION	EMPLOYEE							F			M	T	W	TH	F			M	T	W	TH	F
8	TPS											3.10																													3.10
9																																									0.00
10	PS																																								0.00
11																																									0.00
12	PS																																								0.00
13																																									0.00
14	PW																																								0.00
15																																									0.00
SCHOOL 8

Cell Formulas
Range	Formula
S1	S1	=Top!D28
C1:C2	C1	=Top!D13
A4	A4	=Top!D11&" "&Top!D12
I6	I6	=Days+1+DATE(Calendar1Year,Calendar1MonthOption,1)-WEEKDAY(DATE(Calendar1Year,Calendar1MonthOption,1),WeekdayOption)
L6:P6	L6	=Days+8+DATE(Calendar1Year,Calendar1MonthOption,1)-WEEKDAY(DATE(Calendar1Year,Calendar1MonthOption,1),WeekdayOption)
S6:W6	S6	=Days+15+DATE(Calendar1Year,Calendar1MonthOption,1)-WEEKDAY(DATE(Calendar1Year,Calendar1MonthOption,1),WeekdayOption)
AO8:AO15	AO8	=SUM(D8:AN8)
Press CTRL+SHIFT+ENTER to enter array formulas.

Named Ranges
Name	Refers To	Cells
'SCHOOL 8'!WeekStart	='SCHOOL 8'!$D$5	S6:W6, L6:P6, I6

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A8:A31	Cell Value	=$BD$6	text	NO
A8:A31	Cell Value	=$BC$6	text	NO
A8:A31	Cell Value	=$BB$6	text	NO
A8:A31	Cell Value	=$BA$6	text	NO
A8:A31	Cell Value	=$AZ$6	text	NO
A8:A31	Cell Value	=$AY$6	text	NO
A8:A31	Cell Value	=$AX$6	text	NO
A8:A31	Cell Value	=$AW$6	text	NO
A8:A31	Cell Value	=$AV$6	text	NO
A8:A31	Cell Value	=$AU$6	text	NO
A8:A31	Cell Value	=$AT$6	text	NO
A8:A31	Cell Value	=$AS$6	text	NO
A8:A31	Cell Value	=$AR$6	text	NO
E8:AO24	Expression	=INDIRECT("BC"&ROW())="UPDATED"	text	NO
C1:C2	Cell Value	=0	text	NO
A2	Cell Value	=0	text	NO
D8:AN24	Cell Value	>=10	text	NO
D6:AN6	Expression	=MONTH(D6)<>Calendar1MonthOption	text	NO
A8:A31	Cell Value	=$AQ$6	text	NO
A8:A31	Cell Value	=$AP$6	text	NO

Cells with Data Validation
Cell	Allow	Criteria
A8:A15	List	=$BE$8:$BE$22

 

[Asbestos_Jen]

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.