I was able to adapt this link for my project, but I am looking for a way to duplicate for multiple rows. Here is my query:
SELECT data_0.InvoiceNumber,
data_0.CustomerNumber,
data_0.CustomerName,
data_0.Address,
data_0.City,
data_0.State,
data_0.Zip,
data_0.Zone,
data_0.PartNumber,
data_0.PartDescription
FROM bitnami_wordpress.data data_0
WHERE (data_0.InvoiceNumber=?)
The invoicenumber
is the parameter and that is filled with =Sheet2!$A$4
Ideally, I would enter my parameters in Column A and Columns B:K are filled with the data from the database, is there a way to do that without setting up a query for each individual row, almost like "Fill Down"?
"SELECT name FROM user **WHERE data.Invno=" & Worksheets("Sheet2").Range("A4").Value
**.