The data is extracted from 2 seperate database, so we have 2 excel files to merge together.I have added both files in the same file to make it simplier. The first tab (bobines) is data from quality testing and the data can be mesured every 15 mins, 30 mins, 45 mins, etc. So it's never equal.
The second file, is the tab janvier and this tab has even more data extracted every 3-15 mins.
Of course, the date+time doesn't fit. I would like to merge the 2 tabs together. The tab bobine would be merged in the tab janvier and fit the date+time correctly.
Since the 2 tabs don't contain the same data, I woud also need to copy the empty cells with the same value measured x mins earlier.
That would make a huge file where we could create graphs with something measured from a bobine
versus janvier (x).
I can't find a way to do it without Visual Basic macros and this is something I am not able to create.
The second file, is the tab janvier and this tab has even more data extracted every 3-15 mins.
Of course, the date+time doesn't fit. I would like to merge the 2 tabs together. The tab bobine would be merged in the tab janvier and fit the date+time correctly.
Since the 2 tabs don't contain the same data, I woud also need to copy the empty cells with the same value measured x mins earlier.
That would make a huge file where we could create graphs with something measured from a bobine
versus janvier (x).I can't find a way to do it without Visual Basic macros and this is something I am not able to create.
