+ Reply to Thread
Results 1 to 7 of 7

VBA Coding to copy a column of data to a new sheet and shift column to the right.

  1. #1
    Registered User
    Join Date
    04-11-2019
    Location
    Califoenia
    MS-Off Ver
    Office 365
    Posts
    3

    VBA Coding to copy a column of data to a new sheet and shift column to the right.

    I am trying to create a workbook to keep track of payroll, and I want it to automatically transfer each pay period for all employees to a different sheet, then shift the columns to the right each time I add a pay period. I have tried this,

    Please Login or Register  to view this content.
    but it isn't working the way I want. I, also, can't figure out how to get it to work for an entire column instead of a single cell.


    Any help is greatly appreciated.

    Thanks, Josh
    Last edited by AliGW; 04-11-2019 at 06:18 PM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: VBA Coding to copy a column of data to a new sheet and shift column to the right.

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however you need to include code tags around your code.

    Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    (Note: this change is not optional. As you are new here, I have done it for you this time.)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    04-11-2019
    Location
    Califoenia
    MS-Off Ver
    Office 365
    Posts
    3

    Re: VBA Coding to copy a column of data to a new sheet and shift column to the right.

    Thank you. I will try to remember this in the future.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: VBA Coding to copy a column of data to a new sheet and shift column to the right.

    You’ll need to - thanks.

    You might also wish to change your location in your user profile - it doesn’t look quite right to me.

  5. #5
    Registered User
    Join Date
    04-11-2019
    Location
    Califoenia
    MS-Off Ver
    Office 365
    Posts
    3
    Yes, I saw that, but decided to leave it. I thought it would get a laugh.

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: VBA Coding to copy a column of data to a new sheet and shift column to the right.

    It did.

  7. #7
    Forum Contributor
    Join Date
    03-22-2017
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    230

    Re: VBA Coding to copy a column of data to a new sheet and shift column to the right.

    i quite not understand what you want as it trigger by range("A2")

    but you may change
    Please Login or Register  to view this content.
    it insert whole column instead of one

+ 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. copy and shift column(s)
    By dazzdazz in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-06-2016, 05:49 AM
  2. Copy data from sheet1 column with dynamic date, and copy data to second sheet column
    By Renaliiii in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-25-2016, 04:44 PM
  3. Copy data from column in one sheet to column in another sheet until blank in F
    By votekinky06 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 03-26-2014, 05:22 PM
  4. copy data from one column to column on another sheet starting with first open cell
    By indiana115 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-16-2013, 05:50 PM
  5. Copy Data from one column in a sheet to another column present in 2nd sheet
    By pan07 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-21-2012, 12:50 AM
  6. Copy column data on one sheet to row or column date on another sheet based on user in
    By soready42012 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-08-2012, 12:03 AM
  7. Copy Data from Column and Paste to Next Blank Column on 2nd Sheet
    By adammark in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-19-2010, 11:15 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