What do you think about Windows 7? Write a review or a how-to about Microsoft's newest product and earn unlimited points!

 

Having problems asking a question? Have a general question about Experts Exchange? Let us know!

 
Top MS Excel Solutions: 201 - 225 of 2514
 
I pieced together this code to populate 2 list boxes.  I really need either to link the two so that if I select 'number' the corresponding 'name' is selected in the other box or vice versa.  I...
Follow up question to http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_24669360.html The following macro updates a master worksheet from files ...
Experts, I have two blocks of code Dump and Dump2.  They work great separately but when I run them together (by pressin a button) I get a Runtime error '9':  Subscript out of range. I wi...
I am attempting to create an array in which the values are populated based upon a cell's value in a sheet called Output. If the value of cell O9 > 0 then A should be populated into the arra...
Automatic Workbook calculation keeps reverting back to 'manual' -Excel 2007
Thanks for any help!! I'm trying to color all specialcells (ie 16 & 2 for errors and text) with red fill so the user can find the cells in error and correct them before re-running the app. ...
I want to use FileDialogSaveAs and add a filter so that the default file extension is .doc. From within Excel, I open a word template (.dot), and some information from excel cells, and then wa...
Hi again experts.  I was trying to do this one on my own and quickly realized it was out of my league.  What I am trying to do is have Excel compare a row of cells (row #5, 8 cells total) and ...
In the attached spreadsheet I currently count all the rows for each sheet.  I need to break this down by year and months Details on spreadsheet
Hi, I have an Access macro to run a bunch of queries (select, make-table, and append) with the final output to an Access table. I'm going to retrieve the above final output in Excel.  But b...
Hi Guys, I'm working on unpivot a table and I want to create a new table as a result of the unpivot results. I place the codes below. can anyone help on this please. Thanks!
I'm working on a project where I'm pushing 70 different batches of into an Excel workbook programatically.  I'm then plotting each batch using an Excel chart.  Here's the part I'm struggling w...
dear experts, i had created a button which can list the most updated data on the last row by pressing it. However, i hoped to make it updating automatically on every 1 minute? or even 30 s...
Hi all, we have been running a booking form which is a word template, this template adds a new line to an excel spreadsheet when saved. However we have been adding a date field using the fo...
I am a fairly decent VBA programmer.  However, programming class modules boggles my mind.  Can anyone share with me some good links to tutorials on class programming in VBA?  Preferably Excel-...
See the related question. jppinto got me started. I have a solution that is "good enough" but the date value for the column is a formula, and if I change one value, the dependant rows cascade ...
I am trying to figure out how to write a VBA command line that will do a Counta() formula for column B.  Cells to be counted start on A3.  The last entry in the column will change from day to ...
Hello, I have a table like this, starting at location A1. Date  Q1  Q2  Q3  Q4 1/10  5     6    5     4 2/10  6     8    10   8 4/10  4    12    5    6 5/10  8    10    5    6 Wh...
I already have a feeling the answer is no but if anyone knows a way of selectively interpolating points on a graph when blank data is encountered BUT also being able to choose to leave a gap f...
How do i count non empty columns in a worksheet
I have a spreadsheet with 5 tabs.  I would like to have tabs 1-4 be named by values entered in tab 5 in A1 - A4
Hi,    Here is a weird one, we have one person who cannot get excel to total anything up anymore.    We have a simple spreadsheet that we fill in our project time on. It then uses the ...
Dear experts: I would like to learn rom you geniuses how to get NPV  from the following sample question, using Excel Financial Formula: ____________________________________________________...
Experts, I have an expanding list on worksheet DATA with formulas in both columns C and F. Is there a way to embed the formula so that the user can not enter data there (such as data val...
I have a worksheet that has 2 columns of lookup data on one worksheet...amount and percentage.  I will have numerous other worksheets that need to reference this data. I want to use the LOO...