Hi, all
I can't use access or any other SQL tools...need to develop this in Excel only.
I am new to the Excel VBA programming. I have an excel sheet (single worksheet) with data. The data is getting refreshed from sharepoint list. I am using 2010 version of Excel.
Once the data is refreshed, I would like to run some queries on the refreshed worksheet.
for example, the excel sheet has the following columns
Package id
Date1
Date2
Date3
ingredient
ingredient type
I am planning to have queries that can run on this data in excel to provide a subset of rows that meets the criteria... The query results must be stored in new worksheet in the same document.
1. to find the duplicate ingredients by ingredient
attached the test data and expected results in different tab. appreciate your help.
Either macro or vba code help.
I can't use access or any other SQL tools...need to develop this in Excel only.
I am new to the Excel VBA programming. I have an excel sheet (single worksheet) with data. The data is getting refreshed from sharepoint list. I am using 2010 version of Excel.
Once the data is refreshed, I would like to run some queries on the refreshed worksheet.
for example, the excel sheet has the following columns
Package id
Date1
Date2
Date3
ingredient
ingredient type
I am planning to have queries that can run on this data in excel to provide a subset of rows that meets the criteria... The query results must be stored in new worksheet in the same document.
1. to find the duplicate ingredients by ingredient
attached the test data and expected results in different tab. appreciate your help.
Either macro or vba code help.