Hi,
I'm relatively new to VBA and I've been searching the forum for an answer but I'm struggling to implement any of the solutions I've come across.
I have a file that's produced daily and shows data for the previous days performance. I need to merge all of the data in the file to produce a daily total.
I've provided a snip of the data below:
What I'm trying to achieve is:
Ideally id like to be able to run it as a macro as this task will need to be done daily and the files have 900+ rows.
Other examples that I've come across sort the data by a column and then merge cells but this doesn't total the other columns or produce an average which is what I need.
any help would be appreciated.
thank you.
I'm relatively new to VBA and I've been searching the forum for an answer but I'm struggling to implement any of the solutions I've come across.
I have a file that's produced daily and shows data for the previous days performance. I need to merge all of the data in the file to produce a daily total.
I've provided a snip of the data below:
What I'm trying to achieve is:
- Merge all rows based on 'Product_Type'.
- Columns in blue need to be summed
- Columns in Green need to be an average
- Time column is irrelevant so can be removed
Ideally id like to be able to run it as a macro as this task will need to be done daily and the files have 900+ rows.
Other examples that I've come across sort the data by a column and then merge cells but this doesn't total the other columns or produce an average which is what I need.
any help would be appreciated.
thank you.