A client is using Office 2003. She has many excel files saved onto the desktop. When I double click on a file to open it, Excel opens but the file does not. There is just a blank screen wit...
I have a calculated field in the attached file called "NEW" that is using an IF statement. The answer is not correct. Can an IF statement be used in a Pivot Table calculated field? Thanks. ...
Hi...
I was trying to do something in excel which havent done till now...Now..lets say i have 10 Items of 5 quantities each..with a different price range...now if sell each quantity i would...
When you make a new sheet, the scroll bar goes from the top to the last row of data.
I have a sheet where data has been removed but the scroll bar still goes to the original end, this is caus...
Hello,
I need to create a button that
-has the label "Hide columns" on initial state.
-on first click: hide columns: G,H,I, K,L, M, O,P, Q and switch to show text "Show columns" to sho...
Earlier I posted a question on how to find partial text within a specified range. The solution that was given was to use:
[quote][b][u]zorvek:[/b][u]
=VLOOKUP(Z1&"*",A1:B14,2,FALSE)
Wh...
Hi,
when opening an excel file on an xp workstation on a windows domain excel is looking for pro11.msi which i cannot find on the hard drive, where can I get this file and why is excel su...
I have a logic below, but I am not sure how to write in in Visual Basic to work with an excel spreadsheet.
if Sheet1 D2="No" Then
Go to the Sheet1 D3
If D2="Yes" Then
Copy Sheet1 AX2...
Greetings,
I have an problem with two client computers, which are occasionally unable to open XLS files from a shared network folder localized on a Windows server running Server 2003. The p...
Hi,
I have a workbook that contains a directory linked to worksheets, and the worksheets periodically change. I would like the hyperlinks to automatically change with the worksheets. So so...
Dear Experts,
I have an excel spreadsheet in which I want different users to put data. I have primarily 1 main user but there will be 1 or 2 others who will use the spreadsheet for different...
I would like to do an advanced filter does not contain more than one text
this worked
<>SampleText1
but when I tried 2 texts it does not work i.e.
<>SampleText1
<>SampleText2
At a point in the execution of a VBA script, I want execution to pause so the user can review the spreadsheet created up to that point, delete some unneeded rows if they are present, then resu...
I work for a company with roughly 2,000 active employees. I am looking for an Excel Application or adeqate template that will keep track of employee hours (accrued and used) in regards to vaca...
Hi experts:
Thanks for the help with my previous question. The following code works when the user changes certain cell (in this case, B23). However, it doesn't work if the cell changes beca...
Hi everyone,
My question is about how to create a macro to enter in the reference formulas for about 900+ files that have different file names but are all located in the same folder. Furthe...
I have a column of data in MS Excel. THis column represents requirements text.
I need a script or method to find every instance of the word 'shall' and make it bold. Nothing else shoul...
I'd like to create drop-down lists that change according to the previous drop-down selection. For example, I want to create three drop-down lists: Geo, Country and City using the following ta...
Hi I am presently trying to get a CSV file imported into excel. The CSV file has a number of columns and one of these columns holds string of data. In this string of data I have found the char...
Hi there,
I need a formula to convert
A1 : N25 19.1000
A2 : E055 14.5000
into
A3 : N25 19 06
A4 : E055 14 30
There may be some decimal seconds, that's ok
Thanks in advance
R...
Experts,
I was helped by mikeopolo with the following formula:
=IF(D2="IC Bl","IC Blue",IF(AND(F2="HMO",OR(D2="A",D2="B",D2="C",D2="D")),"BCN","BCBSM"))
From question: http://www.expe...
I have an Excel form and to print it I run the following macro:
This month when I tried to run the macro I got the following error message:
Run time error 1004
Method ActivePrinter ...
I want to redo the following formula, if possible:
=SUM(B6:B50)-B11-B16
To be: for B6:B50 Sum the total, IF the column D, on the same row is NOT empty.
In this spreadsheet Column B is...
I have a spread sheet with two buttons on it. However I will like the cells on the spread sheet to be set to locked whenever the user selects the save button and unlock when the user selects ...
How can I detect that a row or column is beeing added or removed and modify a named range accordingly ? ie. : The range is defined as =Sheet1!$A$1:$E$14, a user adds 2 columns and a row, progr...
