vba question

  1. A

    Is there an OFFSET style formula that works when the Data Source is not open?

    I've attached an example of the file I'm working on. I would like to keep the data in a separate file. But, offset formulas don't work if the data source is not open on your computer. I'm using the offset formula because I need to use both Row and Column references to find the data I need in...
  2. H

    Timesheet and Project Activity Tracker

    Hi, I wish to make a project activity and timesheet tracker. Where the analyst will provide information on hours spent on projects on daily basis. Form that information, I want to create a project activity tracker and also the information will give details on daily timehseet or productivity of...
  3. D

    Macro Ask User Input, Proceed if Ignored

    Hello everyone, I have a workbook with a macro that runs automatically when the file is opened. It works great, except that the process takes quite some time due to the size of the file and the scripts it triggers. I have Windows Scheduler setup to open (thus run) the worksheet at a certain...
  4. B

    VBA code for Names

    I am new to Visual Basic. I am, however, an old programmer. I have used RPG, Fortran, Pascal, Cobol... I have completed one project in VBA and am now tweaking that code for my next project which is very similar. I just need to know how names of persons are reflected in the code. I need to...
  5. M

    Tricky VBA Question??

    Hi, Have two Workbooks (1 Sheet in each) and was wondering whether the following is possible? Each 'workbook' has; Column 'A' - Unique employee pay number; (there may be more than one entry for the employee but column's 'x' and 'Y' are different in these cases Column 'X' has date; Column 'Y' has...
  6. L

    VBA If...Then Statement Question

    Hey, I’m having a little bit of difficultly with the following vba line. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> If ActiveCell.Offset(0, -8) = 3 And ActiveCell.Offset(1, -8).Value = 2 Then<o:p></o:p> <o:p> </o:p> Basically, when I...

Some videos you may like

This Week's Hot Topics