Queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet withh 200 accounts and there is an updated spreadsheet
with my 200 accounts with new information and another 400 accounts. I want to
get just my accounts out of the new spreadsheet.
Can I use a query to get just my accounts and their personal information
from the spreadsheet with 600 accounts on it
 
Is there a column that defines them as your accounts?, if there is use auto
filter under the data menu and then copy the result
--
John
MOS Master Instructor
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)
 
The account number is unique, I want to retrieve only my current 200 accounts
without deleting all the others one by one.
 
If the accounts are in order you could try a vlookup along the lines of
=VLOOKUP(Sheet2!A1,Sheet2!$A$1:$B$16,2), where sheet 1 is your accounts and
sheet 2 is the other list
--
John
MOS Master Instructor
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Advanced Filter/Extracting Data 3
Column Heading on each row in pivot table 1
collate data Vlookup? 1
Split up spreadsheet by sales rep 1
Mask Account Number 2
macro or formula to find an account number in another list of numb 1
Cross refrence an index table and sum in one step? 7
Updated Formula question 10

Back
Top