Results 1 to 1 of 1

Copy and paste changing columns

Threaded View

  1. #1
    Registered User
    Join Date
    01-05-2013
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2010
    Posts
    5

    Copy and paste changing columns

    Hi, Excel friends & experts! I am trying to copy columns of data to fixed columns in a new sheet. The reason is data copied in to the 'Copy Data'! tab constantly changes column header names and positions. The user can note what the column data is by doing the following:

    1. copy data beginning in 'Paste Data'!A5
    2. At the top of the sheet, the user inputs the column letters from Row 4 that correspond to what the data reflects based on the options listed. If one of the options does not apply, leave it blank.

    Problem:
    Need to copy the column from sheet "Paste Data" that aligns with the letter to the correct column in sheet "Clean" where I have noted which column should be pasted in each respective column.

    Is there a code that can do this automatically that is triggered when cells in sheet "Paste Data" B1, D1,D2,F1,F2,H1,H2,J1,J2,L1 change? I would like to leave all data in the sheet "Copy Data" and not delete anything. I prefer no button to trigger the event but instead execute if there is a change to value of the mentioned cells B1,D1, ETC.

    Problem 2
    I would like to then copy from sheet "Clean" to sheet "NO" if there is a "N" in column N and column L and M are blank.

    A sample sheet is attached. Please let me know if I need to clarify anything and thank you very much to all those who help!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA Copy-paste values with changing paste location
    By booost in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-16-2012, 10:39 AM
  2. Replies: 2
    Last Post: 02-22-2011, 02:07 AM
  3. 2 Macro's: only vertical copy/paste action and copy-paste 14 columns to the right.
    By vdongen in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-08-2010, 10:34 AM
  4. Changing columns to rows without copy and paste
    By BIGDAN in forum Excel General
    Replies: 2
    Last Post: 05-29-2010, 12:12 PM
  5. [SOLVED] Copy and Paste macro needs to paste to a changing cell reference
    By loulou in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-24-2005, 07:06 AM

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