Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Thread: Xlookup

    by Unicode
    Replies
    3
    Views
    146

    Re: Xlookup

    Thank you for the follow up on my question.
  2. Thread: Xlookup

    by Unicode
    Replies
    3
    Views
    146

    Xlookup

    Hello, Would you know when would all Excel, Office 365 users will be able to utilize the following formula: "XLOOKUP"
  3. Replies
    10
    Views
    1,528

    Re: Converting Year/Month to correct date

    Custom format worked just fine. Thank you!
  4. Replies
    10
    Views
    1,528

    Re: Converting Year/Month to correct date

    I just tried again, Text to Columns, and I get:
    Jan-19
    2/1
    3/1
    4/1
    5/1
    6/1
    7/1
    8/1
    9/1
  5. Replies
    10
    Views
    1,528

    Re: Converting Year/Month to correct date

    I tried =LEN(B3), I get 1/7
  6. Replies
    10
    Views
    1,528

    Re: Converting Year/Month to correct date

    I also tried: =YEAR(B3), and, I get #VALUE ! error
  7. Replies
    10
    Views
    1,528

    Re: Converting Year/Month to correct date

    Yes, i did. I am currently utilizing MS Excel 2016
  8. Replies
    10
    Views
    1,528

    Converting Year/Month to correct date

    Would you know what would be the correct formula for converting year/month to correct date. Example: All rows display 2019/01, 2019/02, 2019/03... etc.

    What I really need is to have the date...
  9. Replies
    0
    Views
    120

    Using the Range Current Region

    Would you know how I can remove the range " Range("A9:A20" & lastrowcount).Copy " and have the code continue reading down the rows without copying the next block of data, specially if Ranges will...
  10. Re: Find the Last Row, Column, or Cell on a Sheet then

    How about I do this with the following [code]:

    Sub setname()
    ActiveWorkbook.Names.Add Name:="Last12", RefersTo:= _
    "=OFFSET(ThisWorks!$a$1,COUNTA(ThisWorks!$a:$a)-12,0,12,1)"
    End Sub
  11. Replies
    3
    Views
    279

    Re: Compile error: Variable not defined??

    Why would this error on the following code line: For i = 1
  12. Find the Last Row, Column, or Cell on a Sheet then

    Hello Everyone, I am not very in detail with macro VBA coding, I have compiled the following code. My project is set on a flat file, vertical format across range (A:D) there is only 4 columns with...
  13. Replies
    3
    Views
    279

    Compile error: Variable not defined??

    Dear All, I run the following code script, then I get an error: "Variable not Defined. What could be the issue, is there an explanation to what is the correct variable not set in the script code?
    ...
  14. Re: Table of Content: Count all pages per TAB, continue on next TAB with page number

    Found the Hyperlink removal code listed below. ActiveSheet.Hyperlinks.Delete
  15. Table of Content: Count all pages per TAB, continue on next TAB with page number

    I have a workbook with 40 sheets, I have created query that should provide a Table of Content. What I need is the query to provide the page in sequence with the next TAB providing the next PAGE...
  16. Replies
    9
    Views
    338

    Re: Text to column issue?

    I want to run the Text to Columns in a macro every time the source file is updated.
  17. Replies
    9
    Views
    338

    Re: Text to column issue?

    The only way DATE with AMOUNT displays correctly on SHEET2 is by selecting each column individually on Sheet2 column "C", then after going into excel choosing DATA TAB -> "Text to Column", then DATES...
  18. Replies
    9
    Views
    338

    Re: Text to column issue?

    Here it goes, I would like sheet2 to be able to display data "Dates" on "C2" and work properly with formulas on Sheet2 Column "E", and Dollar "$" sign to appear on D2, from data Sheet1. Currently...
  19. Replies
    9
    Views
    338

    Re: Text to column issue?

    Here it goes, I would like sheet2 to be able to display data "Dates" on "C2" and work properly with formulas on Sheet2 Column "E", and Dollar "$" sign to appear on D2, from data Sheet1.


    ...
  20. Replies
    9
    Views
    338

    Re: Text to column issue?

    My VBA Script:


    Sub CopyPasteSheet2DELINQUENT()




    Dim lr As Long
    Dim i As Long
  21. Replies
    9
    Views
    338

    Re: Text to column issue?

    The following would be from Sheet1:







    A
    B
  22. Replies
    9
    Views
    338

    Re: Text to column issue?

    Hey there. Hello

    My sheet one text to column looks like this, then these dates with numbers are landing on SHEET2.


    ActiveWindow.SmallScroll Down:=11


    Columns("J:J").Select
    ...
  23. Replies
    9
    Views
    338

    Text to column issue?

    My VBA script works just okay, when I run macro script I have DATE on column "C", TOTALS on Column "D", Datasource lands on SHEET2, however, Date Column and Totals on column D SHEET2 do not list,...
  24. Re: “Dates” set as General, should be set to DATES

    There is no way for me to change Sheet1 to "Date".

    The formulas are only being used with right side columns on Sheet2, such as the following:


    Column E Column F Column G ...
  25. Re: “Dates” set as General, should be set to DATES

    I just noticed that Sheet1 is set to "General", after copy paste into Sheet2, it remains set as General not Date.
Results 1 to 25 of 58
Page 1 of 3 1 2 3