Search results for query: *

I have looked High and low for a solution to this and I dont seem to be making any headway. I have a very large workbook. I graph many things in this workbook. I am trying to figure out if there is a way to combine two sets of values for the y values of a line chart. In other words column D...

Does anyone know where I can get my hands on a pool of excel dashboards and pre formated charts and graphs?

I am trying to create a MS project from a flat file. I need to have tasks and relationships between them set up. I don't see any way to import this?

Need some help. I am trying to create a chart that has three cumulative lines on one axis and on the other axis I am trying to get one series that is a column and two series as stacked columns.

I am trying to add a column to a pivot table in the form of a calculated field. What this column would do is keep a running sum of the counts in the column next to it. I would need to replicate it for all the columns.

I have looked for the soulution for this in many forums. I know how to set a text box and lable .visible to false base on the value in the text box. The problem I have is getting the items below the hidden text box to move up in its place. Instead of just leaving a blank on the report.

I am trying to write a macro that will give me a page count for all .doc in a folder. I have the code below. It works incrementing through the .docs but it returns the wrong page count. If there is 125 pages it will return 119. Sub documentPageCount() Dim oApp As Object Dim oDoc As...

I am trying to create a Macro in MS Word that will allow me to get the counts of the text contained in each row of a selected column in a table. Example. At the top of the word document is a table that contains the following Table: ID Description TT-9 Shows three walls XY-2...

I am having a strange problem. Not sure what changed on my computer but, whenever I try to open an acces report in design or preview it takes forever. The computer will even display not respondind, but if you leave it for a minute it will open. So I did some digging and it works fine in same...

How do I get an array that has duplicates to contain only unique values. MyArray kpp-1, kpp-2, kpp-2, kpp-3 I want it like kpp-1, kpp-2, kpp-3

I have a listbox on a form. It has 2 columns. They contain the info below: Event1 Pass Event2 Fail Event3 N/A Event4 Pass I would like to highlight the word Pass in green and Fail in red. Is there any way to do this in a listbox.

I am trying to sort the record source of a listbox every time something is added to it from another listbox. It works when I only use alphanumerics with the numeric part below 10 but when I go above 9 it does not sort correctly. Is ther some way to treat the numeric part as a number? example...