Lo all,
I have the following array pulling data based on a drop down from one tab, I am wondering if I am able to add a second query to add data from another table?
The second part would be,
Please Login or Register to view this content.I tried using +, got nul. Then I tried "&" and that added two order numbers together from the two tables into one cell for the nine rows that had applicable data on the second table.Please Login or Register to view this content.
Thank you good people
Maybe put this in between the two formulas, shot in the dark:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks