Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Thread: Missing Member

    by lhaynes
    Replies
    18
    Views
    3,554

    I will second the thanks and well wishes for...

    I will second the thanks and well wishes for Hans. Over the years my role has changed and along with it, the need to be as hands on as I needed to be in the past. I happened to have an Excel need...
  2. Replies
    2
    Views
    400

    Controls from the Forms toolbar such as radio...

    Controls from the Forms toolbar such as radio buttons and check boxes can be linked to a cell (right-click the control and select Format Control from the popup menu). When the user clicks a control,...
  3. Replies
    2
    Views
    400

    I'm looking for some guidance on a reporting...

    I'm looking for some guidance on a reporting project that I have. I have an existing Word doc that I would ultimately like to turn into a (possibly Excel) form. This form will be sent out to...
  4. Hans, I can't tell you how many hours that I...

    Hans,

    I can't tell you how many hours that I wasted trying to figure that out. I thought that I was a savy Excel user but I definitely have alot to learn around graphing. Thanks again for your...
  5. Hans, I'm hoping that you can help. I tried...

    Hans,

    I'm hoping that you can help. I tried to add additional critieria to the example you provided and I can get all the data to map correctly except for the Y axis lables. If I hide the rows...
  6. Hans, Thank you for the reply. It's exactly...

    Hans,

    Thank you for the reply. It's exactly what I was looking for and I have to admit that at first look, I don't understand it but I will read the provided link. You're a life saver.


    ...
  7. [attachment=83482:Combo_gr...tckdclmn.xls] I'm...

    [attachment=83482:Combo_gr...tckdclmn.xls]

    I'm trying to create a combination graph with the attached file. I would like to show the Q2 and Q3 data as a clustered column and any future data as...
  8. Replies
    18
    Views
    926

    Re: Test for condition (Office)

    Sam,

    Thank you so much for working with me thru this. The solution you provided will definitely put me on the right track and I appreciate your efforts!!
  9. Replies
    18
    Views
    926

    Re: Test for condition (Office)

    Here is the after file. Hopefully this will make more sense. Please look in the project specific sheets to see the offsets that I need created. Sheet 1 has the original information and I've...
  10. Replies
    18
    Views
    926

    Re: Test for condition (Office)

    This is the first of two emails. This email will contain a workbook with the before information.

    Steps:
    1) The user will drop data into this template beginning in cell A1. This data will be...
  11. Replies
    18
    Views
    926

    Re: Test for condition (Office)

    Is the DesiredOutput sheet a new sheet or a mod of Sheet1 or just an indication of what the nnXXXXX sheets look like?

    The DesiredOutput sheet is just that. This is what I would like the output...
  12. Replies
    18
    Views
    926

    Re: Test for condition (Office)

    Sam,

    I'm sorry that what I provided wasn't clear. I will try again. I've attached a wksheet that has a macro button presently attached to a script called CreateJE. This script collects...
  13. Replies
    18
    Views
    926

    Re: Test for condition (Office)

    Sam,

    I want to thank you for your considerable efforts on my behalf. I should have provided you more information based on the questions that you had yesterday. I've attached my working script so...
  14. Replies
    18
    Views
    926

    Re: Test for condition (Office)

    The end user will have a sheet with anywhere from 200 to 500 lines all differentiated by various projects. I need the script to be flexible so that it can test for various conditions in a loop. For...
  15. Replies
    18
    Views
    926

    Re: Test for condition (Office)

    I'm trying to create the offset of a one-sided journal entry (Accounting) where if I have a certain condition (Project = 44XXXXX) then the script does the following:

    1) Copy the information from...
  16. Replies
    18
    Views
    926

    Test for condition (Office)

    I have a spreadsheet where I need to test for certain conditions and based on the condition returned create an offsetting line. For example in the attached spreadsheet I would like to test for...
  17. Re: Can't Open file with declared variable (Windows XP)

    Thanks Hans!!
  18. Re: Can't Open file with declared variable (Windows XP)

    Hans,

    Open strPath & "" & s For Input As #1

    Once the script has loaded the statement above I want to select a sheet called "DATA", copy a range of cells and paste that into my master file. ...
  19. Re: Can't Open file with declared variable (Windows XP)

    Thank you Hans!! I've been looking at this to long. /forums/images/smilies/sad.gif
  20. Can't Open file with declared variable (Windows XP)

    Can anyone tell me why I'm getting a type mismatch on the the following line:

    Open "strPath" "& s" For Input As #1

    The code is below. Thanks!!

    Sub Opentest()

    Dim strFileName As String...
  21. Replies
    9
    Views
    2,534

    Re: Copy Down Excel Rows (VB/VBA)

    Hans,

    Thank you so much. With a little tweaking this code is working perfectly for me. It's amazing how close you can be yet the answer still escapes you. The step argument is a powerful...
  22. Replies
    9
    Views
    2,534

    Re: Copy Down Excel Rows (VB/VBA)

    I found this post and for the most part it's similar to my situation. The main difference is that my data is populated by a process that works from bottom to top instead of top to bottom as the...
  23. Replies
    10
    Views
    643

    Re: Update value on change (Excel XP)

    Steve & Hans,

    I decided to utilize Hans suggestions because I knew the way the code was working and more importantly the approach I was following, I was on the last mile. Hans, your last...
  24. Replies
    10
    Views
    643

    Re: Update value on change (Excel XP)

    Using the Worksheet_Calculate event was able to kick off my code but then it went into a horrible loop as each time the code ran it would trigger the event all over again. Any thoughts?
  25. Replies
    10
    Views
    643

    Re: Update value on change (Excel XP)

    I have a similar situation to the one posed in this thread but the only difference is that I need to kick of my code if someone does something as simple as sorting the data with no data entry change....
Results 1 to 25 of 58
Page 1 of 3 1 2 3