Paste formats and transpose issues.

shreked12

Rules violation
Joined
Mar 14, 2019
Messages
17
Hi

I have a workbook with 6 sheets. Sheets 1-5 I have data in and im copying data into specific cells in sheet 6.

I use paste special- format and also select transpose.

It works fine with sheet 1 when pasting onto sheet 6 but then when trying to copy and paste from sheet 2 onwards it not working.

Any ideas?
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
13,432
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
What error messages do you get?
 

shreked12

Rules violation
Joined
Mar 14, 2019
Messages
17
None at all.

I just go onto sheet 2 and copy what I need to transfer over and then do the paste special- format and transpose and it dont do nothing.

I thought it was cos all the data on sheet 6 are in the same column but in different rows but that no different.

What it is ive got rows of about 50 columns all along in sheets 1-5 and trying to copy and paste vertically on sheet . I need it paste special as it linked to other pages and I need sheet 6 auto updating when sheets 1-5 are auto updated from somewhere else.
 

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
13,432
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
If you are only doing a PasteSpecial formats and transpose you shouldn't get any data transferred to any sheet (including sheet 2).
 

Watch MrExcel Video

Forum statistics

Threads
1,114,422
Messages
5,547,834
Members
410,813
Latest member
Vhinzvirgo
Top