Microsoft Office Forums How to populate cells in Sheet2 with Data Source query using cell data from Sheet1

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-21-2014, 10:43 AM
bobznkazoo bobznkazoo is offline How to populate cells in Sheet2 with Data Source query using cell data from Sheet1 Windows XP How to populate cells in Sheet2 with Data Source query using cell data from Sheet1 Office 2007
Novice
How to populate cells in Sheet2 with Data Source query using cell data from Sheet1
 
Join Date: Mar 2014
Posts: 2
bobznkazoo is on a distinguished road
Default How to populate cells in Sheet2 with Data Source query using cell data from Sheet1

I have a column of cells in Sheet1 and need to use the data in those cells to populate several cells in Sheet2 using a query to a data source. Currently, there are thousands of rows in sheet1 and I need to populate the same number of rows in Sheet2:
the Sheet1!G1 cell is the cust number and will be copied to Sheet2!A1; Sheet2!B1 would be cust name; Sheet2!C1 would be cust addr; etc.
Sheet1!G2 is copied to Sheet2!A2; Sheet2!B2 would be cust name; Sheet2!C2 would be cust addr; etc.

Specifically, I need to use the Customer Number from the cell in Sheet1 and then query a SQL Server database to get the information for that customer number: name, address, phone, etc.

Can I do this using an Excel data source query or will I need to use some VB code to get the data?
Reply With Quote
  #2  
Old 03-27-2014, 01:32 AM
RudiS RudiS is offline How to populate cells in Sheet2 with Data Source query using cell data from Sheet1 Windows 8 How to populate cells in Sheet2 with Data Source query using cell data from Sheet1 Office 2013
Novice
 
Join Date: Mar 2014
Posts: 10
RudiS is on a distinguished road
Default

Would it not be possible to import (or link) the data to Excel? If this is viable then you can use a VLOOKUP to collect the name, addr, ph, etc...
Reply With Quote
  #3  
Old 03-27-2014, 11:14 AM
bobznkazoo bobznkazoo is offline How to populate cells in Sheet2 with Data Source query using cell data from Sheet1 Windows XP How to populate cells in Sheet2 with Data Source query using cell data from Sheet1 Office 2007
Novice
How to populate cells in Sheet2 with Data Source query using cell data from Sheet1
 
Join Date: Mar 2014
Posts: 2
bobznkazoo is on a distinguished road
Default

RudiS,
Thanks for your post. The data is in a SQL Server database and there are too many records so an import to Excel is not possible. Also, new numbers are added to the database every day.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to populate cells in Sheet2 with Data Source query using cell data from Sheet1 Populate Data to another cell Mrkieth Excel 2 04-29-2013 07:30 AM
split text files to worksheets (sheet1,sheet2,sheet3 soon sheet 25) gsrikanth Excel Programming 1 03-22-2012 11:04 PM
How to populate cells in Sheet2 with Data Source query using cell data from Sheet1 How to merge two cells from sheet1 to one cell in sheet2 in next sheet KIM SOLIS Excel 6 10-30-2011 11:14 PM
How can I fill the below emty cells with above cell data? Learner7 Excel 8 06-28-2011 12:10 PM
How to populate cells in Sheet2 with Data Source query using cell data from Sheet1 How to combine different cells data in one cell? Learner7 Excel 1 07-28-2010 12:07 PM


All times are GMT -7. The time now is 02:35 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft