Dear Experts I hope you can help my sortation of my data.
I am going to attached what sort of excel files I am having a trouble , and What I would like to work around.
I have used couple Vlookup function but it doest not work when I used so many different weeks excel files.
Basically What I would like to have
Macro tool direct me to open new excel file reads only product and depot datas put them into seperate sheets in the new excel file or existing one..
Can anyone have any suggestion where to start ?
Bookmarks