Shorten VBA Code

Don't know if I understood your request right, so make sure to try on a copy of your workbook. (as you should always do anyway)
You mention table, but I don't see anything in your code that you have an actual table, just a Range.

Please Login or Register  to view this content.

Hi Jolivanes,

Thank you for looking into this.
I'm sorry I meant a range. Not a table.
Your code has an extra ) on the second line, just before .Value.
But I tried it after removing the extra ).
It doesn't seem to do the desired result.
I have attached a simplified copy of the file.
The real file is really big, so I had to make it uploadable here.

How is the data in Column A in all your sheets entered and where is that coming from?
Is the Tab Reference always the next empty cell in Column B for all the sheets?

BTW, here is the fixed code. I was in too much of a hurry to go and rest. Have not tried it on your attachment though. Just a general solution.
If you are going to try/use it, change references if and where required.
But I think, I have not tried it, mohadin has you covered on that.

Please Login or Register  to view this content.

Hi mohadin,

Your code is great. It does the basic task of pasting the intended values into their respective tabs.
The only problem is, it also pastes the info from column "H", which is not required. But this is my fault since my instructions were not clear enough.
I just did a very little change to the code and it was able to do the required.

Hi jolivanes,

Your code is great, works perfectly.

I would be saving both codes for future reference and backup.
Thank you both for helping.