Copy value in one Sheet, Look for it in a certain row in another sheet.

Good morning guys,

My VBA skills are for a lack of a better word, not great, so any assistance will be greatly appreciated.

I'll do my best to describe the scenario. I am leaving out some details, as it'll take a while if I need to describe the sheet in detail. I'm sorry if it's confusing. I'll post the current code I have at the bottom.

So I have a sheet with multiple tabs. One of the tabs contain data that I use for a few dependent drop downs in the first tab.

When the first tab with drop downs is populated(Main Tab), I have a "Copy" button that needs to copy Column A4:A24;A61(Main Tab) to one of 4 tabs, depending on Cell A4's value.

What I'm trying to achieve is the following.

Cell A5(Main Tab) contains the number that's associated with the data contained in Cells A4:A24;A61(Main Tab).
I need to incorporate a VBA code that copies A4:A24;A61(Main Tab) then goes to the correct tab(Looked Up Tab) which is specified by Cell A4(Main Tab), then looks up the value of A5(Main Tab) in row 2:2(Looked Up Tab). If the value is found, it needs to two things.

First check if there is already data in cells A1:A22(Looked Up Tab), and if there is data, sum the data from A7:A24(Main Tab) with the data in A4:A21(Looked Up Tab),
If this condition is not met, it needs to add all the Copied Data to the last column.

So below is my current VBA code.
I know it's messy, so any corrections will be appreciated.

Please Login or Register  to view this content.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. 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, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then 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

(Note: this change is not optional. As you are still new here, I have done it for you this time. )