Hi,
I am struggling to write a macro which will automatically filter out some specific data by comparing two tables. Here's the situation:
1. The raw data is imported from database with a list of items. Now, each month some items get closed down and some new items appear. The relevant columns in the raw data are:
Item No. - This is unique for each item
Status - Open/ Closed/ Pending etc.
Open from - The day since the item has been open
Closed on - The day the item has been closed
2. Also, I will need to find out the top 5 items opened for longest time.
I will need to produce these 3 lists - Items opened, Items closed and Top 5 items open for longest time and paste them into one sheet.
Now, the idea came up to my mind is to copy last months data into a new sheet and then compare them to find out the new items and closed items. But having no experience in using VB before I am struggling to write the macro. I have tried recording it but it's no good. Any suggestion?
I am struggling to write a macro which will automatically filter out some specific data by comparing two tables. Here's the situation:
1. The raw data is imported from database with a list of items. Now, each month some items get closed down and some new items appear. The relevant columns in the raw data are:
Item No. - This is unique for each item
Status - Open/ Closed/ Pending etc.
Open from - The day since the item has been open
Closed on - The day the item has been closed
2. Also, I will need to find out the top 5 items opened for longest time.
I will need to produce these 3 lists - Items opened, Items closed and Top 5 items open for longest time and paste them into one sheet.
Now, the idea came up to my mind is to copy last months data into a new sheet and then compare them to find out the new items and closed items. But having no experience in using VB before I am struggling to write the macro. I have tried recording it but it's no good. Any suggestion?
