Need help with code in If statement for pasting entries into another sheet

[vpan]

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

Please Login or Register  to view this content.

Im just not too sure what that coding is or if other things need to be changed within the code first

Any ideas?

[zbor]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[vpan]

okay, sorry about that, it is changed now

[vpan]

Just checking back in during lunch time, anyone have any idea?

I feel like it should be a simple addition to the IF statement already in there, but Im not familiar with how vba statements are written so I dont know how the syntax would be for it