Search:

I have two subtasks (highlighted in red) that I want to change the start date for in the attached project (line 246 ad 332). I would like line 246 to be able to begin on 12/1 and I want subtask 332...

Rory,
Thank you for the prompt response. So you would set up the conditions in a table that would interact with the B3:C11 table and set the markers to the series of the conditions table. I'll play...

I have created a picture-based marker type for a data series on a scatter plot. It currently uses a single picture, but I have inserted six different picturesI know that I can create multiple data...

Gary,
1) I do not have any code other than what I could pull together with the Macro recorder (which is generally not useful)
ActiveSheet.Shapes("Button 1").Select
...

I would like to execute a macros that will
1) Export the Monthly_Report worksheet and open a new Workbook for it
2) Copy and Paste Special Values the cells with formula arrays that reference the...

Catharine,
My bad. Yes it is scroll bars. I have attached a couple on the new attached workbook. I can't add labels for Start date and end date, but that is essentially what I am trying to do. I...

Is it possible to add Toggle Buttons (sliders that will change the date range) to the the attached workbook? ActiveX Toggle Buttons are not active even when I change the ActiveX settings under a...

Thanks, Steve. I'll put the package together on the databases forum to see what the optimal solution should be. I don't mind keeping them separate, but since the workbook will have to be updated on...

Steve,
You nailed it. This works great. I was hoping it could be done without necessarily created another table, but I can see how that is unavoidable.

The SUMPRODUCT formulas accommodate...

Steve,
I think this is close to what I was thinking. However, I am confused about the y-axis scaling (they should be whole numbers) and surprised that it is a flat trend over the total travel...

Hi Guys,
The attached export example has a listing of company travel records. I am trying to turning this into a number of different reports. I've transformed some of the columns provided in the...

Thanks, guys. I have noticed some discrepancies in the data, however, that prevent the exclusive use of the FIND(", (",A2) formula to do the parsing. Some records don't have a Continent value. How...

Thanks, Steve.

I'll see if the "sticky space" theory is true for the data exports this week. The example that I provided was just a mock-up of the data.

Amy

Steve,
This worked great. Thank you.

Amy

Hi guys,
I am getting a data export that has different data values that I would like to parse into separate cells.

Spain, (EUROPE), Madrid- Human Capital

Sometimes some of the data export...

Hi guys,
The attached workbook has some formulas (columns highlighted in blue). One is wrong (Column C). Another one is probably not the most optimal solution (Column I).

The unhighlighted...

Peter,
That worked brilliantly. I think my pieces are coming together and I will be able to move this solution to the MS Access platform.

You guys are great.

Amy

Peter/Steve,
Thank you. I integrated some changes with what you provided. I am trying to separate the city out of the parenthesis as another transformation step. I got close, but take a look at...

The attached workbook represents an export of data that I receive to compile personnel travel reporting. I actually receive two different exports both in MS Excel. The first export is a current...

Paul,
Thank you for the thorough explanation.

Amy

Paul,
Thanks. As I break this down, the SUBSTITUTE seems to be the primary formula that converts the text string to a number value that is recognized by MS Excel and renders it capable to be...

Paul,
That worked. I attached a file.

=--SUBSTITUTE(LEFT(A1,2)&" "&RIGHT(A1,LEN(A1)-FIND(" ",A1))&" "&TEXT(--MID(LEFT(A1,FIND(" ",A1)-1-(CODE(RIGHT(LEFT(A1,FIND("...

Here is the cell value that I have that I need to convert; however, there doesn't seem to be a date type that can match:

011341Z Oct 2010

That is actually October 1, 2010 1:41 PM.

I want it...

I added MIN(TrendDataFFP) to the TREND formula in Report_1 and Report_2 and it increased the y-value of the trend line data points such that the trendline would begin at or near the top of the first...

In the attached workbook, I have 3 tables and corresponding charts. I am interested in the TREND lines that I have created for each. Just when I thought I got the equation correct, I see that...