Results 1 to 2 of 2

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

Threaded View

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

    Question 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
    Last edited by Jenkins87; 07-15-2016 at 02:04 PM. Reason: Added sample workbook

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro with text to columns, insert rows, and paste special>transpose
    By Schern in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-21-2016, 11:43 AM
  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. 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

Tags for this Thread

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