Linking Excel Worksheets by dxz10766

VIEWS: 7 PAGES: 12

Linking Excel Worksheets document sample

More Info
									                                                         Instructions for Exporting QuickBooks data

Where did my worksheet go?
          When you export data to a new workbook, your new worksheet containing exported data goes to Sheet 1. When yo
          the new worksheet is placed in front of the last active sheet where it will be named "SheetX" using the next available


How do I make sure this tips sheet isn't exported with the QuickBooks report in the final workbook?
          Before exporting, on the Export Report Basic tab, deselect the option to include the instruction worksheet.


How can I customize and update my worksheet?
          You can set up Excel links between 2 or more worksheets. (See Microsoft Excel Help for details about linking in Ex
          feature to setup links between a QuickBooks summary report and your customized sheet.
                      >> Choose one sheet as your source worksheet into which you'll export QuickBooks data. Then create a
                      customize your data and link the data between that sheet and the source worksheet.
                      >> Export your source data to an existing worksheet and overwrite the current data so that the new data
                      >> Create Excel links between a QuickBooks data worksheet and another worksheet in the workbook.


Troubleshooting: Why don't my links work correctly after exporting data?
         Be aware that any difference in the structure of the current report from the report that you used when setting up link
         in the links between worksheets. If you are seeing wrong data in your customized worksheet, then you may have:
                      >> Moved or deleted elements, or changed the structure of the report in some way? For example:
                                 You might have moved or deleted items from item list which gets used in a report like Invent
                                 You might have moved or deleted accounts from accounts list which gets used in a report lik
                      >> You are using a report related to accounts and have account(s) with no activity associated and did no
                                 TIP: Choose display All rows (available for most of the reports), Select Modify report->Displa
                      >> Deleted exported data sheet which serves as data source.
ckBooks data


orted data goes to Sheet 1. When you export to an existing workbook,
med "SheetX" using the next available number in the series.


 final workbook?
e the instruction worksheet.



 el Help for details about linking in Excel.) You can use this

 port QuickBooks data. Then create another worksheet where you can
ource worksheet.
the current data so that the new data is used by any Excel links and formulas.
 nother worksheet in the workbook.



 rt that you used when setting up links, can cause mismatch
ed worksheet, then you may have:
ort in some way? For example:
 hich gets used in a report like Inventory Valuation report.
nts list which gets used in a report like Profit and Loss standard report.
 with no activity associated and did not choose to display "All rows".
eports), Select Modify report->Display->Advanced->Diplay row->All rows
2:48 PM                             Media Prep
05/29/06                          Item Price List
                                    May 29, 2006

                   Item                                  Description
Agar                                           per gram
Agar block sets                                each
Agar/l                                         per liter (15g)
Agar/plate                                     per plate (20ml)
Agar/tube                                      per tube (7ml)
Beef extract                                   per gram
BHI agar (plate)                               per plate (20ml)
BHI agar (slant)                               per slant (7ml)
BHI agar 2% salt                               per liter (52g+20g salt)
BHI agar 2% salt/tube                          per tube (7ml)
BHI agar w/2% salt (plates)                    per plate (20ml)
BHI agar/g                                     per gram
BHI agar/l                                     per liter (52g)
BHI broth (liter)                              per liter (37g)
BHI broth tubes                                per tube (6ml)
BHI broth w/2% salt (liter)                    per liter (37g + 20g salt)
BHI broth w/2% salt (tube)                     per tube (6ml)
BHI broth/g                                    per gram
Bile esculin agar plate                        per plate (20ml)
Bile esculin agar tube                         per tube (7ml)
Bile esculin/g                                 per gram
Bile esculin/l                                 per liter (64g)
Blood agar case                                per case (100)
Blood agar plate                               per plate
Brown paper for incubator trays                per incubator
Brown paper for tissue grinder
Brucella-broth liter                           per liter (28g)
Brucella broth tube                            per tube (7ml)
Brucella broth w/ 5% FBS L                     per liter (28g + 50ml FBS)
Brucella broth w/ 5% FBS tube                  per tube (7ml)
Brucella broth/g                               per gram
Candida Isolation agar plate                   per plate (20ml)
Candida isolation agar/g                       per gram
Candida isolation agar/l                       per liter (41g)
Candida isolation agar/tube                    per tube (7ml)
Citrate slants                                 per slant

                                                                      Page 3 of 12
