Hi Experts,
I have a spreadsheet which develops a project budget across 5 years. Thus I have Worksheets: 'Year 1', 'Year2',..., 'Year 5'.
Currently have some code in year 1 that checks to se...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 06/05/2008 Rating: 8.9 Views: 0
Hello,
I have code from which a key reference does not "register" for code to pick up particular text files for import process. Line 6 seems to be the main issue. Its not returning the "target"...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 08/10/2008 Rating: 9.3 Views: 0
I have an Excel 2003 sheet with data in one column and many rows that looks like this:
PLU2 000000000000000002
2 5.50
PLU10 0...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Strange issue. Row 616 has disappeared in my spreadsheet however there is still a placeholder for it that is blank. Also, cell values and/or formulas show in the forumla bar for this row, however...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 04/13/2009 Rating: 8.0 Views: 0
I have two data sets i need to combine.
sheet1 (extensions) are allocated phone extensions. and look like this:
102,
103,
sheet2 is a list of names to numbers, some are shared:
102, ...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 05/21/2009 Rating: 9.3 Views: 0
I have a an Excel workbook (wb1) with 4 worksheets.
I also have a personal.xls that contains 4 worksheets.
wb1 has volatile functions.
I have calenders, dropdown lists, read from a file that is...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_247...
I have a row that contains monthly results and I want to select the last monthly data entered.
So in the below example I would want to look for 2007 and select all of the rows with the data below ...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
I am using the Day() function to return the day number. I want to be able to take the result and add another number to it. Works fine as long sa the total is less than 31. How do get a total > 3...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
We have a Citrix farm, with 3 node servers. I need to be able to set the Macro security settings to 'Low' for all users. I know the reg key that controls macro security settings:
HKEY_CURRENT_US...
http://www.experts-exchange.com/Software/System_Utilities/Remote_Access/Citrix/Q_23478763....
Hi Guys,
Can someone please let me know why Excel 2003 performs recalculations upon opening every spreadsheet. As it takes a very long time to complete before the spreadsheet can be used? I do...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 06/14/2004 Rating: 6.8 Views: 0