Regroup data from several Worksheets into one without keeping duplicates.

It can easily be done by a code, but there are two major issues. First, the code will not support the functions in Mac, so the code will not work, unless of course, you wanted it to run in Window. Second, Are you comfortable with a macro code?

Hi,

Is there no possibility to run a macro in excel on mac? I don't know if I am comfortable with a macro I've never used one, i barely know what it is,I only used functions and nothing too fancy. Would there be any constraints in using a macro?

Thank you in advance.

Well! It depends.
A code is most likely suited to your requirements. I do not see any issue using it. You can use it, someone need to show you first time, but the biggest stumbling block is your computer. You are probably aware that there are many excel functions which are not available in Mac. A while back, I had spent several hours trying to work out why a code I wrote failed to work. It was perfectly working on my PC, but the Mac user could not use. I found that some of the functions on the code were not accessible in Mac. For e.g. Dictionary objects. I would not promise anything, but will try to see if I can getting around this problem. I will let you know.

Freez,
I have got a solution for you, but may not be the ideal one. I am hoping that there should not be an issue with Mac, not as far as I know any way.
I have got a code which consolidate all your sheets in to one "Master" sheet, so that you can use Pivot table to achieve what ever you wish. The code is very flexible in that, when ever you run it, it clears all existing data and repopulate with fresh new data.
How do you run the code?
I do not know in Mac, but I do not think it is different to Window. The code resides in project VBE under a module. You do not have to worry about this as I have created a Button which it is linked to the code. All you have to do is just press it to run. So, when ever you changed your data and want to re-run the code, press the pink button which is located in Master sheet column N.
Try the attached and see how you progress.

Lem,
Thanks!
Let's hope so.
I have never excel on Mac myself. I do not think it supports a scripting called "Dictionary". This question often pops up on discussion forums.

Lem,
I did not notice you are actually on the Mac. It is good though as you will a person who can help us with this thread.

Hi,

just tested the Macro and it is working. Going to try to understand at least a little bit what's happening in the macro's code, anyway thank you very much for your help. The macro solved my problem.

freeze,
Glad it has worked for you!
You can add as many data and sheets as you like, all you have to do is press the button.
I would like also to thank Lem for his insight in the world of Macs