Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Replies
    0
    Views
    651

    Excel\VBA automation software

    I have been looking at the www.automateexcel.com to help me automate the creation of my coding. I am a poor code writer and a lot of these tools would improve my abilities, but I am curious if there...
  2. Replies
    2
    Views
    157

    Re: Table to Table

    So the cells in sheet 2 looks like this


    =IF('GEASWUG Contact List'!$B2="","",'GEASWUG Contact List'!$B2)

    That does work, but now my sort button fails error message: "Auto filter method of...
  3. Replies
    2
    Views
    157

    Table to Table

    I have two tables one on sht 1 and one on sht 2. Its nearly the same table, except sht 1 has detailed information about the people and sht 2 is just the first and last name.

    What I am trying to...
  4. Replies
    4
    Views
    117

    Re: Sort Error on open

    Perfect!

    Thank you that was it.
  5. Replies
    4
    Views
    117

    Re: Sort Error on open

    Here is the file.

    Put a "Yes" under the RSVP column header and over on the 2nd sheet click the green sort button.

    https://drive.google.com/open?id=1Grx1VSTdS98h8eGgsWc5J94gSXR8fPkE
  6. Replies
    4
    Views
    117

    Sort Error on open

    Recently I added the code below to do some auto sorting with a button. It works great and I don't recall any problems after I first made it (couple weeks ago). Now when I open the file, use the sort...
  7. Copy a Protected Worksheet to a new Workbook

    I have a protected Worksheet and when I am testing it out I have no problem copying the worksheet to a new workbook. When a user opens the same workbook\worksheet. When he clicks RMB on the tab to...
  8. Re: Copy several columns to a new workbook in a different order\location - VBA

    The new BOM has a maximum of 27 rows and the new quote only has 25 rows.

    Yeah, that was my first thought and I asked if I could move the Page 1 of 2, but they really wanted to keep it there.
    ...
  9. Re: Copy several columns to a new workbook in a different order\location - VBA

    https://drive.google.com/open?id=1Z8sQ4_UB89I0QNWj0qCiD6KrmkjvboT2

    My apologies. This is a different quote sheet that was given to me yesterday to use instead of the one I sent out to you.
  10. Re: Copy several columns to a new workbook in a different order\location - VBA

    See the attached image. https://drive.google.com/open?id=1_H31NgLXNYOCw6HU-iSXrQFsinIVp2S8

    You should see that line 48 shows page 1 of 2. The question arose if the values could skip a row and be...
  11. Re: Copy several columns to a new workbook in a different order\location - VBA

    Apologizes, but I do have a small question. Is there any way to skip a row when pasting the data into the quote workbook? I have another tab that I have to set this up on as well and there are more...
  12. Re: Copy several columns to a new workbook in a different order\location - VBA

    That worked perfectly!!!! :pray:

    After playing around with the code I finally figured out the proper field number and ranges that worked in the other workbooks... thank you sooo very much for...
  13. Re: Copy several columns to a new workbook in a different order\location - VBA

    Yes, I did. I placed the code into the sheets that I could not send to you. But the sheets I did send to you I used all the same cell locations. I did have to change the range to AQ7 and AL7 because...
  14. Re: Copy several columns to a new workbook in a different order\location - VBA

    That gives me an error:

    Run-Time Error '1004':
    AutoFilter Method of Range class failed

    Debug stops at this line:
    srcWS.Range("AL5:AQ24").AutoFilter Field:=6, Criteria1:="<>-"
  15. Re: Copy several columns to a new workbook in a different order\location - VBA

    I made some examples since I cannot send out the protected company files.

    BOM Example: FYI - This example is just value's not formula's like the original file has....
  16. Re: Copy several columns to a new workbook in a different order\location - VBA

    Also, the items that are being copied need to be pasted as values, because the BOM is a series of equation values. I did try and change your code but "Value" is not an option for Cell type.

    When I...
  17. Re: Copy several columns to a new workbook in a different order\location - VBA

    Thanks for your reply. That sorta worked... and I don't know how else to explain it at the moment.

    Here is the BOM:...
  18. Copy several columns to a new workbook in a different order\location - VBA

    I have been searching most of this morning looking for a solution. I have not seen anything like what I am wanting to do.

    I have a Bill Of Materials with a part number, Description, Cost, and...
  19. Replies
    7
    Views
    215

    Re: Copy a row per the QTY Value

    That works perfectly! Thanks so much, I truly appreciate it.

    May God Bless you!
    SB
  20. Replies
    7
    Views
    215

    Re: Copy a row per the QTY Value

    It's not written very well, but it works except for this part.


    Private Sub Add_Dim_Click()

    dst = DSub.Value
    n = Nominal.Value
    u = Units
    q = QTY
  21. Replies
    7
    Views
    215

    Re: Copy a row per the QTY Value

    Thanks that's closer than what I had, but I keep getting a Runtime error 1004.

    I guess I should have pointed out is that the row is dynamic and changing per each dimension that is added. So it's...
  22. Replies
    7
    Views
    215

    Copy a row per the QTY Value

    So I am trying to do this code at the end of the "Button click". If the QTY.value is > 1 then I need it to copy the data that has already been inputted in the spreadsheet = to the X QTY.

    If...
  23. Replies
    9
    Views
    276

    Re: VBA - Skipping a Value

    OK I re-read your reply again and you are right it is not a property. I changed the "." to "=" and that fixed it. - Thanks!
  24. Replies
    9
    Views
    276

    Re: VBA - Skipping a Value

    I am not sure how it wouldn't? The problem I have is the Bilateral tolerance is different than the other 2 options. The spreadsheet is not designed to use a bilateral tolerance. So I am writing the...
  25. Replies
    9
    Views
    276

    Re: VBA - Skipping a Value

    I am no professional coder, just enough to be dangerous and eventually get it done ;).

    Should I put another Elseif and disable the textboxes that are not active?

    it stops @ ".Range("P" &...
Results 1 to 25 of 35
Page 1 of 2 1 2