Hey all,
Im trying to figure out how to copy a gropu of cells based on what is selected from a dropdown menu.
On the attached spreadsheet, i would like for the selection in cell C44 to determine what will be copied to cell A46. The drop downs come from cells E48:E51. If same route back is selected i would like for cells E54:F54 to be copied. If new route or destination is selected i would like cells E57:G98 copied and the total to add in previous totals.
If this is possible without to much hassle/programming it would be great, but expecting a bit of work/programing knowledge to get this done.
Bookmarks