Search results for query: *

In Excel, I need to count the unique values in one column based on the values in a second column. Here is my example using data in columns A and B Column A Column B TrackNo Priority 8710 1 8710 1 8720 1 8730 0 I want the unique count of "TrackNo" that...

I’m looking to protect a worksheet, but allow grouped columns to be collapsed or expanded. Also would like to allow the user to set filters and hide columns. I put the below code in the “ThisWorkbook” object. This protected the worksheet but not with a password. The VBA below allowed the grouped...

I created a UDF to return the modify date and time of a file located on a network drive. I entered the function in a cell and UDF returns the correct date. But, how do I get the function to automatically calculate? When I open the file, the last value of the UDF still displays in the cell even...

Looking for help with some code. After I select a cell I want to execute a macro that will do the following. Insert 4 blanks rows, then move down 5 rows. If the new cell is blank, stop the macro, if not insert 4 blank rows, then move down 5 rows. Loop. Any help would be appreciated.

I’m using Access 2016. I have an autoexec macro that runs every time the database is opened. How can I set a condition that only executes the autoexec macro if the database is opened between 5:45 AM and 6:15 AM? Thanks for any help.

I have an Excel file with a tab that is linked to an Access table. Other tabs in the workbook have named formulas that refer to the data in the data range from the linked tab. The formulas are SUMIFS. I have the workbook and all the sheets unprotected. I click on Data>Refresh All. Then at the...

I’m trying to use the split function in Access to split a string into substrings that has a ; delimiter. For some reason “Split” is not being recognized by Access as a valid function. I’m getting an error message stating: Undefine Function “Split” in expression. Anyone else seeing this?

I have a workbook with many sheets. All the sheets and the workbook are protected. I'm using Excel 2016 Two of the sheets contain data from connected Access tables that needs to be refreshed periodically. However, when I click “refresh all” I get an error that the sheet is protected. After I...

I’m using Access 2016. In MicroSoft Access: 1. I go to the External Data tab. 2. I click on New data source 3. I choose from Online services 4. Then I choose SharePoint list 5. I get the pop up box for Get External Data – SharePoint Site 6. I enter the url for my company site. Example a...