Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Search For:

Type: Posts; User: Ian Mac

Search For: Search took 0.00 seconds.

  1. Replies
    12
    Views
    3,259

    Thanks, works fine for me, appreciate the feed...

    Thanks, works fine for me, appreciate the feed back !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
  2. Replies
    5
    Views
    3,382

    Hi, You can do this using MS Query to pull the...

    Hi,

    You can do this using MS Query to pull the data from Access.

    Once you set up your query you need to 'edit the query using MS Query' before placing the data on the sheet.

    Goto...
  3. Replies
    12
    Views
    3,259

    I use something similar to the attached file, the...

    I use something similar to the attached file, the real one I use is linked to an mp3 collector DB, but it'll give you a good idea.
  4. Replies
    2
    Views
    3,695

    Hi, How are the tables placed in Access? Are...

    Hi,

    How are the tables placed in Access?
    Are they linked Tables....etc.
  5. Thread: MSQuery

    by Ian Mac
    Replies
    11
    Views
    5,530

    I'm still not entirely sure what sort of data and...

    I'm still not entirely sure what sort of data and how many multiple tables you are talking about.

    Could you expand on what you need?

    If you live for VBA/VB, as you say, you can pull the data...
  6. Thread: MSQuery

    by Ian Mac
    Replies
    11
    Views
    5,530

    Chris is quite correct Also don't discount...

    Chris is quite correct

    Also don't discount the full blown VBA option.

    What DB are you getting the data from?
    Could you use ODBCDirect?

    I don't think this is a lost cause at all, we run...
  7. Thread: MSQuery

    by Ian Mac
    Replies
    11
    Views
    5,530

    You could record the information as you run the...

    You could record the information as you run the query and adapt the code.

    Record what you do and post back (take out any passwords etc.)

    should easily be able to set up the parameters in VBA. ...
  8. Thread: MSQuery

    by Ian Mac
    Replies
    11
    Views
    5,530

    Hi, Not sure what parameters you want, here's...

    Hi,

    Not sure what parameters you want, here's an example of what I think you may mean.

    when you create the query,
    go into MSQuery before returning to the sheet

    Choose Critia>Add
    Chose the...
  9. Replies
    4
    Views
    16,836

    How tired am I: Dim varOld, varNew ...

    How tired am I:





    Dim varOld, varNew

    varOld = Sheets("sheet1").Range("A1:B2")
    varNew = Application.WorksheetFunction.MInverse(varOld)
  10. Replies
    4
    Views
    16,836

    The Excel way to pass the result back to the...

    The Excel way to pass the result back to the sheet is:

    Dim varOld(1, 1), varNew(1, 1)

    varOld(1, 1) = Sheets("sheet1").Range("A1:B2")
    varNew(1, 1) =...
  11. Replies
    4
    Views
    4,326

    What do you mean by a persons last name? Where...

    What do you mean by a persons last name?
    Where is this information?
  12. Replies
    2
    Views
    2,046

    Hi, Try using: ...

    Hi,

    Try using:

    =IF(AND(N8>=50,N8<55),10,IF(AND(N8>=55,N8<60),13,IF(AND(N8>=60,N8<65),16)))

    Hope this helps.

    P.S. The Excel Help file on the IF function is fairly extensive, it gives...
  13. Hi, Which version of excel are you using? ...

    Hi,

    Which version of excel are you using?

    97 needs specifically created Web Queries (I assume you mean this)
    2000 and XP you can set them up quite easily

    If your trying to extract certain...
  14. Hi, Try something like: Add Dim lastRow...

    Hi,

    Try something like:

    Add

    Dim lastRow

    To the begining of your code
  15. Replies
    1
    Views
    9,849

    Hi Bill, Chr(10) is the ASCII character...

    Hi Bill,

    Chr(10) is the ASCII character Linefeed,
    you will also need:

    Chr(13) which is a Carrage Return

    [Name] & chr(10) & chr(13) & [Address1] & IIF(NZ([Address3])=0,"",chr(10) & chr(13) &...
  16. Replies
    1
    Views
    1,378

    Hi, Your gonna need code for this one. hit...

    Hi,

    Your gonna need code for this one.

    hit Alt+F11 then insert a new module,

    Insert&gt;Module

    and copy the following:
  17. Hello, OK. If you highlight I3 on sheet...

    Hello,

    OK.

    If you highlight I3 on sheet Billy Smith and goto conditional formating.

    the 2 formulas you currently have are:

    =I3&gt;INDEX(RECORD,MATCH(H3,EVENTS,FALSE),1)
  18. Hello, I see where your problem is, in the...

    Hello,

    I see where your problem is, in the formula you are using for the conditions, you are using named ranges, RECORD, BEST and EVENTS

    These refer to only ranges on the Billy Smith sheet,...
  19. Replies
    3
    Views
    1,690

    Hello, firstly no there's attached workbook?...

    Hello,

    firstly no there&#039;s attached workbook?
    not to worry though.

    Have you checked, Tools&gt;Options&gt;Calculations

    Change from manual to automatic.

    seems that should be the problem...
  20. Thread: Quick Charts

    by Ian Mac
    Replies
    0
    Views
    3,482

    Say you have a set of data like:

    Say you have a set of data like:

    <SCRIPT language=JavaScript src="http://www.interq.or.jp/sun/puremis/colo/popup.js"&gt;</SCRIPT&gt;<CENTER&gt;<TABLE cellSpacing=0 cellPadding=0 align=center&gt;<TBODY&gt;<TR&gt;<TD...
Results 1 to 20 of 20
porno