Search:

Type: Posts; User: AmyN; Keyword(s):

Page 1 of 9 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    0
    Views
    552

    Start-to-Finish Dependency

    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...
  2. Rory, Thank you for the prompt response. So you...

    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...
  3. Marker Type Change of Data Series for Scatter Plot Data Series

    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...
  4. Replies
    2
    Views
    1,319

    Gary, 1) I do not have any code other than what...

    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
    ...
  5. Replies
    2
    Views
    1,319

    Command Button Paste Values & Worksheet Export

    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...
  6. Thread: Toggle Button

    by AmyN
    Replies
    4
    Views
    648

    Catharine, My bad. Yes it is scroll bars. I...

    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...
  7. Thread: Toggle Button

    by AmyN
    Replies
    4
    Views
    648

    Is it possible to add Toggle Buttons (sliders...

    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...
  8. Replies
    6
    Views
    879

    Thanks, Steve. I'll put the package together on...

    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...
  9. Replies
    6
    Views
    879

    Steve, You nailed it. This works great. I was...

    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...
  10. Replies
    6
    Views
    879

    Steve, I think this is close to what I was...

    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...
  11. Replies
    6
    Views
    879

    Hi Guys, The attached export example has a...

    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...
  12. Replies
    5
    Views
    544

    Thanks, guys. I have noticed some discrepancies...

    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...
  13. Replies
    5
    Views
    544

    Thanks, Steve. I'll see if the "sticky...

    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
  14. Replies
    2
    Views
    517

    Steve, This worked great. Thank you. Amy

    Steve,
    This worked great. Thank you.

    Amy
  15. Replies
    5
    Views
    544

    Hi guys, I am getting a data export that has...

    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...
  16. Replies
    2
    Views
    517

    Hi guys, The attached workbook has some formulas...

    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...
  17. Replies
    6
    Views
    670

    Peter, That worked brilliantly. I think my...

    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
  18. Replies
    6
    Views
    670

    Peter/Steve, Thank you. I integrated some...

    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...
  19. Replies
    6
    Views
    670

    The attached workbook represents an export of...

    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...
  20. Replies
    8
    Views
    996

    Paul, Thank you for the thorough explanation. ...

    Paul,
    Thank you for the thorough explanation.

    Amy
  21. Replies
    8
    Views
    996

    Paul, Thanks. As I break this down, the...

    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...
  22. Replies
    8
    Views
    996

    Paul, That worked. I attached a file. ...

    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("...
  23. Replies
    8
    Views
    996

    Here is the cell value that I have that I need to...

    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...
  24. Thread: Trendline

    by AmyN
    Replies
    3
    Views
    465

    I added MIN(TrendDataFFP) to the TREND formula in...

    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...
  25. Thread: Trendline

    by AmyN
    Replies
    3
    Views
    465

    In the attached workbook, I have 3 tables and...

    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...
Results 1 to 25 of 220
Page 1 of 9 1 2 3 4