pulling data

  1. C

    Excel 365 (Mac): How do I pull table data from another excel workbook?

    Hello all, I am wanting to pull specific data from one table into another. Basically, I have an accounting ledger that tracks all debits and credits for our business. At the end of the month, I put together an expense report of all our transactions. Rather than sorting the data in the...
  2. E

    Pull Chosen Data Only

    How do I pull only certain data from one section to another section? In my spreadsheet for example, I have something like this here: <tbody> A B C D E F G H 1 ORG FIRST LAST DATE FIRST LAST DATE 2 2 Matthew Johnson 5/2/2015 3 2 Mark Anderson 2/7/2014 4 2 Luke Jones...
  3. C

    using a name to pull data from a database but having people with the same name

    Can someone help me, I have been given a Database to update and found a problem with it that I do not know how to fix. the database uses Vlookup to extract data from another sheet using the Name of a person as the reference point to look up against. The problem is that there are many people...
  4. J

    Pulling data from a worksheet with different columns to different sheets with names similar to the source column names

    Hi, I would like to get assistance on how to pull Data from a consolidated worksheet with a series of columns and rows to multiple sheets with sheet names similar to the consolidated sheet column names. Many thanks
  5. T

    Pulling data

    All, I have another situation where I am trying to pull data. Essentially, I am trying to compile info from the following: A particular store, revenue and net income from that store. Each store has a certain amount of rows from a financial statement. Store 1 Revenue Other expense Net Income...
  6. M

    Pulling Specific Columns from Raw Data (needs to be duplicable for changing raw data)

    Hello - I am having issues coming up with a repeatable template for pulling specific columns from raw data that changes based on location and time. Here is my example: Weekly Raw data is pulled for various locations (let's say Massachusetts and Maryland) So i have two different workbooks...
  7. N

    VBA code for pulling data from a closed workbook w/o opening it

    Hi, Looking to pull the data in one cell from a closed workbook say A1, without actually opening the workbook or prompting excel to open and close it. Ideally if it can be live, change as it changes in the (closed) workbook without it needing to be opened ...otherwise just pull in the...
  8. T

    Listing data from different tabs

    Hi, I am trying to pull info from two lists (each located in a different tab) into a third tab. The two lists might get additional names in the future and I want to fireproof the formula to pull in any additional data that might be later on added in the 2 tabs. I am having a hard time coming...
  9. G

    vlookup?? maybe...

    below is a sample of the data list that i need to extract data from: <TABLE style="WIDTH: 169pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=225><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 73pt; mso-width-source: userset; mso-width-alt: 3547"...

Some videos you may like

This Week's Hot Topics