Cannot Copy Examples Any More

Jeffrey Mahoney

Well-known Member
Joined
May 31, 2015
Messages
1,591
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

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
41,707
Office Version
365
Platform
Windows
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

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
41,707
Office Version
365
Platform
Windows
Some examples

This (XL2BB) can be copied. Look to the bottom of this post to see how.
xl2bb.xlam
ABCDEFGHIJ
1Month111222333
2Companyabcabcabc
3Item AA-1-aA-1-bA-1-cA-2-aA-2-bA-2-cA-3-aA-3-bA-3-s
4Item BB-1-aB-1-bB-1-cB-2-aB-2-bB-2-cB-3-aB-3-bB-3-c
5
6Companyaaabbbccc
7Month123123123
8Item A
9Item B
Rearrange
Cell Formulas
Range(s)Formula
B8:J9B8=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

Companyaaa
Month123
Item AA-1-aA-2-aA-3-a
Item BB-1-aB-2-aB-3-a


This (insert table) can be copied
Data 1Data 2
23abc
 

Jeffrey Mahoney

Well-known Member
Joined
May 31, 2015
Messages
1,591
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
 

Forum statistics

Threads
1,077,782
Messages
5,336,284
Members
399,074
Latest member
rlong98

Some videos you may like

This Week's Hot Topics

Top