1. Windows Central Question's Avatar
    Hi everyone,

    Please bear with me as I can't seem to find an answer to this... My scenario is as follows:

    1. I have a worksheet set up in Excel 2010 with different columns like names, addresses, phone numbers, etc. Let's say I have Column A, Column B, Column C, Column D, Column E, and Column F.
    2. What I want to do is run a query (?) that, for example, takes ONLY the data from Column A, Column D, and Column F. Then it dumps that data and that data only into a new (blank) Excel sheet for to view, print, etc that is independent from the original worksheet.

    How does one do this?
    05-30-2015 05:30 AM
  2. ven07's Avatar
    OH MY LAWD!!! First excel related question I've seen lol.. Eh would you like to dump the result in a new sheet of the same excel file or a totally new one?
    05-30-2015 06:51 AM
  3. jmshub's Avatar
    I don't fully understand what you are asking. Do you want all of Column A, D, & F in a new worksheet? In that case, you don't need to manipulate the data, you just copy and paste the columns.

    If you are looking to extract data from the spreadsheet based on specific criteria, there are other options, such as VLOOKUP. But more information would be needed. Consider joining our community and provide us with more information.
    ven07 likes this.
    05-30-2015 10:25 AM

Similar Threads

  1. Prevent streaming on mobile data?
    By vc-10 in forum Groove Music
    Replies: 1
    Last Post: 07-22-2015, 07:15 PM
  2. This year's E3 will finally let up to 5,000 members of the public attend
    By WindowsCentral.com in forum Windows Central News Discussion
    Replies: 0
    Last Post: 05-29-2015, 05:11 PM
  3. Keep your eyes open for some Rise of the Tomb Raider news on June 1
    By WindowsCentral.com in forum Windows Central News Discussion
    Replies: 0
    Last Post: 05-29-2015, 03:50 PM
  4. I have a broken sd card , can I restore from back up with out it?
    By Windows Central Question in forum Ask a Question
    Replies: 1
    Last Post: 05-29-2015, 11:47 AM
  5. WiFi always sending data or something
    By WinAndTech in forum Nokia Lumia 635
    Replies: 5
    Last Post: 05-29-2015, 10:22 AM
LINK TO POST COPIED TO CLIPBOARD