Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.11 seconds.

  1. Re: Another email vba question, modify .SendMail Range to include Sheet name!

    Andrew, I think I may have stumbled across the solution there! :rofl:

    After swapping and changing things about with the additional code trying to find where to put it, I actually think I've done...
  2. Re: Another email vba question, modify .SendMail Range to include Sheet name!

    I have found this on Ron's site...

    Tips for the SendMail code examples

    Send to all E-mail addresses in a range.



    Dim MyArr As Variant
    MyArr =...
  3. Re: Another email vba question, modify .SendMail Range to include Sheet name!

    I'm sorry Andrew, but I do indeed have a worksheet named Contacts.

    I have just changed the sheet name that is to be copied and emailed to Contacts and successfully sent and received an email.

    ...
  4. Re: Another email vba question, modify .SendMail Range to include Sheet name!

    Hi Andrew, thanks for the reply and code.

    Sorry, that isn't working for me, is it because this part of the code will also need modifying?



    LR = Range("Z" & Rows.Count).End(xlUp).Row


    I...
  5. Another email vba question, modify .SendMail Range to include Sheet name!

    Hi one and all.

    I am using one of Ron's codes to send emails with an attached worksheet, all working fine.
    Due to some non Excel related issues, I must now have the email contact changed to an...
  6. Replies
    7
    Views
    1,217

    Re: Random Non-repeating Names

    Hi Krunk

    I'm sorry, but I'm unable to help you with a solution to your problem, but please see if this works for you.

    Krunk - Download - 4shared
  7. Re: VBA copy numerous cells to new sheet based on criteria

    EXCELLENT.
    Thank you so much Alan, I really do appreciate your time, patience and work with this problmem.



    For NewDataRow = 2 To Worksheets("TypicalData").Cells(Rows.Count, 1).End(xlUp).Row
    ...
  8. Re: VBA copy numerous cells to new sheet based on criteria

    Hi Alan,

    That will be a yes to both questions.

    Ak
  9. Re: VBA copy numerous cells to new sheet based on criteria

    Hi Alan.

    I hope this is ok....

    <b>TypicalData</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff;...
  10. Re: VBA copy numerous cells to new sheet based on criteria

    Hi Alan, WOW.
    Thank you so very much for all the hard work and time you have put into trying to resolve this for me, it is greatly appreciated.

    I have tested and tested the code in your Workbook...
  11. Re: VBA copy numerous cells to new sheet based on criteria

    Hi Alan,

    I'm just about out of time here, but YES, your sample data looks spot on! :)

    Thanks for taking a look at this for me, much appreciated.

    Ak
  12. Re: VBA copy numerous cells to new sheet based on criteria

    Hi G,

    Yes, that works, I changed this...

    Sht2.Range("A1")

    To

    Sht2.Range("A2")
  13. Re: VBA copy numerous cells to new sheet based on criteria

    *Expected Results*

    <b>DataHistory</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; ...
  14. Re: VBA copy numerous cells to new sheet based on criteria

    *Sample Data*
    <b>19-08-14</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; ...
  15. Re: VBA copy numerous cells to new sheet based on criteria

    Hi G, thanks for the reply.

    I'm sorry to report that your code doesn't work as requested.
    It somehow only copies over Rows 25:26 (These DO NOT have a number in Column AE), or it copies the data...
  16. VBA copy numerous cells to new sheet based on criteria

    Good day MrExcelers!

    I have been given a Workbook to "tidy up", it's been a long time and I'm seriously struggling, so here I am!

    I have a Worksheet that I CANNOT alter the layout of and that...
  17. Re: How can I create a dynamic view (filter) of a worksheet?

    Hi vladutnea

    Does this help?....

    Sample data....

    <b>WS1</b><br /><br /><table border="0" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt;...
  18. Re: VLookup and Countif? Might be the wrong formula options for what I am trying to do... :)

    Hi,

    I'm pleased it worked for you and thanks for the feedback. :biggrin:

    Ak
  19. Replies
    3
    Views
    202

    Re: Sheduling with lunch break

    Hi,

    You cannot attach a file, but you can post sample data using one of the links in my signature.

    Ak
  20. Replies
    1
    Views
    174

    Re: Auto populate list

    Hi jaycee,

    It sounds like you need a Dynamic Data Validation List....

    Excel Data Validation - Add New Items

    Excel Magic Trick 549: Dynamic Data Validation List Drop-Down OFFSET or Table...
  21. Replies
    3
    Views
    202

    Re: Sheduling with lunch break

    Hi and welcome to MrExcel.

    I think that you need to give a bit more information here.
    Who decides which lunch period someone has?
    Does this change daily?
    If it's you, then perhaps this simple...
  22. Re: How to check part of a string from a field and enter a corresponding value in another field

    Hi,

    Without seeing an example of your layout and the formula, all I can suggest is that the Item is not listed in column E (or whichever column you are using) or that it is spelt differently in...
  23. Replies
    6
    Views
    156

    Re: Extract information from a cell

    Hi,

    Can you post the formula that you are using?

    Also, which version of Excel are you using?

    Ak
  24. Replies
    2
    Views
    94

    Re: Conditional Format by row?

    Hi,

    What Condtional Formatting "rule" or formula are you using?
    You need to be careful where you place your $ within the formula, or if you should be using them at all!!

    Ak
  25. Replies
    6
    Views
    156

    Re: Extract information from a cell

    Hi shoneh and welcome to MrExcel.

    * This is a formula solution.

    Based on your sample data are these the results you would expect for Barry?..

    <b>Sheet3</b><br /><br /><table border="0"...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4