Is there a excel spreadsheet function that can be used to interpolate between two columns of data? If not, can you recommend a quick equation to perform interpolation?
I have two users who yesterday were given laptop computers to replace their desktops. These laptops have the same configuration exactly as more than 10 other laptops that we are using. Both ...
Hi,
Excel file too large takes long time to open,save etc.Can all the macros be saved some where and i should be able to run them when required.
Can i have all macros in some folder.When r...
I want to assign a macro to a command button that, when it is pressed, will create a checkbox with no caption and insert it into a cell in an Excel spreadsheet, matching the dimensions of the ...
When I try to preview an Excel 2003 document, I get a message "Margins do not fit page". When I OK thru the message, it looks like each individual cell is going to print to a separate page. ...
I have an excel document i had each sheet protected with a password, I have been succefully locking and unlock the sheet to make changes. However the last time I decide to share the workbook. ...
Hello,
I would like to clear the value from some cells from my range but not the formulas.
This is what I am using:
Range("A2:U1000").ClearContents
However, this deletes the form...
On sheet1, I have three columns (Last Name, First Name and Unique ID).
On Sheet2, I have the same columns.
Sample Data:
Deer John 000000001
Doe Jane 000000002
Clooney George...
I have defined column widths in my Excel Worksheet. I have about 10 columns with varying column widths. I want to export this data to a FIXED WIDTH Text file, so that I can import that FIXED W...
Hi All,
I have an Excel file and a script which takes input as Pipe seperated values, i.e. varable1 | variable2 etc etc.
Therefore I want to either
+ Export the data as Pipe seperated va...
I have 34 pivot tables sharing 6 pivot caches.
Each pivot cache is linked to SQL server query and I update each of the 6 caches by changing the date in MSQuery SQL line. For example, here ...
I am using Excel 2007 and am having a problem saving as 2003 with a specific file. The file is in 2003 format. I am able to open the file. I can save the file as 2007 but it needs to be in ...
I have a macro that I created in Microsoft Excel 2000 and it has been running correctly in version 2000 and version 2003 for a last couple of months. However, just last week, if the macro is r...
I am looking for code that goes through a range and deletes entire rows when it comes to more than two adjacent cells that are empty. In other words, if there are 8 empty rows in a row in col...
I need to compare two worksheets and find the missing values and matching values between two sheets. I couldnt find the formula.
I need only to compare columns A in both with each other. Whi...
I have a workbook that consists of 28-31 worksheets, depending on the number of days in a particular month. A template is utilized to provide a new workbook for the upcoming month. The works...
Here is my code
begindate = Format(temp, "yyyy-mm-dd")
temp = Application.InputBox( _
prompt:="Enter End Date: (mm/dd/yyyy)")
enddate = Format(temp, "yyyy-mm-dd")
Dim datayear As St...
Hi,
I wish to change the colour of groups of rows where a particular fields value is the same to colour number 1. When this value changes, i wish to change the colour to colour number 2 and...
Hi everyone,
I have this issue with 2 Excel files. No matter which one I open first, this error comes up. I can open another excel file with either one, but if both are open at the same tim...
Our lab uses Macs and PCs. Excel gives correct r^2 values on the PC. When someone puts the data into the template on the mac, it gives bad r^2 values (most obvious are negative r^2 - this sh...
Hi,
I am wondering if anyone can provide me with the correct code do to the following task:
I have 5 workbooks. Each workbook has one worksheet that contains a table of data. I want to do ...
Hi experts,
I need to collapse a worksheet that consists of raw data roughly like follows
col1 | col2 | qty | amount
A | B | 1 | 2
A | B | 3 | 4
C | D ...
Looking for some good links to understand vba scripting dictionary and/or some examples
Cell A1 has the Date of the Event
How can we get Cell B1 to show how many days are left until the A1 date.
For Example:
A1 B1
3-31-05 13
Thanks...
Occ
Is there a way to insert a formula inside a text box within an Excel graph? For example, lets say at the bottom of my bar chart, I want to insert a formula (that calculates a result from else...
