I have a workbook: Sheet 1 has a drop down menu allowing you to select an option that then fills Sheet 1 with the information from Sheet 2 that pertains to the selection. I use a macro to copy this information and paste it to another location in Sheet 1 to be called upon by sheet 3 for some other calcs.
The issue I have is I want the same macro to take a formula in Sheet 2 and copy and paste that formula into Sheet 3 but that formula will be in a different row and will need to correspond to the selection of the drop down in Sheet 1. I am pretty much a total newbie when it comes to VBA and have been using "Record Macro" to do things I need done. This however isn't working as it will not seek out the correct formula based on the selection.
Any help would be much appreciated!
Thanks in advance!
Edit: It could be a 2cd macro if it needs to be.
Bookmarks