Hi,
I got a file which has Template name and numbers for it.It takes me around 2 HOURS to prepare data by using pivot table and pasting values using transpose. If anyone can provide a macro to perform this task quickly that would be great.
I have attached the raw data under tab DATA, Output which I am looking for under "Output" tab.And Calculation is there under calculation tab.I have done the calculation of one Template name "aa20150330" and shown the output also.Can I export this data into Ms Access and run query to do this task. I know SQL query very well.
Thanks
Loving
Bookmarks