Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.28 seconds.

  1. Re: VBA to copy data from multiple workbooks into a Master wkbk

    Try:

    Sub CopyCols()
    Application.ScreenUpdating = False
    Dim desWS As Worksheet, srcWS As Worksheet, srcWB As Workbook, rng As Range, LastRow As Long, x As Long, header As Range, NH As...
  2. Re: VBA to copy data from multiple workbooks into a Master wkbk

    Click here to download your results file. When I run the macro, it appears to work properly without any errors.
  3. Replies
    9
    Views
    279

    Re: Need help with Code converting xlsm to xls

    This macro will run only if the workbook has an "xlsm" extension.

    Sub bomaisgrat()
    If Mid(ThisWorkbook.Name, WorksheetFunction.Find(".", ThisWorkbook.Name, 1) + 1) = "xlsm" Then
    Dim...
  4. Replies
    1
    Views
    126

    Re: Data Validation List based on Cell Value

    This macro assumes that you have headers in row 1 starting in column A and your data starts in row 2. Copy and paste this macro into the worksheet code module. Do the following: right click the tab...
  5. Re: Conditional Copy, Paste to Another Sheet, Return to Start

    You are very welcome. :) In your case, the old saying: "If it's not broken, don't fix it." is very true.
  6. Thread: Paste as Values

    by mumps
    Replies
    5
    Views
    155

    Re: Paste as Values

    Try:

    Sub PasteValues()
    Dim Template As Worksheet
    Set Template = Sheets("Template")
    Template.Copy After:=Template
    With ActiveSheet
    .Name = "ABL"
    ...
  7. Re: Conditional Copy, Paste to Another Sheet, Return to Start

    I tried the macro on some dummy data and it worked properly for me. It would be easier to help if you could post a screen shot of what your data looks like? Section B at this link has instructions...
  8. Re: Conditional Copy, Paste to Another Sheet, Return to Start

    Maybe:

    Sub New_Clear()
    Application.ScreenUpdating = False
    If MsgBox("This action cannot be undone!" & vbCrLf & vbCrLf & "The data in row " & ActiveCell.Row & " will be cleared. Are you...
  9. Re: Conditional Copy, Paste to Another Sheet, Return to Start

    Try:

    Sub New_Clear()
    Application.ScreenUpdating = False
    If Range("O" & ActiveCell.Row) <> "X" Then
    MsgBox ("Row " & ActiveCell.Row & " does not contain 'X' in column O.")
    ...
  10. Re: Copy from one source file into multiple excel files - All live in one location

    Glad it worked out. :)
  11. Replies
    2
    Views
    46

    Re: Delete Rows if contains text in column A

    Fluff beat me to it. :)
  12. Re: Copy from one source file into multiple excel files - All live in one location

    Try replacing this line of code:
    Set prevWS = Sheets("0" & Left(sDate, Len(sDate) - 4) - 1 & Right(sDate, 2))with
    If Left(Left(sDate, Len(sDate) - 4) - 1, 1) < 1 Then
    ...
  13. Re: Copy from one source file into multiple excel files - All live in one location

    That line of code defines the sheet name in the destination workbook. The sheet name represented by the variable "prevWS" is based on the date in column D of the sheet "QRYLIBA380.CSIPHIST>Sheet1",...
  14. Re: VBA to copy data from multiple workbooks into a Master wkbk

    Try:

    Sub CopyCols()
    Application.ScreenUpdating = False
    Dim desWS As Worksheet, srcWS As Worksheet, srcWB As Workbook, rng As Range, LastRow As Long, x As Long, header As Range, NH As...
  15. Re: VBA to copy data from multiple workbooks into a Master wkbk

    I've tested the macro I suggested in Post #20 and it is working as you requested. If the source files don't contain the word "euro", it copies starting in row 4 otherwise, it copies from row 22. ...
  16. Re: is there a way to password protect cells from being changed?

    You are very welcome. :)
  17. Re: is there a way to password protect cells from being changed?

    The instructions in Post #2 and the macro I suggested will protect the locked cells from being changed. To protect your code, you have to protect your VBA Project. Do the following:
    -hold down...
  18. Re: VBA to copy data from multiple workbooks into a Master wkbk

    I don't quite follow. My understanding was that you wanted all data from all files copied to the Master sheet. Is that not what you want? Please clarify in detail.
  19. Re: is there a way to password protect cells from being changed?

    The sheet protection, with or without a password, prevents any changes in the cells that were locked. The macros will still run when you click the buttons without having to enter any password. I...
  20. Replies
    1
    Views
    100

    Re: VBA help for data entry form

    It would be easier to help and test possible solutions if you could upload a copy of your file to a free site such as www.box.com. or www.dropbox.com. Once you do that, mark it for 'Sharing' and you...
  21. Re: is there a way to password protect cells from being changed?

    Unlock the cells where you want to input data and lock those cells you don't want changed. Then protect the sheet. In order for your macros to run properly you will have to place your code between...
  22. Re: VBA for Highlighting Differences from 2 Sheets using Key Identifier

    It would be easier to help if you could post a screen shot of what your data looks like? Section B at this link has instructions on how to post a screen shot:...
  23. Replies
    4
    Views
    68

    Re: Find duplicates across sheets

    Try:

    Sub FindDups()
    Application.ScreenUpdating = False
    Dim Rng As Range, RngList As Object, ws As Worksheet
    Set RngList = CreateObject("Scripting.Dictionary")
    With...
  24. Re: VBA Code to change the font in a block of cells to white

    My pleasure. :)
  25. Replies
    4
    Views
    68

    Re: Find duplicates across sheets

    To clarify, you want to highlight any value in column A of sheets 2 and 3 if the value exists in column A of Sheet1. Is this correct?
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4