2:48 PM                          Media Prep
05/29/06                       Item Price List
                                 May 29, 2006

                     Item                             Description
Columbia CNA w/ blood plates                per pack of 10
Cooked meat tube                            per tube (1g)
Cooked meat/g                               per gram
Dermatophyte Test Medium                    per pack of 10
Eagle Pac, 12                               each
Eagle Pac, 3                                each
Eagle Pac, 5                                each
Eagle Pac, 7                                each
EMJH base/g                                 per gram
EMJH tube                                   per tube (9ml)
EMJH, liter                                 per liter (2.3g + 100ml)
FCGM agar large tube                        per tube (20ml)
FCGM agar plate                             per plate (23ml)
FCGM agar/l                                 per liter
FCGM broth, liter                           per liter broth
Fetal Bovine Serum                          per ml
GMD                                         per tube
Hekoen enteric agar/l                       per liter (76g)
Hekoen enteric agar/p                       per plate (23ml)
Hektoen enteric agar/g                      per gram
HSU-SHOHS                                   per liter
HSU-Shotts agar large tube                  per tube
Lactose broth, liter                        per liter
LB agar, large plate                        per plate (53ml)
LB agar, medium plate                       per plate (23ml)
LB agar/g                                   per gram
LB agar/l                                   per liter (40g)
LB broth                                    per liter (25g)
LB broth/g                                  per gram
LB broth/t                                  per tube (7ml)
LIA                                         per tube (7ml)
LIA/g                                       per gram
LIA/l                                       per liter (33g)
Litmus milk                                 per tube (9ml)
Litmus milk/g                               per gram
Litmus milk/l                               per liter (100g)

                                                                   Page 4 of 12
2:48 PM                        Media Prep
05/29/06                     Item Price List
                               May 29, 2006

                    Item                            Description
Lowenstein-Jensen Medium                  per slant of 20
MacConkey agar plate                      per plate
Mannitol (g)                              per gram
Mannitol salt agar                        per plate
Mineral oil                               per ml
Motility S                                per tube
Mueller-Hinton                            per tube
Mueller-Hinton large tube                 per tube
Mueller Hinton agar                       per plate
Mueller Hinton agar, large                per large plate
Mueller Hinton agar/blood                 per 10 pack
Mycoplasma agar                           per plate
Mycoplasma broth                          per tube
Mycosel agar                              per plate
Nutrient agar plate                       per plate
NZY-broth                                 per liter
NZY-top agar                              per liter
NZY agar                                  per liter
NZY medium                                per plate
NZY medium large plate                    per large plate
NZY top agar                              per plate
Ordal agar medium liter                   per liter
Ordal agar medium tube                    per large tube
Ordal broth medium liter                  per liter
Ordal broth medium tube                   per tube
Ordals agar large tube                    per tube
Pasteur pipette                           each
PBS                                       per liter
Peptone-water/buffered                    per liter (20g)
Peptone water                             per tube (7ml)
Peptone water/g                           per gram
Petri-dish (large)                        each
Petri-dish (medium)                       each
Petri-dish (small)                        each
Phenol red broth                          per tube
Phenol red dextrose agar                  per tube

                                                                  Page 5 of 12
2:48 PM                            Media Prep
05/29/06                         Item Price List
                                   May 29, 2006

                     Item                             Description
Phenol red dextrose broth                     per tube
Phenol red glucose agar (tube)                per tube
Phenol red glucose broth                      per tube
Phenol red lactose agar                       per tube
Phenol red lactose broth                      per tube
Phenol red mannitol agar                      per tube
Phenol red mannitol broth                     per tube
Phenol red sorbital agar                      per tube
Phenol red sorbitol broth                     per tube
Phenol red sucrose broth                      per tube
Phenol red trehalose                          per tube
Phenol red trehalose agar                     per tube
Potato dextrose agar plate                    per plate
Potato dextrose agar tubes                    per tube
Potato dextrose slants                        per tube
PYG agar                                      per plate
PYG agar per liter                            per liter
PYG broth                                     per liter
Sabouraud dextrose slant                      per slant
Saboutaud dextrose plate                      per plate
Saline liter                                  per liter
Saline Sterile (L)                            per liter
Saline sterile ml                             per ml
Saline sterile tube                           per tube
Selenite broth liter                          per liter
Selenite broth tube                           per tube
Shieh agar                                    per liter
Shieh broth                                   per liter
Shoiegh Agar large tube                       per tube
Simmons Citrate slants                        per slant
Skim-Milk gram                                per gram
Skim-Milk tube                                per tube
Sterile dd water                              per tube
Sterile dd water, 100 ml                      per 100 ml
Sterile tube rack, 48                         per 48 rack
Stock culture agar                            per tube

                                                                    Page 6 of 12
