Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.27 seconds.

  1. Re: VBA to pull data from Multiple Worksheets into One

    Can you post a screen shot of what your data looks like? Section B at this link has instructions on how to post a screen shot: https://www.mrexcel.com/forum/board-...forum-use.html Alternately, you...
  2. Replies
    3
    Views
    69

    Re: Hide Another Workbook Worksheet

    Assign this macro to your button.
    Sub HideSheet()
    Application.ScreenUpdating = False
    Dim wbOpen As Workbook
    Set wbOpen = Workbooks.Open("D:\temp\action.xlsm")
    ...
  3. Re: How to update column headers in "archive" sheet when "live" sheet has changed

    How do you move the data, manually or with a macro? If with a macro, please post the code. Can you post a screen shot of what your data looks like? Section B at this link has instructions on how...
  4. Re: Identify cell address of first instance of duplicate value in vba

    Try:

    Sub FindVal()
    Dim LastRow As Long
    LastRow = Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
    MsgBox Range("A1:A" & LastRow).Find(ActiveCell.Value,...
  5. Re: Copy from one source file into multiple excel files - All live in one location

    Replace the code:

    With desWS
    .Range("G12:I12").Copy
    .Range("G13:I" & totals2 - 1).PasteSpecial Paste:=xlPasteFormulas
    End Withwith this:

    With desWS
    .Range("G12:I12").Copy
    ...
  6. Replies
    8
    Views
    260

    Re: Highlight cell based on values

    If the numbers in "AU1:BF1" are less than 4 characters while the numbers in your data are always 4 characters then it's hard to get a match.
  7. Re: Copy from one source file into multiple excel files - All live in one location

    Try:

    Sub CopyRange()
    Application.ScreenUpdating = False
    Dim wkbDest As Workbook, srcWS As Worksheet, desWS As Worksheet, LastRow As Long, key1 As Variant, key2 As Variant, totals1 As...
  8. Re: Identify cell address of first instance of duplicate value in vba

    See if this helps:

    Sub FindVal()
    Application.ScreenUpdating = False
    Dim LastRow As Long, rng As Range, fnd As Range, rngList As Object, key As Variant
    LastRow = Cells.Find("*",...
  9. Re: Identify cell address of first instance of duplicate value in vba

    When you get cell value "Apple", what do you want to do with it?
  10. Replies
    8
    Views
    260

    Re: Highlight cell based on values

    Try changing
    xlWhole to
    xlPart
  11. Re: Copy from one source file into multiple excel files - All live in one location

    Here are the links to the revised files. Please have a look at the formulas in range F67:I67 of the destination workbook. In order for the formulas to update as rows of data are inserted, you will...
  12. Re: Copy from one source file into multiple excel files - All live in one location

    Make sure that the source workbook and the destination workbooks have all been saved in the same folder. The macro must be in a standard module in the Source workbook and run it from there. The...
  13. Replies
    8
    Views
    260

    Re: Highlight cell based on values

    The macro will work with any length as long as the values in AU1:BF1 match the values you want to highlight.
  14. Re: Copy from one source file into multiple excel files - All live in one location

    I can't reproduce the problem. Click here to download the result that I get.
  15. Re: VBA to Copy and Paste From One Workbook to Another

    You are very welcome. :)
  16. Re: Copy from one source file into multiple excel files - All live in one location

    Here are the links to your files. Give them a try. They work for me.

    https://app.box.com/s/t9v3zj6ipcn2mgo5p1zlhw652s8th008
    https://app.box.com/s/im0tbzhmvyjjkj4h06d7tjqobxiu10ue
  17. Re: Copy from one source file into multiple excel files - All live in one location

    Try:

    Sub CopyRange()
    Application.ScreenUpdating = False
    Dim wkbDest As Workbook, srcWS As Worksheet, desWS As Worksheet, LastRow As Long, key1 As Variant, key2 As Variant, totals1 As...
  18. Replies
    8
    Views
    260

    Re: Highlight cell based on values

    Try this macro. I think that the value 34115 should be 3415.

    Sub MatchVals()
    Application.ScreenUpdating = False
    Dim LastRow As Long, ws As Worksheet, rng As Range, x As Long, y As Long,...
  19. Re: VBA to Copy and Paste From One Workbook to Another

    Make sure that both workbooks are open. Place this macro in the "2018" workbook. Change the workbook name in the code (in red) to suit your needs.

    Sub CopyCells()
    Application.ScreenUpdating...
  20. Re: VBA to Copy and Paste From One Workbook to Another

    You mentioned where A4 in 2018 gets pasted. What about B18, C86, C88 and D1?
  21. Re: Copy from one source file into multiple excel files - All live in one location

    Do you have values in column D in the Source file for each account in column A? I tested the macro on the two files you uploaded and it worked properly. Are you using the macro on the same two...
  22. Re: Copy from one source file into multiple excel files - All live in one location

    Place this macro in the Source workbook. Save the workbook as a macro-enabled file into the same folder as the destination files. The macro assumes that a destination file exists for each account...
  23. Re: Copy from one source file into multiple excel files - All live in one location

    Column D in the Source file is formatted as "General" whereas column B in the destination file is formatted as "mm/dd/yy". Would 70819 represent "07/08/19" formatted as "mm/dd/yy"? Also, in the...
  24. Re: Copy from one source file into multiple excel files - All live in one location

    Thank you for the files. I'll start to have a closer look at the files and get back to you as soon as I can. Would it be a problem if we inserted a column in the source file that would contain the...
  25. Replies
    30
    Views
    707

    Re: update - copy paste with multiple criteria

    My pleasure. :)
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4