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...
Bookmarks