Search:

Type: Posts; User: alansidman

Page 1 of 6 1 2 3 4

Search: Search took 0.00 seconds.

  1. Replies
    2
    Views
    1,013

    Look at this link on conditional formatting and...

    Look at this link on conditional formatting and dates

    https://www.ablebits.com/office-addins-blog/2014/06/17/excel-conditional-formatting-dates/
  2. Try this aircode: Option Explicit Sub...

    Try this aircode:


    Option Explicit

    Sub ams()
    Dim i As Long, lr As Long
    lr = Range("A" & Rows.Count).End(xlUp).Row

    Application.ScreenUpdating = False
  3. Replies
    3
    Views
    1,195

    In CE11 type...

    In CE11 type =LEN(BW11)+LEN(BY11)+LEN(CA11)+LEN(CC11) and copy down
  4. Replies
    3
    Views
    1,195

    Suggest you upload a sample workbook with the...

    Suggest you upload a sample workbook with the expected results manually shown.
  5. How about this: Sub LastSaved() Range("A1")...

    How about this:


    Sub LastSaved()
    Range("A1") = ThisWorkbook.BuiltinDocumentProperties("Last Save Time")
    End Sub
    Change the range appropriately
  6. On the Excel Ribbon, Click on the Data Tab. ...

    On the Excel Ribbon, Click on the Data Tab. Select Data Validation. Select Data Validation again.

    In the allow box, select text length
    In the data box, select less than
    In the maximum box,...
  7. Replies
    3
    Views
    1,289

    crossposted: droplist...

    crossposted: droplist
  8. Replies
    3
    Views
    1,289

    1. Created a new Sheet3 2. In cells A1:A4...

    1. Created a new Sheet3
    2. In cells A1:A4 entered list of four schools
    3. In Name Manager, defined list with Name "List"
    4. In Data Validation, changed look up to the defined "List"

    See...
  9. For starters, you have merged cells. VBA does...

    For starters, you have merged cells. VBA does not like and will not usually work with merged cells. You will need to redesign your workbook so that there are no merged cells. Additionally, in your...
  10. In the reply window, click on the Go Advanced...

    In the reply window, click on the Go Advanced button. Look for the manage attachments button and follow the wizard to attach your workbook onto this forum.
  11. Replies
    3
    Views
    3,321

    With one table, it sounds like you may need to...

    With one table, it sounds like you may need to normalize your date into several tables.

    Look at this link to understand what needs to happen. Once you have normalized data, it will be easier to...
  12. Replies
    3
    Views
    3,321

    It may be possible by joining the two queries...

    It may be possible by joining the two queries into a new query that becomes the record source for your report. Without more detailed information from you that is the best i can do. Is the...
  13. Replies
    1
    Views
    2,462

    crosspost: Display date as MM/DD in reports...

    crosspost: Display date as MM/DD in reports

    Look at this link: http://www.excelfox.com/forum/f25/message-to-cross-posters-1172/#post5326
  14. Replies
    3
    Views
    1,155

    Your jpg is unreadable. Too small to read. ...

    Your jpg is unreadable. Too small to read. Suggest you upload as an excel file.
  15. Suggest you explain your issue in more detail. ...

    Suggest you explain your issue in more detail. Not enough information to offer a solution.
  16. Replies
    1
    Views
    866

    Difficult to analyze the issue without seeing...

    Difficult to analyze the issue without seeing your spreadsheet. Tough to visualize what you have. Suggest you upload your spreadsheet with a detailed explanation of what you are attempting and what...
  17. Images are pretty much useless to help solve...

    Images are pretty much useless to help solve issues. Upload sample worksheets with enough data to allow analysis and determine a suitable solution.
  18. this will probably require some VBA. Suggest you...

    this will probably require some VBA. Suggest you post a sample worksheet so that members can provide you with specific code to meet your needs.
  19. Try this: Option Explicit Sub NewDelete()...

    Try this:


    Option Explicit

    Sub NewDelete()
    Dim W1Startdate As Date
    W1Startdate = InputBox("Please Enter the Start Data in DD/MM/YYYY format")
    Dim lr As Long
    lr = Range("G"...
  20. Try this: Sub MYFILTER() Dim W1Startdate As...

    Try this:


    Sub MYFILTER()
    Dim W1Startdate As Date
    W1Startdate = InputBox("Please Enter the Start Data in DD/MM/YYYY format")
    range("A2:T" & range("A1").End(xlDown).Row).AutoFilter Field:=7,...
  21. Replies
    8
    Views
    1,814

    In C1, type =RANDBETWEEN(1,31) in D1, type...

    In C1, type =RANDBETWEEN(1,31)
    in D1, type =VLOOKUP(C1,$A$1:$B$31,2,FALSE)
  22. Howard; Please read this link: ...

    Howard;

    Please read this link:

    http://www.excelfox.com/forum/f25/message-to-cross-posters-1172/#post5326
  23. Replies
    14
    Views
    3,601

    Tested. Worked without issue. Had to change the...

    Tested. Worked without issue. Had to change the sheet name to reflect my sheet name, but other than that, I used the code provided without any problems. If you would like further help, suggest you...
  24. Replies
    14
    Views
    3,601

    try this: Option Explicit Sub bold() Dim...

    try this:


    Option Explicit

    Sub bold()
    Dim lr As Long
    lr = Range("A" & Rows.Count).End(xlUp).Row
    Dim c As Range
    Dim rng As Range
  25. Replies
    1
    Views
    830

    I have no experience with Java, and I suspect...

    I have no experience with Java, and I suspect that the issue is with Java as you have the dates formatted correctly in Excel. I did a quick google search and found this link which may be helpful
    ...
Results 1 to 25 of 126
Page 1 of 6 1 2 3 4