2:48 PM                           Media Prep
05/29/06                      Item Price List
                                  May 29, 2006

                     Item                              Description
Stock Culture agar plate                     per plate
TCBS                                         per pack of 10
Tetrahionate broth+bril. g tube              per tube
Tetrathionate broth liter                    per liter
Tetrathionate broth tube                     per tube
Tetrathionate broth+bril. green              per liter
Thioglycollate-broth w/indicato              per tube
Thioglycollate broth (ltr)                   per liter
Thioglycollate broth tube                    per tube
Thioglycollate w/ 1% horseserum              per tube
Todd Hewitt broth w/yeast                    per liter
Trptic Soy Broth                             per tube
Trypticase soy agar plate                    per plate
Trypticase soy agar tube                     per tube
Trypticase soy broth tube                    per tube
Tryptone water                               per tube
Tryptone/Bacto                               per gram
Tryptose broth tube                          per tube
TSI tube                                     per tube
TYE agar                                     per liter
TYE Agar large tube                          per tube
Urea agar                                    per tube
Yeast blood agar w/1% h.serum                per plate




                                                                     Page 7 of 12
2:48 PM       Media Prep
05/29/06    Item Price List
              May 29, 2006

  Price
     0.37
     1.47
     8.23
     0.71
     0.32
     0.27
     0.84
     0.37
    25.82
     0.43
     0.88
     0.40
     0.25
    13.28
     0.31
    15.04
     0.32
     0.31
     1.96
     0.43
     0.43
    30.96
    74.10
     0.75
     7.35
     0.73
    10.35
     0.30
    51.50
     0.58
     0.30
     0.88
     0.47
    22.35
     0.40
     0.37

                              Page 8 of 12
2:48 PM       Media Prep
05/29/06    Item Price List
              May 29, 2006

  Price
     3.97
     1.08
     0.93
    47.29
     1.54
     0.21
     0.42
     0.68
     0.37
     1.35
   150.70
     0.64
     0.72
    13.46
     6.61
     0.82
     0.50
    41.05
     1.13
     1.24
     8.21
     0.54
     7.35
     2.18
     0.66
     0.27
    10.92
     5.88
     0.13
     0.30
     0.35
     0.47
    18.58
     0.21
     0.25
    24.09

                              Page 9 of 12
2:48 PM       Media Prep
05/29/06    Item Price List
              May 29, 2006

  Price
    17.64
     0.67
     0.28
     1.24
     0.10
     0.59
     0.34
     0.60
     0.68
     2.09
     3.97
     1.47
     0.34
     0.82
     0.72
     7.87
     7.87
    12.07
     0.62
     2.14
     0.62
     4.47
     0.49
     3.18
     0.42
     0.49
     0.07
     7.35
     5.58
     0.27
     0.25
     1.62
     0.42
     0.44
     0.25
     0.27

                              Page 10 of 12
2:48 PM       Media Prep
05/29/06    Item Price List
              May 29, 2006

  Price
     0.27
     0.27
     0.27
     0.27
     0.27
     0.28
     0.28
     0.27
     0.27
     0.27
     0.83
     0.83
     0.72
     0.31
     0.31
     0.46
     9.95
     4.36
     0.31
     0.67
     3.31
     3.31
     0.07
     0.25
     7.34
     0.30
    10.66
     4.99
     0.46
     0.30
     0.09
     0.31
     0.25
     0.44
     6.85
     0.39

                              Page 11 of 12
2:48 PM       Media Prep
05/29/06    Item Price List
              May 29, 2006

  Price
     1.00
    27.19
     0.32
     9.70
     0.32
     9.82
     0.32
    11.46
     0.34
     0.50
    15.17
     0.28
     0.65
     0.30
     0.28
     0.25
     0.23
     0.46
     0.32
     9.70
     0.86
     0.32
     0.92




                              Page 12 of 12

								
To top