Results 1 to 2 of 2

Thread: Exporting Data and splitting it up!

  1. #1

    Exporting Data and splitting it up!



    Register for a FREE account, and/
    or Log in to avoid these ads!

    hi guys,
    I have two sheet Program Plan and Staffing Plan-N.
    I want to export certain data from Program Plan to the Staffing Plan.
    The Range which i want to export is E53:AJ57 (Program Plan sheet) to I5:AN10 in the Staffing Plan Sheet.
    But the condition is .
    If the cell value in the range is E53:AJ57 is more than 1 then it has to split into 1's so that no cell value in the range I5:AN10 is more than 1.
    And the corresponding role in the column E has to be split up to.
    The sheet is attached.I have shown in the below cells the expected result.
    Attached Files Attached Files

  2. #2
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    357
    Articles
    0
    devpp: It would be nice if you would first reply to the solution I posted at your last post at http://www.excelguru.ca/forums/showt...-Actuals-Sheet!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •