I have a dependent drop down list that will allow data entry if the list it is dependent upon has not been chosen.
For example:
Column C50:C99 has the data that column D50:D99 are dependent upon. If nothing is chosen in column C, one can enter anything erroneous into column D. How can I...
Hello VBA experts! I am in need of some assistance. I am trying to extract rows of data from one workbook to another workbook using VBA. Here are the parameters:
Data Source: Workbook = Resource Planning.xlsx
Sata Source: Worksheet = Resource Allocation By Project.xlsx
Report: Workbook =...
Hello All!
I am working with an 2010 Excel file that is approximately 3MB in size with complex formulas on multiple tabs. It is stored in SharePoint V9 and is updated continually with new versions saved.
Do I need to do anything special to ensure the file does not become corrupt? I would...