1. A

    Need help modifying code to make user friendly

    I have a piece of code that will only work if the column the data is to be pulled from is column"A". I would love to have the code modified so that this will do the same thing if the data varies in location from spreadsheet to spreadsheet. If for instance, on a spreadsheet the data is in...
  2. S

    Help modifying macro - accounting analysis

    I have the macro shown below, which I found in a 2003 issue of the journal of accountancy - and it works great. However, it only works on a data set that begins in cell A1. I want to incorporate it into a spreadsheet I have where my data set begins in cell E15 and goes down from there(column E...
  3. B

    Multiple users

    Does anyone know how to set XL so that in a workgroup, multiple users can modify an excel file at the same time? any help will be greatly appreciated!!

Some videos you may like

This Week's Hot Topics