Re: $$Excel-Macros$$ SQL Queriies in Excel sheets

2015-12-07 Thread Jorge Marques
Hi Luciano, You want to filter sheet1 and return those results to another sheet? Not sure if SQL can be used for that in Excel, but I use Power query to extract specific data from a sheet that contains all data by using power query. I can already select the columns I wish to use and also filter the

$$Excel-Macros$$ SQL Queriies in Excel sheets

2015-12-07 Thread luciano de souza
Hello all, This is my first message to the group and I am glad to participate in a so rich space. My first question is about the use of a sheet as a database. Suppose I have a sheet with these columns: Colunm 1: ID Colunm 2: Project Colunm 3: Activity Colunm 4: Task Colunm 5: Opened Colunm 6: Re