Hi all!
I desperately need some help from you all.
I download a massive volume of data from some data service into excel before I could use them for analysis each day. I can't customise the download format of data. I have been manually deleting the unwanted columns each day & it's getting a little too much.
Can anyone please help me with the following exercise:
The downloaded data are in the following format:
Date prod1 cons1 cons2 sales1 prod2 cons1 cons2 sales2 ....
The data I need are the sales figures for each unit for each day.
I want to delete all 3 columns before each sales data. How do I write a macro to do that?
Your help is truly appreciated.
Thanks in advance.
Cheers,
Nadia