investment bank requires IT admin with excel skills:
Will this position require knowledge of troubleshooting Excel spreadsheets and if so what are the most common faults that arise?
Idea...
Sometimes I feel soooo dumb. But I'm not dumb, just very old and tired at 76 on an extremely hot day in Palm Desert (108 degrees.) Plus I have not done any programming in over 6 months. Usu...
I cannot change the worksheet name in my workbook. THe only options when I right-click on the names are View Code and Select All Sheets. Anyone have any ideas what the hold up could be or if t...
Hi
Can anyone tell me if it is possible, and if so, how do I get the current value of the printtitlerows in Page setup to read into a variable in my userform?
I can send a value from my use...
I have 6 large databases I want to merge together into one even bigger one.
They are on separate sheets with headers:
ID tag value1 value2 value3
ID tags are always in the same ...
I have one excel file with password. When I tried to open it, it always asked me to enter the password. I forgot the password set before. How can I open this excel file?
Thanks!
Dear Experts,
after a longer break, I'm back to challange you :-)
I have an excel sheet table let's say from A1:F10 and in this table. In the G column I want to have the result.
In the c...
Im populating an excel report (approx 3MB) through VLOOUP functions from several linked files (approximately 6 files and none are larger than 1.4MB). When I have my report and external links...
I have a list of about 5,000 contacts with the following categories: Name, City, State, Zip. I currently have an addin that allows me to search for the closest 50 zip codes based on my entry ...
I have about 150 delimited .dat and .txt files I need to import into an excel spread sheet on a regular basis. The delimiters for these files are commas and spaces. I would like to write a VBA...
I have a large file with a mixture of date formats. A certain very large section of records have dates that just won't sort with the rest of them. I tried the following methods to get these r...
I get a daily CSV file emailed to me. I copied over 100 daily emails to a folder. Is there a way to extract the imbedded CSV files and place them in a different folder. Currently I have to o...
In Excel 2003, on a Chart sheet, you could Format shapes/text boxes and such to specifically not be printed.
This tickbox has vanished in Excel 2007 and I can't find any way of not printing o...
- I previously set my pivot range to eg sheet1!$A:$G, but the workbook became Humongous
- I have seen a solution where you can set the range to a dynamic range but as there are data quality i...
I have an Excel spreadsheet and I want to filter on two columns at the same time but without excluding each other.
For instance if this is the spreadsheet:
No. From To
---- ---- --...
The attached code will ask the user to select a range and then will identify the amount of cells in that range. If the user has merged cells it will NOT count a merged range as one cell. I w...
I am new to conditional formatting. I am most interested in blanking out the #NA that results from a formula. While I want the #NA to exist in the cell, I do not want to see it. It has been...
Hello,
I am summing in excel and I use a calculator and what I come up with is different than what excel has.
eg:
in Excel:
53.8%
23.3%
11.4%
8.3%
3.3%
====
100.0%
========>it i...
Example:
In cell E1 I have formula: A1/A2
Result: 1.34, that is OK, I want two decimal places
But when I adjust this formula to look like this: A1/A2&" kg" , the result is: 1,34210526315789...
Hi All,
Using Excel from the Office 2007 suite.
When I open a local or networked excel file it will seem to hang like nothing is happening.
Excel opens, but the document does not.
...
I need to rename the sheet tab when automatically inserted with numeric wording, i.e., "week one", "week two", "week three", etc. Is this possible?
I am trying to correct a formula and when I hit enter, I get the how formula showing up on the cell, instead of the result. How do I fix this?
I have a workbook querying data from another workbook in another network drive using MS Query.
How can I unprotect the workbook when I query it? And also if somebody opens the workbook and i...
I have a excel main workbook containing 50 tables. I would like to have a seaparate xls file for each table in that workbook. So at the end I will have a folder containing 50 diferent xls fi...
I have a Finance Director (VIP to my position) who claims:
"While I am working on the budget, if someone sends me an email and I click on the icon in the lower right hand screen, the PC jum...
