• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 250
  • 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!
  • 2
1 Solution
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.
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?
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

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