I am doing a project for work and need to copy a interest formula to the next 214 months (Ipmt function). Ii am receiving an error when I try to fill the...

when i open excel. WPEXCEL opens up first. How do I stop that from happening? Thanks

Hi Community of Excel Users! This is a joint posting from 4 of the "regulars" to these newsgroups: Bob Phillips, Frank Kabel, Ron de Bruin, and Norman...

I have a blank column A and a second column B with different alpha-numeric 17-characters in cells B1 to B50000. These are vehicle VINs. Now, when I enter a...

I have a certified payroll spreadsheet in which I want to display only the employees that have pay data entered that week. I often unhide all rows, enter data,...

I imported a tab-delimited text file, with quotation marks as the text qualifiers. Excel removed the marks, and now I need to save the file back as text,...

Hi there I have a spreadsheet with a SUM formula in Column k. Example K3 formula is =Sum(D3:I3) I clicked and dragged this formula all the way down to K...

Thanks. That worked great! -- Matt in AZ "Max" wrote: Try this .. Assuming the data in cols A and B are in row1 down

In Quattro Pro I was able to print a selection of data from several sheets just by selecting the area in each sheet. Quattro Pro would then put all the...

I have inherited an excel file with numbers across 100 columns and over 300 rows with several blank cells (likely 15%). I would like to format these numbers...

I have the results of a SQL datasource providing the data for a pivot table. Several of the fields are dates however I cannot group them like they were...

Is it possible to disable the Save button automatically on the Excel toolbar only when a particular workbook is opened? I have problems with my forms being...

Hi there, this error seems simple enough--but it won't go away. THE ERROR: "Compile error in hidden module: TBRun9" The error appears when I open or when I...

Como fazer para evitar a digitação de dados duplicados nas células de uma coluna do Excel. Ou fazer com que o excel me informe que já exite uma célula...

I have a situation where I need to lookup Product A but then lookup Company A in a column that changes. vlookup("Product A",A1:T25,hlookup("Company...

Option Explicit Sub SASLineEmUP() Dim lr As Long Dim i As Long Dim lc As Long Application.ScreenUpdating = False Columns(1).Clear lr = Cells.Find("*",...

Hi All I have a workbook which contains 200 sheets. What I need to do is to insert a "cover" sheet and then create a macro pick up 5 cells from each...

I have an Excel sheet that has 8000+ rows that include contact information. I'd like to move them from all of those rows into 6 columns. Currently it...

Please help! I am trying to get the formula below to return a value to the cell ONLY if the answer to ((c30-$30)/g$30) is greater or less than 20%. I am...