Hi all,
I am trying to build a tool in excel that can simulate and give an overview of packing plans, but i am having trouble getting a "timeline" to work. The sheets with the timeline are imported based on choice and will change in how many are imported. It needs to be VBA, the persons who will be using this tool, should just press the macro button and wait for the magic.
I would like to merge the timelines from each sheet and delete duplicates.
example
sht1:
A: 1 2 3 4 5 6
sht2:
A: 6 7 8 9
sht3:
A: 7 8 9 10 11 12
Mastersheet:
1 2 3 4 5 6 7 8 9 10 11 12
i really hope someone can help me, i have tried google and youtube, but havent found anything i was able to use in my case
I am trying to build a tool in excel that can simulate and give an overview of packing plans, but i am having trouble getting a "timeline" to work. The sheets with the timeline are imported based on choice and will change in how many are imported. It needs to be VBA, the persons who will be using this tool, should just press the macro button and wait for the magic.
I would like to merge the timelines from each sheet and delete duplicates.
example
sht1:
A: 1 2 3 4 5 6
sht2:
A: 6 7 8 9
sht3:
A: 7 8 9 10 11 12
Mastersheet:
1 2 3 4 5 6 7 8 9 10 11 12
i really hope someone can help me, i have tried google and youtube, but havent found anything i was able to use in my case
