LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 14th 09, 08:58 PM posted to microsoft.public.excel.misc
external usenet poster
First recorded activity by ExcelBanter: Dec 2007
Posts: 2,722
Default Copy/pasteSpecial transpose, does not work.

Do the cells being copied contain formulas? That could be causing strange
things to happen when you transpose them.
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

"Phil Smith" wrote:

This is very simple. I copy this:

customer_id CustType active Sales Revenue
8174 CORE WHOLESALE Y $53,678

Using paste Special/transpose I get:

100801 EAST
1245 SPIN
1585 Swim
$100,987 SURF

The really funny thing is that second coloumn comes from data in a
coloumn that I deleted BEFORE the copy, because it contained customer
names that I did not want to publish here.

Shouldn't I get:

Customer_id 8174
CustType Core Wholesale
active Y
Sales Revenue $53,678

From that operation? I KNOW I should not get data that is NOT in what
is copied.


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
copy, paste and transpose formula's into work sheets Derro Excel Worksheet Functions 2 January 13th 09 12:29 PM
Copy Chart and PasteSpecial PCLIVE Charts and Charting in Excel 2 October 26th 06 03:01 PM
Copy PasteSpecial not working Richard Buttrey Excel Worksheet Functions 9 August 11th 06 04:40 PM
Automate Copy / PasteSpecial carl Excel Worksheet Functions 1 March 29th 06 07:07 PM
Command Button for PasteSpecial - Values - Transpose Alisha Excel Discussion (Misc queries) 0 March 10th 06 09:39 PM

All times are GMT +1. The time now is 05:22 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017