2007

<colgroup><col width="69"><col span="7" width="64"><col width="71"><col width="85"></colgroup><tbody> </tbody> Hi I am hoping to learn how to setup a unique list of vendors (VendorList) from a list using a named range, then loop through that list in a VBA macro that is using filters...

Hi - I have been attempting to update a sharepoint list using vba 2007. I have attempted the following: using SQL to treat the list like a database table (using connection strings - per SharePoint connection strings - ConnectionStrings.com). With this method I can write to an Access database...

Hello, On a sheet (first_sheet), i have activex comboboxes on a grid that contains values of sheets/columns, so that for each sheet if YES is selected nothing happens, but when NO is selected, these columns must be removed automatically from these sheets right after their generation. Now the...

Hello, I have Microsoft Excel 2007. However, some of my formula's are not automatically updating. I set my Calculation Options set to "Automatic" but the formula's are still not updating. Please help!

<tbody> 1 a 2 b 1 2 b 1 d 1 1 a 3 a 1 5 d 5 c 3 3 c 6 d 2 </tbody> I have a table in it that holds data. I have a second table that will report a total count off the first table. An example of my “data” table is above. The formula I am trying to write needs to search for a...

I am trying to create a COUNTIFS Function in Excel 2007. Essentially what i have is a named range, for the example we will say i named it "NATO". the function I am trying to write is a count is does not equal "NATO" and equals yes. Here is a copy of the live formula (referencing tables with...

I currently have 93,643 lines of a CSV file that I run a PIVOT table on and it works exactly as I want it to. What I am looking to do is from within the PIVOT table be able to adjust the number of ROWs that the PIVOT table uses to calculate its report. Other than having to go in and each time...

Just thought I'd share this nugget of information. VBA based cut/paste of a range containing a form button has slightly different behaviour in Excel 2010 vs Excel 2007. If the source range is hidden the button will NOT be copied when using 2010 but will be copied when using 2007.

I'm looking to set up a spreadsheet to keep track of payments on a small personal loan. I got a template, but it's not exactly what I wanted. I want to set it up with formulas to auto figure out balances. Below is a snippet of the spreadsheet I have so far. It's a loan for a car to a friend. no...

Good afternoon! I am trying to come up with a way to quickly go through a large range of cells and paste the formulas (and then values over-top) to ONLY the visible rows. I feel like I am missing some small and simple thing that is keeping me from getting this to work. Any suggestions would...

Good afternoon all, I am trying to develop a simple macro to on button click transfer the data on sheet1 (for example called "Notes") to the first open row on sheet2(for example called "Log"). Below is where I am at right now, which gives me the result after clicking where I can see it shifts...

If J2 has an X in it. Can A2:I2 b highlighted with a colour fill. Can I then user Format painter to have this all the way down the spread sheet? I so what would the rule be? Many Thanks

Hello Using Excel 2007.. I need to find a way to insert cells based on a cell value, for example if cell D2 says "4" then I need a macro that can insert that amount of rows. To make things more complicated, I will need to ensure that the macro inserts rows after the row with a specific text...

Is it possible to recover overwritten files in excel 2007? By mistake when I created a new excel file I named it with the same name with an existing file that I had and when excel asked me if I want to replace the new file with the old one I said yes.

Hello. I am new to the site but have already found a TON of helpful information! I would like some assistance with a 2007 Excel spreadsheet. My company currently shares ONE spreadsheet to generate new project numbers (Shown below). My issue is once a new number is assigned, it is supposed to...

Afternoon, Many years ago my esteemed former colleague created a very complicated spreadsheet in Excel 2003 which I shall call "Parasite". He departed for sunnier climes a couple of years ago and I have since been given the task of updating this spreadsheet. The original spreadsheet contained...

Hello everyone! I have a question about the RANK-function. I need to have a ranking, simple enough with the RANK function. BUT... There need to be 2 criteria in 2 other cells met before a ranking is assigned. For example: Cell AC4 is attendance, needs to be "Y". Cell AH4 is test result...

Hi, using Excel 2007 I have a pivot table that counts that number of incidents based on month and year. To get the month and year I group the date field as months and years. My problem is if I want to filter specfic months in say year 2012 it also takes out the month in 2013. I though it used...

Hello, I work for a company that does business with a contractor for outdoor services. We have a spreadsheet that has all of the details for each project and then whether or not the project is open or closed. The goal is to have the spreadsheet send an email to a list of recipients when a new...

I have frozen panes and hidden rows using Excel 2003. When I open the .xls file in Excel 2007, the freezing of pane and hiding of rows is ignored. Is there an incompatiblity in the way these states are saved in the two versions?