+ Reply to Thread
Results 1 to 2 of 2

Copy a colum where add data in every year to another column

  1. #1
    Registered User
    Join Date
    09-23-2015
    Location
    Bangladesh
    MS-Off Ver
    2013
    Posts
    72

    Copy a colum where add data in every year to another column

    Greetings and good day to every one.


    I have a problem as below and need help. Hope kind enough to help me.

    I have following years in one column say A1,A2,...
    A B
    2012
    2013
    2014
    2015
    2016
    2017
    2018
    2019
    2020

    In another column say C ... I have following data
    C
    10
    20
    30


    I want to copy 10 next to 2012 in B1, 20 next to 2013 in B2 and 30 in B3 next to 2014 and so on.

    After that if any data add in in column C it will automatically copy next to 2015 in B4,
    This continuation will end up in year 2020

    Can you please give me excel formula for this or excel VBA code which one is easy for me.

    With warmth regards,
    Shahadat Hossain

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Copy a colum where add data in every year to another column

    Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

+ 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. [SOLVED] Macro to filter column and copy rows to new sheet with loop for all unique values in colum
    By Gryphoune in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-24-2015, 09:15 AM
  2. Help in Copy Header Colum data from one workbook to another
    By Bud Wilkinson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-21-2015, 02:44 PM
  3. Copy Value from Colum according to Matching in another Column. IMPORTANT PLS
    By Developer_ in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-13-2014, 07:50 AM
  4. need a macro if row is text is constant then other colum shd copy n paste in other colum
    By uttam.mothe in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-05-2013, 12:17 PM
  5. copy and paste colum K to colom R and skip filled cells colum R
    By jdrmer in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-13-2012, 10:30 AM
  6. if partial data exists in one colum, copy to another column
    By Gunther in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-16-2011, 09:23 AM
  7. copy data from row across to colum down
    By stevene123 in forum Excel General
    Replies: 1
    Last Post: 03-21-2007, 05:37 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