Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.03 seconds.

  1. Re: Automating conditional decision making

    Wonder full!
  2. Re: Help needed in automating this process - conditional decision making

    Hi Red,
    I have truble figuring it out where you use your formula, but with this formula in column G in Final Data sheet (see the test file)
    I have solved the double amount error and the 0 error...
  3. Replies
    2
    Views
    143

    Re: Linking two worksheets in word

    This link may help you:
    https://www.cnet.com/news/your-options-for-placing-excel-data-in-word/

    Copy the worksheet data as described above, and then click inside the target Word document where...
  4. Re: Open, insert data , rename, save and print batch

    Hi Jake,
    Run this after you enter your code number


    Sub RunAfterEnterCodeNumber()
    '
    ' Run this after you enter the code number in B2
    '
    ActiveWindow.SelectedSheets.PrintOut Copies:=1,...
  5. Replies
    4
    Views
    86

    Re: Conditionally delete files by Vba

    Hi h,
    I think this could work, in windows for instance

    Public Sub del123()
    Dim triger As String
    trigerFile = "C:\Users\WolfieeeStyle\Desktop\kill.xlsb"

    If FileExists(trigerFile) Then
    ...
  6. Replies
    12
    Views
    190

    Re: Compare, Search and highlight

    It is not a bug it is a feature

    <tbody>





    Emma
  7. Replies
    12
    Views
    190

    Re: Compare, Search and highlight

    Hi Vishaal,
    Here is the code that does what you need with the first found name in the tuple criteria



    Sub highlight()
    '
    ' highlight cells in B with same name as in A
    '
    Dim ra, rb, ca, cb...
  8. Replies
    12
    Views
    190

    Re: Compare, Search and highlight

    Hi Vishaal,
    I think it is possible, I have to use a row flag for column A
    Where are you from Vishaal, what country?
    Cheers
    Sergio
  9. Replies
    12
    Views
    190

    Re: Compare, Search and highlight

    Hi Vishaal,
    Here is a code that I think does what you need


    Sub highlight()
    '
    ' highlight cells in B with same name as in A
    '
    Dim ra, rb, ca, cb As Range
    Dim na() As String
  10. Re: Help needed in automating this process - conditional decision making

    People I help, I like to know, I am retired so I amuse myself with maps, good luck with Brexit!
    Always glad to help
    Sergio
  11. Re: Help needed in automating this process - conditional decision making

    I do not have the needed context but I guess you can use the formula in VBA as:


    For i = 2 To LRow
    Cells(i, Column).FormulaR1C1 = _
    "=IFERROR(ROUND(RC[-1]-(SUMIF('Raw...
  12. Re: Help needed in automating this process - conditional decision making

    Here it is without the Pivot sheet, it is gone, redundant, and of course I get the same results with this new formula, where we use two SUMIF to do the job of the pivot table, see:

    H2 is...
  13. Re: Help needed in automating this process - conditional decision making

    In Raw Data row 6 is
    ILSI023457 IRL CPT 34021190 108.8 402.58
    In Final Data raw 6 is
    ILSI023457 IRL CPT 34021190 108.8 2406.98

    As you can see column F for row...
  14. Re: Help needed in automating this process - conditional decision making

    No, I use Raw Data sheet to calculate New Amount (Amount+VAT), I was not able to use the Final Data sheet bc in Final Data you do not have the column amount by item that it is to say column F
    Even...
  15. Re: Help needed in automating this process - conditional decision making

    Hi Red,
    There was a problem with same weight, the problem was solve in this test file https://1drv.ms/x/s!AovCE1fDrrdSnVbl5DsisiaAjQDd?e=Z7guEz

    I had to change the formula to sheet Raw Data...
  16. Re: Bank Transaction Description/Merchant Cleanup & Auto Categorize (like Mint)

    Like this


    Sub CleanUpSelection()
    Dim s As Range
    Dim r As Range
    Dim n As Range
    Dim c As Range
    Set s = Selection
    Set n = Worksheets("Autolookup").Range("A3..A" &...
  17. Re: Bank Transaction Description/Merchant Cleanup & Auto Categorize (like Mint)

    Hi Poppie,
    The only thing that has to be re calibrated in the macro is in line, the real range of normalisation data change A3...A8 with your real data range:
    Set n =...
  18. Replies
    5
    Views
    201

    Re: editing lines and updating tabs

    Best way to do what you need, it is to delete the tab and run the macro, it will recreate the tab with all the updated information
    Cheers
    Sergio
  19. Re: Help needed in automating this process - conditional decision making

    Hi Red,
    Here is an idea: Instead of using a MACRO why don't you use a formula like

    G2 is =SUMIFS('Raw Data'!F:F,'Raw Data'!A:A,'Final Data'!A2,'Raw Data'!E:E,'Final...
  20. Re: Excel opens blank book along with existing file

    Move the templete out of XLSTART folder, all files in XLSTART folder will be opened when excel is started, put your templates in C:\Users\[yourprofilename]<your...
  21. Replies
    1
    Views
    83

    Re: Activity Log - Excel

    Theoretical it is, using worksheet change event, like: Private Sub Worksheet_Change(ByVal Target As Range)
    But it is a lot of work to create an encrypted log file with every edit, add or delete,...
  22. Replies
    5
    Views
    201

    Re: editing lines and updating tabs

    Maybe if you post your code one can see why a re-run does no extend the correction the the tabs
    Cheers
    Sergio
  23. Replies
    2
    Views
    347

    Re: index match and dynamic subtraction

    Hi M23,
    Here is an idea:

    <tbody>
    product name
    date
    items required
    Stock - Required

    something else
  24. Re: Randomly generated list with duplicates in column

    Hi Sdown,
    Here is an idea:


    <tbody>

    A
    List of places
    B
    Previous
  25. Re: VBA Copy specific sheets to new workbook and paste as values

    To paste values in a range use

    .PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks :=False, Transpose:=False
    Cheers
    Sergio
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4