I am working in Excel 2007. My preference would be to do this without VBA. I am trying to count backwards a number of months starting from a given date. For example: Start Date: July, 2010 Countdown: 12 months Should result in: Jun 2010 May 2010 Apr 2010 Mar 2010 Feb 2010 Jan 2010 Dec 2009 Nov 2009 Oct 2009 Sep 20...
Hi all, Again I'm wrestling with Excel 2007! I have some data I'm using to generate a Pivot Table and I'd like to divide all of the data by 1000... I know I could go in and change the original data by hand but I'd much rather have a formula in the Pivot table itself that does this for me. Any thoughts? ps: You guys are awesome! ...
hi, I have the following excel formulae in different columns: = IF( OR(D2 <1000, D2 = 1000),"5","") = IF( AND(OR(D2 <10000, D2 = 10000 ), D2 >1000),"4","") = IF(AND(OR(D2 > 10000, D2 = 100000), D2 < 100000), "3","") = IF(AND(OR(D2 > 100000,D2 = 100000), D2 < 1000000),"2","") = IF(OR(D2 > 1000000,D4 = 1000000),"1","") so total 5 ...
Excel 2007 is driving me nuts. I have several charts set up that I refresh periodically against some data in a SQL database. However, every time I refresh them, Excel bumps any absolute ranges I have for the charts to view this data by the amount of new records returned from the query. The data is time related (I have a record for eac...
Is it possible to transfer to excel the exact name of the files and its size from a folder, without having coding knowledge? ...
Hi Can someone point me in the right direction for writing to an excel file in java?? I am not understanding the links I found online. Could you just send me a link or anything which I could follow through?? Thank you, J ...
Hi there, I understand that Excel 2003 has 65,536 rows limitation which was increased to 1,048,576 in Excel 2007. My question is : If a macro targets Excel 2003, and is opened in Excel 2007, does the 65,536 rows limit still apply? Thanks in advance. ...
I have an excel sheet, in which i have multiple cells selected, which are not adjacent to each other. When the user click on the button, we need to read all the cells data, process it and write it to some other cell. If the cells are adjacent to each other, i was able to get the range and able to perform the operation. But if the cells ...
Hello, I want to count no of different cells which are selected using VBA. Consider if we select five distinct cells - D5, C2, E7, A4, B1. Is there a way I can count these number of cells. Secondly how can I retrieve data in these cells. Lets say I want to store it in an array. Thank you for the help. ...
Hi, I need to simply color the cell based on its text content but I cannot figure it out. I tried conditional formating and use formula (="Text") but it did not work. Any help very appreciated! ...
I have a access database that has customers, products with different product lines, prices etc., and each customer has their own specialized price sheet. I'm trying to make a way to do invoices based on this database, so that when you select a customer it fills out the rest of the customer info; city, state, zip, etc., and know what pric...
I'm posting this question and answer to help anyone else that might need this bit of code in the future. I had a hard time finding a complete code sample or even an explanation of how to add a comment to an Excel cell. Hopefully this will help someone in the future. ...
I have a sql query that pulls in form multiple tables, how can I run that query to import into an excel sheet? ...
Before everyone here closes this question for being a duplicate, I should say that I have looked at the other ones, and tried the answers with no luck. Here's the connection string I'm using strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + FilePathBox.Text + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=1\""; I've sear...
Hi, I wrote a Java method that uses POI HSSF API to convert an Excel file to my data structure. The code worked just fine for a while. But now there are suddenly problems. I suspect it might be because recently we installed Office 2007 on all the client computers (previously we had Office 2003). The problem I run into is this: inside t...
I am trying to filter for multiple criteria, but I see that the "Filter" option only has 2 fields for "AND/OR" options. I have a column full of links. I want to extract all rows that contain these in it: .pdf .doc .docx .xls .xlsx .rtf .txt .csv .pps Is there a good way to do this? ...
I have an invoice spreadsheet with comboboxes to select a product which fills out the product number and name in the invoice. Then I have a clear button that clears the information out to do another invoice, but the combo box and the linked cells don't get cleared. I tried adding the code ComboBox2.Clear or ComboBox2.Value="", or DropDow...
I am developing an Excel VSTO C# add-in. The add-in has a single command-bar ribbon with 1 command-bar-button. the purpose of this button is to open a dialog window that allows search dates to be entered then calls off to a web-service to retrieve data, which gets populated in the spreadsheet. The problem is that after the instal...
Hi, I developed a excel add ins using VB.NET 2005. and in this when i adding page break below error is occurred :- This action exceed the number of page breaks you can manually add to a worksheet. a worksheet can contains up to 1026 horizontal page breaks So can any one suggest how i insert more than 1026 page break or any other s...
Hello, I have a csv file, which consists of many fields (columns). However, I would like to import some columns while not others. Every time I am importing csv files with same structure and selecting columns one by one takes much time. How to automatically select the columns imported? DO I need a template or VBA code? (I am lack of pro...