Search results

Some of the data are subsets of others employed + unemployed + not in = population no search in past year & no search in past month are subsets of unemployed (but not all unemployed fit these two categories) (1) Did you use a stacked bar chart with different colors? (2) how did you get the...

How to make a chart like http://www.pewresearch.org/fact-tank/2017/03/07/employment-vs-unemployment-different-stories-from-the-jobs-numbers/ the data values are Population 254,082 Employed 150,527 Part time 6,226 Unemployed...

Disabling Multi-Threaded Calculation has helped... but not solved the problem Other possibilities?

Recently switched to Excel 2013 (32-bit) by it department I now constantly get Excel ran out of resources while attempting to calculate one or more formulas. In excel 2007 I used the same multiple inter-linking files daily w/o trouble Using Windows Task Manager: When ever Memory (Private...

You are a Ninja

Can I: (1) Hide all worksheets that don't have charts (2) copy the chart from each visible sheet in sourcewb (3) paste to the correspondingly named sheet in destwb as values or break the link

How can I "break the links" in graphs in a destwb?

This works... is there a faster (or more elegant) way to set the destwb.ws range to "A1" for the end user" For Each ws In destWB.Worksheets If ws.Visible = True Then ws.Activate Range("A1").Select End If Next ws

Sub CopySheets() Dim sourceWB As Workbook Dim destWB As Workbook Dim ws As Worksheet Set sourceWB = ThisWorkbook Set destWB = Workbooks("testTarget.xls") Dim LastColumn As Long Dim LastRow As Long For Each ws In sourceWB.Worksheets If ws.Name <> "Contents" And ws.Visible = True Then...

I need code to loop through the current workbook visible sheets that are not named "Contents" Copy the values and conditional formats paste to another workbook (with known name and sheets already named the same as the source) paste as values and formats SourceWB is .xlsb DestWB is .xls

The part of the code I am having trouble understanding is Static Sub DailyReport() Set Sourcewb = ThisWorkbook Call HideUnHideGraphSheets("Hidden") Workbooks.Open Filename:="C:\Users\Documents\Daily Reports\date.xls" Set Destwb = ThisWorkbook Sourcewb.Activate For Each ws In...

I am trying to: (1) loop through all the worksheets in the source workbook (2) copy the visible ones (3) paste to open workbook as formats and values Specifications: (1) I have several files with 60+ worksheets (2) I need one loop to produce an "East" file and another for "West", etc. (3) it...

Yes... I see how the macro waits 1 second in a loop Cell B2 is set by [myoffset] = i statement the Chart Series ='Movie Example.xlsm'!Data is reset using a named range Could a "Slide Bar" be added to drag with the mouse instead of the 1 second delay

I have included a couple of graphs for Jan 6 and Jan 5 Thinking of a Macro to move a single graph through time like a "movie"

I have a line graph that I have data on consecutive dates for that I would like to produce a moving through time graph. Example Daily Sales in the 10 offices... each daily set of data is in one row with date in column A Office 1 in column B... etc. Could a macro be written to show the...

I am trying to copy excel charts to an existing power point presentation. I am able to goto "sheet4" and select "Chart1" and copy it. (1) How do I get this to an existing PowerPoint presentation? (2) How to I insert this into slide 3 (3) There are multiple charts, on multiple tabs (same...

I see it now! THANK YOU

Is there a way to "Copy & paste" this conditional formatting if there are 1,000 columns... each with different dates in rows 2,3,4

I need to be able to conditionally format an excel sheet such that dates less than x are highlighted one color and those dates less then y are another highlight and those less than z are a third color with those dates greater than z are a fourth color. I have attached a brief sample to...

Not exactly what I was looking for... but this method should help thanks :)

What I am trying to find is a diagnostics tool (I have multiple tabs of 350 x 320 cells) to prevent errors in. The above formula counts errors.... then I have to search the entire sheet to find them.

Still requires me to search a wide and long sheet

I have a sheet of calculations that is 350 columns wide and 300 rows high I have checked for errors using =SUMPRODUCT(--(iserror(offset(Data!$A$1,0,0,300, 350)))) this tells me if there are any errors- which is good. I then have to search for them in the large sheet- which is bad Is there...

I can get column D with {=max((Widgets!B2:AA2)*(Widgets!29:29 ="Fixed"))}

In D5 11/1/2013 in E5 12/1/2013 F5 is given in D6 12/1/2013 in E6 1/1/2014 F6 is given Logic for column D Max of Widgets!2:2 if isnumber(Widgets!28:28) and (Widgets!29:29 = "Fixed") logic for column E Min of Widgets!2:2 if isnumber(Widgets!28:28) and (Widgets!29:29 <> "Fixed")