Home |
Search |
Today's Posts |
#1
|
|||
|
|||
using dget
My data set is below. I want to use DGET function to link data from one
workbook to another without the risk of the data in the new workbook becoming incorrect because I have added rows are sorted the main workbook to add or change information. I originally used paste link and then realized when I made changes to the main worksheet the links didn't update in the other workbook. For instance I want to be able to do a DGET formula that would pull Company A's data for each FY and put into another workbook. What would my DGET formula look like? I understand I would have to a have a formula for each cell (i.e. for each month and year). Thanks. Company FY Jly. Aug. Sep. A FY 2005 $6,502 $9,899 $28,916 A FY 2004 $6,949 $4,065 $5,286 A FY 2003 B FY 2005 $8,117 $2,195 $747 B FY 2004 $2,166 $3,816 $814 B FY 2003 C FY 2005 $283 $195 $1,716 C FY 2004 $404 $2,658 $982 C FY 2003 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dget function | Excel Worksheet Functions | |||
how do i get "DGET" to take the first data meeting the criteria? | Excel Worksheet Functions | |||
At my wit's end! Use DGET or VLOOKUP to select data???? | Excel Worksheet Functions |