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...
