Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. questionmark1

    COUNTIF function with multiple conditions

    =COUNTIF(A:A;2)+COUNTIF(B:B;3) ;-)Regards, QM1
  2. questionmark1

    consolidation of excel sheets with vba (update)

    ... now I see the link! My question does not cover the normal case! for the daily business we do have a well organised MIS, which allows to maintain, analyse and report our figures. My question is related to a extraordinary problem, wich has to be solved in a short term perspective. However...
  3. questionmark1

    consolidation of excel sheets with vba (update)

    Hi SkipVought, Thank you for your answer. It seems that it focusses on SQL/Access/relational database. What I am looking for is an excel-based solution with VBA-Modules, which gives me back the sum of all figures reported in the different files in a new consolidation file. Or do I...
  4. questionmark1

    Locking down an Excel Spreadsheet

    Hi Savil, as far as I know excel does not allow you to protect the sheet and in the same time to give the users the permission to insert columns. The best is, to unprotect the cells which you want to be edited (select range of editable cells, then go to Menue: Format --> Cells --> Register...
  5. questionmark1

    consolidation of excel sheets with vba (update)

    STARTING POINT: -in a sub-folder i do have different excel-files (each single file represents one business unit in a company) including -several sheets (each sheet represents one cost center), which - regarding the format - all look the same, -except: number of sheets per file and cell-values...

Part and Inventory Search

Back
Top