• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 248
  • Last Modified:

Pull data based on a column in EXCEL 2007

Hi all.

I want to create an EXCEL 2007 template that when the user pastes data into column A in the 3rd row it will pull data from tableA based on the contents of each field (left outer join from EXCEL column A to tableA on the ItemField).

I know how to create a data connection to my TableA but how do I tell it to be a left outer join on columnA. Also, sometimes the end user will paste 3 rows, other times 30, basically the amount of data that is pasted in the spreadsheet will vary.

Any ideas? Thank you in advance!
0
printmedia
Asked:
printmedia
  • 2
1 Solution
 
experts1Commented:
Use VLOOKUP in another column, say column B for 30 rows or more if necessary and reference column A of the said row to compare data fromTableA.
0
 
printmediaAuthor Commented:
Hi experts1.

So when the end user opens the excel template they will paste their records in the first column under the column header in the 3rd row. Then they will press a command button that will VLOOKUP?

Can I use VLOOKUP in vba in order to tap into the SQL table?
0
 
experts1Commented:
In "ThisWorkbook" VBA module use Workbook_SheetSelectionChange() subroutine to tap into the SQL table and generate an updated  DATA range in the workbook, for use as the range lookup source for VLOOKUP function.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now