Hello everyone,
Tryng to find the solution is driving me insane.
the code that vcoolio very kindly provided has helped me tremendously for my planning tasks at work, It is an Autofilter that copies data into an array of sheets based on sheets name. And that saved me hours of manually copy /paste cell by cell from oe sheet to another at work... And as machines have to be changed 5 to 8 times a day and there are 19 of them...I really need this code.
Only problem is that my master sheet has changed, as the main software has changed (I export excel master from main databas in the company).
So now I need the code in the attached example file, to split columns (union does not work anymore as columns to be copied are not contiguous anymore)
How can I tell the code to Autofilte but split columns as follows:
colum C from Master must go in column B in destination sheet, column D goes in C in dest sheet, F in D, E must remain empty on destination sheet, then G goes in F, J goes in G on dest sheet and finally E from master goes in colum H destination sheet.
I attach file with changed columns on master and machin sheets... I really hope you guys can help me, because I am loosing sleep over this one: I do not know ho to tweak the Union columns to strColsFromTo. I know I need the latter but I really have no clue on how to insert strColsFromTo in this code.
( vcoolio if you would be so kind as to help me again it would very very helpful,...).
Thank you all in advance , really hoping to hear from you.