Search results

  1. S

    setting VBA code for count of a variable range

    Hi, 1. I have a sample database table in excel where depending on column 2 value >1 is checked and logical results by IF check placed in Column D. The values having "Y" in column D are placed in Columns E:F. 2. Now I want to place count of values meeting the condition on last...
  2. S

    operate VBA macro on multiple files in a directory

    Hi, I have contract notes files in .xls format towards sale of equity shares from the brokerages. I have to do some editing in these files like deleting some rows, adjusting width of columns and inserting date of contract. a) Contract-A.xls shows original file. b) Contract-B.xls shows modified...
  3. S

    Calculating columns total

    Hi, I have a personal expenditure data base indicating daily expenditure on various heads ( File Attached). I want table to reflect expenditure on various heads on daily basis in COLTOT column. Any subsequent change in any of the field to be dynamically updated. Presently I am exporting file to...
  4. S

    Hello to All

    Hi, I am an engineering professional with more than 3 decades of working experience. I have extensively used Microsoft Access. Only recently I have started learning VBA Automation and advanced capabilities of Access. Best wishes to all of you. :)
Back
Top Bottom