Cannot Copy Examples Any More

[Jeffrey Mahoney]

When we could post HTML, I could copy the examples into Excel and use that for creating quick formulas. Now I have to type all the data out myself.

This is going to prevent me from responding to most of the posts. That is sad.

 

[Peter_SSs]

Can you point to some examples where you have not been able to copy?
Plenty of sample data here is able to be copied but if people only post images you cannot - but that was the case in the old forum too.

 

[Peter_SSs]

Some examples

This (XL2BB) can be copied. Look to the bottom of this post to see how.

Book1
	A	B	C	D	E	F	G	H	I	J
1	Month	1	1	1	2	2	2	3	3	3
2	Company	a	b	c	a	b	c	a	b	c
3	Item A	A-1-a	A-1-b	A-1-c	A-2-a	A-2-b	A-2-c	A-3-a	A-3-b	A-3-s
4	Item B	B-1-a	B-1-b	B-1-c	B-2-a	B-2-b	B-2-c	B-3-a	B-3-b	B-3-c
5
6	Company	a	a	a	b	b	b	c	c	c
7	Month	1	2	3	1	2	3	1	2	3
8	Item A	A-1-a	A-2-a	A-3-a	A-1-b	A-2-b	A-3-b	A-1-c	A-2-c	A-3-s
9	Item B	B-1-a	B-2-a	B-3-a	B-1-b	B-2-b	B-3-b	B-1-c	B-2-c	B-3-c
Rearrange

Cell Formulas
Range	Formula
B8:J9	B8	=INDEX($B$3:$J$4,MATCH($A8,$A$3:$A$4,0),MATCH(B$7,$B$1:$J$1,0)+MATCH(B$6,$B$2:$J$2,0)-1)

This (copy/paste from Excel) can be copied

Company	a	a	a
Month	1	2	3
Item A	A-1-a	A-2-a	A-3-a
Item B	B-1-a	B-2-a	B-3-a

This (insert table) can be copied

Data 1	Data 2
23	abc

 

[Jeffrey Mahoney]

Ok, I assumed that the images were from the XLBB. I was wrong. I guess I'll encourage people not to paste XLBB instead of images

 

[Fluff]

Hopefully that will be

Ok, I assumed that the images were from the XLBB. I was wrong. I guess I'll encourage people not to paste XLBB instead of images