Results 1 to 5 of 5

Macro to copy data from column to alternate columns depeding on selected dropedown month

Threaded View

  1. #1
    Registered User
    Join Date
    04-13-2016
    Location
    canada
    MS-Off Ver
    2010
    Posts
    35

    Macro to copy data from column to alternate columns depeding on selected dropedown month

    Hi,

    Need help... with below

    Have a drop down for month in J5 cell and data is entered based on month in below cells J6:J21 and data is calculated in col K using a formula(=J6/J$22).

    Require ONLY column K data(%) copied over to month (Col L for Jan) and if another month selected in col J5 must add data (%) accordingly to other months columns respectively.

    - Require J22 entry to be copied over to that related month too in L22 , N22 ... (Data is changed manually every month by staff)

    See attached sample file

    Thanks for assisting...
    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. Copy alternate cells data from a Row to single Column
    By Subhash A. in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 08-06-2014, 09:13 PM
  2. Copy entire selected column to next columns till last column
    By siroos12 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-22-2013, 05:20 AM
  3. [SOLVED] Copy alternate Column Data
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-08-2013, 11:40 AM
  4. Delete every alternate columns till the last data in the row from column G
    By andywsw in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-11-2012, 11:59 PM
  5. macro to copy paste selected columns in row
    By pvkkutty in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 07-03-2010, 06:54 AM
  6. Macro to copy selected columns
    By strongarmtom in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-27-2009, 07:31 AM
  7. Copy a spreadsheet depeding on a variable
    By oakman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-02-2006, 10:40 AM

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