Hi - I am trying to add another feature to my current excel workbook that I built with help from other forums and the internet.
I have a workbook that contains several worksheets. One worksheet is labeled "Proposed Travel" and contains two separate dropdown lists. One is Column E which is labeled "Program Code" and the other is Column G, which is labeled "Approved?".
When I select one of the dropdowns in Column E and then select "YES" from the dropdown in Column G, I want the following data (B6, C6, D6, F6 and H6 on Proposed Travel worksheet) to copy onto the first available line (in Columns A6, B6, D6, F6, and H6) on the worksheet selected in Column E (worksheets starting with either 21000, 21010, 21020, 21030, 21036, or 21070).
As I go down the list to select "YES" on Proposed Travel Worksheet, I would like data added to next available line on the respective worksheet.
I am not able to upload the workbook as keep getting message that upload failed. Any suggestions on how I can get it to you would be great!
Thanks for your time in this matter.
Bookmarks