Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.05 seconds.

  1. Replies
    3
    Views
    74

    Re: Formula mod needed for age, year, DOB

    Of course. Let me know any questions you have and I'll review it with pleasure.
  2. Re: Reference/copy data from another workbook based on another cell's value

    Try this



    Sub copy_data()
    Dim w1 As Workbook, w2 As Workbook
    Dim sh1 As Worksheet, sh2 As Worksheet

    Application.ScreenUpdating = False
    Set w1 = ThisWorkbook
  3. Replies
    19
    Views
    170

    Re: Remove Columns

    You just had to put a new column width to all the columns, that will show all the columns.
    As I commented from post #3


    But hey, the important thing is that you already have all your columns.
    ...
  4. Re: Application ontime running randomly !!

    Try putting the instruction at the end.



    Sub Calculator()
    Dim i, val1, val2, val3, val4, Checker, Checker1 As Double

    i = Worksheets("Sheet2").Range("J1")
    'Paste timestamps...
  5. Re: Combining Multiple Books and removing some rows

    Try this



    Sub mergeFiles()
    'Merges all files in a folder to a main file.
    'use consolidation function to combine sheets.
    'Define variables:
    Dim numberOfFilesChosen, i As...
  6. Replies
    19
    Views
    170

    Re: Remove Columns

    You needed to change the width of columns as I mentioned in post#3




    Select all the cells, click on any column, select from popup menu Column Witdh, write 10, press Ok.
  7. Re: Creating Formula to help sort values from one table to another

    Try this


    <table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col...
  8. Replies
    4
    Views
    30

    Re: Find next scheduled date in range

    I'm glad to help you. Thanks for the feedback.

    I love the forum too.
  9. Re: ASCII code behaviour and special characters in Excel

    Check here some proposals.
    https://www.mrexcel.com/forum/excel-questions/1097028-need-help-replacing-invalid-characters-cell.html
  10. Replies
    19
    Views
    267

    Re: How to extract specific data from a cell

    I'm glad to help you. I appreciate your kind comments.
  11. Replies
    4
    Views
    30

    Re: Find next scheduled date in range

    It can also be:

    {=IFERROR(SMALL(IF($C$5:$NJ$5>TODAY(),IF(ISNUMBER(C2:V2),$C$5:$NJ$5)),1),MAX($C$5:$NJ$5))}
  12. Replies
    19
    Views
    170

    Re: Remove Columns

    You could upload a copy of your file to a free site such www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook...
  13. Re: VBA Save As and Save Conditional Formatting

    Try



    Sub save_copy()
    ThisWorkbook.savecopyas "newfile.xlsm"
    End Sub
  14. Replies
    19
    Views
    170

    Re: Remove Columns

    Select all the cells, select any column, for examlple column "A" from pop up menu select show.
  15. Re: Hyperlink retured through a VLOOUP gives error

    Try this

    =HYPERLINK("#" & VLOOKUP(C7,Tables!E2:G10,2,0))
  16. Replies
    1
    Views
    45

    Re: Formula question

    You can block the cells that you do not want to modify, such as the cells that have formula and then protect the sheet.
    If you want to write something about a locked cell and with the protected...
  17. Re: VBA Code to replace "0"s withing Column "I" to value in column "M"

    I'm glad to help you. Thanks for the feedback.
  18. Replies
    19
    Views
    170

    Re: Remove Columns

    You tried the way to show?
  19. Re: Formula Help Needed - "If Cell Contains Text String, then run this calculation =MAX(((G14-30)*0.5),0)"

    You're right, it should be only a sign

    =MAX((G14-IF(C14="storage",30,0))*0.5,0)
  20. Re: Creating a payroll weekley summary sheet

    Use this

    Change data in red with your information.



    Sub weekley_summary()
    Dim days As Variant, sh2 As Worksheet, sh1 As Worksheet, d As Variant
    Dim f As Range, cols As Variant, r...
  21. Replies
    10
    Views
    6,288

    Re: Rename Duplicate Cells

    Try this
    Your data in columns C, result in column D



    Sub Count_duplicate()
    Dim i As Long
    For i = 1 To Range("C" & Rows.Count).End(xlUp).Row
    Cells(i, "D").Value =...
  22. Re: VBA Code to replace "0"s withing Column "I" to value in column "M"

    Try this



    Sub Change_0()
    For Each c In Range("I3", Range("I" & Rows.Count).End(xlUp))
    If c.Value = 0 Then c.Value = c.Offset(0, 4).Value
    Next
    End Sub
  23. Replies
    19
    Views
    170

    Re: Remove Columns

    Maybe you hide the columns, then select all the cells, select a column and select show.
    Maybe you changed the width of columns. Select all the cells, change the column width to 10.
  24. Replies
    2
    Views
    82

    Re: TEXT IN A PIVOT TABLE's VALUE FIELD

    You can add an auxiliary column to get the value of column B.
    Use the following formula for that.
    In the pivot table, add the auxiliary column value area.

    <table border="1" cellspacing="0" ...
  25. Re: Change cell value and print via range list

    Try this to print All



    Sub Printform_All()
    Dim c As Range
    Sheets("directory").Select
    Sheets("accessory form").Visible = True
    Sheets("accessory form").Select
    For Each c...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4