Hi,
Im creating a new sheet in a spreadsheet that I have already made and seeked help on here for.
The file is attached. The question i have pertains to sheet 4 and 5, the two wishlist sheets.
The code I have is copied from the code for the Add Data macro in the add request sheet. You can run it to understand what Im saying.
Basically the existing code was used to match the broker name in column A in sheet "add request" and paste the information in the top (B1:B5) to the matched column B in the sorted by broker sheet. Try it for yourself
Now what I need help with:
In the wishlist sheets its a similar idea except the broker might not exist yet in the "Wishlight - Brokers" sheet column B. So its first assessing whether the broker listed in sheet "Add Wislist" Column A exists or not and if it doesnt then paste the broker name and the info from B3:B5. If it already exists and can be matched in Column B in "wishlist - brokers" then do what the macros is already doing and duplicate the information in B3:b5 in "Add Wislist" for a row beneath the broker name in "Wishlight - Brokers"
Here is the code i have. The code assumes that the Broker is already listed and that is what I am trying to fix, adding the additional if statement for when it is not listed
Im just not too sure what that coding is or if other things need to be changed within the code first
Any ideas?
Bookmarks