MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
View: 211|Reply: 0

Macro to copy data from column to alternate columns depedin

[Copy link]

1

Topics

1

Posts

5

Integral

Newbie

Rank: 1

Integral
5
Post on 2-12-2017 01:27:06 | All posts |Read mode
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...








  • Test drop.xlsx
    (11.4 KB, 0 views)
    Download

  • Reply

    Props Report

    Points policy of this forum

    Archiver|Mobile|Small dark house|Contact us|Excel Bar

    GMT-5, 9-21-2017 14:36 , Processed in 0.129388 second(s), 20 queries .

    Powered by Discuz! X3

    © 2001-2013 Comsenz Inc.

    !fastreply! Top !return_list!