+ Reply to Thread
Results 1 to 1 of 1

Macro to special paste values and transpose them to varying cells on another sheet

  1. #1
    Registered User
    Join Date
    06-04-2014
    Posts
    4

    Macro to special paste values and transpose them to varying cells on another sheet

    I was hoping for some help creating this code. The part that is really throwing me off is having to paste values but also have them transposed at the same time. Let me know if anything is hard to follow. Any help would be greatly appreciated!

    1. Copy B2 from sheet “Data Entry”, paste to first empty cell in column A on sheet “All”
    2. Copy B3 from sheet “Data Entry”, paste to first empty cell in column B on sheet “All”
    3. Copy B4 from sheet “Data Entry”, paste to first empty cell in column E on sheet “All”

    4a) In “Data Entry”, if C5 is not blank, copy C5 and paste to first empty cell in column C on sheet “All” and make first empty cell in column F on sheet “All” “0”. Then copy D7:D52 from “Data Entry”, special paste the values transposed into sheet “All”, across the next available row from G:AZ on sheet “All”

    4b) In “Data Entry”, if G5 is not blank, copy G5 and paste to first empty cell in column C on sheet “All” and make first empty cell in column F on sheet “All” “1”. Then copy H7:H52 from “Data Entry”, special paste the values transposed into sheet “All”, across the next available row from G:AZ on sheet “All”

    4c) In “Data Entry”, if K5 is not blank, copy K5 and paste to first empty cell in column C on sheet “All” and make first empty cell in column F on sheet “All” “2”. Then copy L7:L52 from “Data Entry”, special paste the values transposed into sheet “All”, across the next available row from G:AZ on sheet “All”

    4d) In “Data Entry”, if O5 is not blank, copy O5 and paste to first empty cell in column C on sheet “All” and make first empty cell in column F on sheet “All” “3”. Then copy P7:P52 from “Data Entry”, special paste the values transposed into sheet “All”, across the next available row from G:AZ on sheet “All”

    - There will be a time when anything is entered to more than one of C4, G4, K4 or O4 in “Data Entry”
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro to special paste values and transpose them to varying cells on another sheet
    By Jenkins87 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-15-2016, 12:47 PM
  2. [SOLVED] Paste Special - Values, Transpose Need Icon
    By Zimmerray1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-12-2014, 04:34 PM
  3. Copy-Paste Special - Transpose values if condition applies
    By Florinnn in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-01-2013, 05:35 AM
  4. Replies: 1
    Last Post: 08-12-2012, 04:02 PM
  5. [SOLVED] Need a macro to export a single sheet as - Paste special (Values)
    By kishoremcp in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-11-2012, 12:00 PM
  6. [SOLVED] Paste Special - Values - Transpose
    By J in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-06-2005, 12:25 PM
  7. Macro for one-click paste special transpose
    By Victoria @ WB in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-22-2005, 09:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1