Recent content by flynjack

  1. F

    Keyboard Short Cuts

    I'm pasting into a program called "Zilan". Hope this helps. Thanks flynjack
  2. F

    Keyboard Short Cuts

    This sounds simple, but I can't figure it out. I have query that, after run, provides all of the info I need. Here's my problem. I want to simply "Select All" records, "Copy" these records, do an "ALT+TAB" (Or prefereably be able to have it slect the application i want to paste in), and...
  3. F

    Chart/Graph

    I have a simple query that shows me how many records match a certain criteria. Let's say today it reflects 2500 records. Tomorrow it may be 2700 records, and then next day it may show 2200 records. I want to graph this total number on a daily basis. Does anyone know how to do this. Thanks.
  4. F

    Using IF statement with GETPIVOTDATA

    Got it to work with ISERR instead of ISBLANK. Thanks for the help.
  5. F

    Using IF statement with GETPIVOTDATA

    I have tried the Isblank command and it still doesn't work.
  6. F

    Using IF statement with GETPIVOTDATA

    Mailman; Took out the "=" signs based on your recommendation. Unfotunatley, excel still doesn't like it. Any other ideas?
  7. F

    Using IF statement with GETPIVOTDATA

    Hell all; I have an excel spreadsheet that is linked to a pivot table. The cell will reflect what ever the pivot reference link is behind it. Here's my problem, if the link doesn't exist (Null) I want the cell to reflect "0" (Zero). I assumed the following formula work but it doesn't...
Back
Top Bottom