wkbk

  1. H

    Untruncate

    Need macro, not formula. Workbook A. Sheet 1 Column B starting in Row 7 has a variable number of names with spaces between the rows of names. Each name in the cells has been truncated to 11 spaces by a DB3 program. Workbook B Sheet 4 has those same names in Column A sheet 4 starting in Row 4...
  2. P

    Macros not working from Share Point Site

    Our IT department just migrated all of our data to a SPS and then I have a mapped local drive that references that location. Every Client Wkbk I open has a user authentication dialogue that's called on opening the workbook. Every time I go to open a Wkbk, I get a run time error. At first I...
  3. E

    VBA - VLookup from Closed book (Fastest way ?)

    Hi all, I want to vlookup from an closed workbook. i have the below code which pulls up the particular column data from an closed book. When i apply the formula(=VLOOKUP(B18,'C:\My Documents\Temp\[Demo.xls]Sheet1'!$A$1:$B$10,2,FALSE). the file size gets heavy. Is there an better way around...
  4. S

    Updating data from one workbook to another

    All, I am in need of some help. I have two workbooks - A acts as a database of all our quotes, whilst B is a local file with just the quote info for that particular job. I am trying to write some VBA to loop through all the quotes in B (unique id in col F) and update the main database. I am...
  5. JonXL

    Trigger Event in Wkbk A Based on Selection Event in Wkbk B - no Macros in Wkbk B

    Good afternoon all! What I am trying to achieve is this: - User opens Workbook A - User clicks a button to open Workbook B so they can edit it (B is password protected, it can only be opened in write mode from book A; this is supposed to 'force' users to only use book A (and its userforms) to...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top