Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.28 seconds.

  1. Replies
    3
    Views
    195

    Re: VBA copy sheets as values only

    Are the sheets password protected? Are they all protected or just some? If some, which ones are protected?
  2. Re: VBA for Combining 1st sheet of every workbook in folder into one master-sheet of new workbook

    Oops! Try:

    Sub CombineSheets()
    Application.ScreenUpdating = False
    Dim lCol As Long, srcWB As Workbook, mastWB As Workbook, mastWS As Worksheet
    Set mastWB =...
  3. Replies
    3
    Views
    195

    Re: VBA copy sheets as values only

    Try:

    Sub CopySheets()
    Application.ScreenUpdating = False
    Dim srcWB As Workbook, desWB As Workbook, ws As Worksheet
    Set srcWB = ThisWorkbook
    Set desWB = Workbooks.Add(1)
    ...
  4. Re: VBA code for copying columns from one worksheet to another when source file is keeps changing

    Remove the macro from the standard module in the destination workbook. Then place the macro below in the code module for ThisWorkbook in the destination workbook. Do the following: Hold down the...
  5. Re: VBA for Combining 1st sheet of every workbook in folder into one master-sheet of new workbook

    This macro will have to be placed in a separate workbook. Change the folder paths to suit your needs.

    Sub CombineSheets()
    Application.ScreenUpdating = False
    Dim lCol As Long, srcWB As...
  6. Re: VBA code for copying columns from one worksheet to another when source file is keeps changing

    Place this macro in the destination workbook. Save the destination workbook as a macro-enabled file. Make sure both workbooks are open and run the macro.

    Sub CopyColumnsToOtherWorkbook()
    ...
  7. Re: VBA code for copying columns from one worksheet to another when source file is keeps changing

    Do you already have a macro? If so, please post a copy. Is the destination file name "Flange Inspection report.xlsm"? I assume your macro is in the destination file. Is this correct?
  8. Re: VBA code for copying columns from one worksheet to another when source file is keeps changing

    Is the name of the destination file always the same? What is the full name of the destination file?
  9. Re: VBA for Combining 1st sheet of every workbook in folder into one master-sheet of new workbook

    In order to get Variation (1) to work, you would need an extra column in the Master workbook which records the name of each file from which the data is copied. Would that work for you? If not, then...
  10. Re: Copy from one source file into multiple excel files - All live in one location

    Try inserting this line of code:
    Application.Wait (Now + TimeValue("00:00:05"))after
    wkbDest.Close TrueThis will pause the macro for 5 seconds before opening the next file.
  11. Re: Copy from one source file into multiple excel files - All live in one location

    In the latest version of your destination file, the data starts at row 10. In the previous versions, the data started at row 12. The following macro is based on the data in all the destination...
  12. Replies
    8
    Views
    194

    Re: Can't make it work?

    Are the formulas returning numbers? Perhaps 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 will be...
  13. Thread: vba

    by mumps
    Replies
    4
    Views
    114

    Re: vba

    After copying the data, right click the destination cell, click 'Paste Special' and select "Values". This assumes the copy paste is done manually.
  14. Replies
    8
    Views
    194

    Re: Can't make it work?

    What values do the formulas return in cells D2, F2 and H8?
  15. Replies
    8
    Views
    194

    Re: Can't make it work?

    Try: =IF(H8 < D2,"Not Ready",IF(AND(H8 > D2,H8 < F2),"AllMost",IF(H8 > F2,"Done")))
  16. Re: Extract Data from Another workbook , Match data and Paste

    You are very welcome. :) Yes, that is correct. You have many "event" macros which were being triggered unnecessarily which of course took more time.
  17. Re: Copy from one source file into multiple excel files - All live in one location

    When I try the link you posted, it asks me to sign in to my account. Can you please upload to a site where I can download the files directly without having to sign in?
  18. Re: Extract Data from Another workbook , Match data and Paste

    Try:

    Private Sub GetBus_Click()
    With Application
    .ScreenUpdating = False
    .Calculation = xlCalculationManual
    .EnableEvents = False
    End With
    Dim srcWS As...
  19. Replies
    9
    Views
    87

    Re: Locking specific cells

    You are very welcome. :)
  20. Replies
    9
    Views
    87

    Re: Locking specific cells

    Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your sheet and click 'View Code'. Paste the macro into the empty code window that opens up....
  21. Replies
    9
    Views
    87

    Re: Locking specific cells

    It looks like you want to clear B17 if B19 changes. If this is correct, do you change B19 manually or is the value in B19 the result of a formula?
  22. Replies
    9
    Views
    87

    Re: Locking specific cells

    In my previous post, I accidentally pasted an extra "End Sub" line. Try:

    Sub test()
    With Sheets("Sheet1")
    .Unprotect Password:="abc"
    If .Range("B19").Value = "Generic" Then...
  23. Replies
    9
    Views
    87

    Re: Locking specific cells

    Try:

    Sub test()
    With Sheets("Sheet1")
    .Unprotect Password:="abc"
    .Range("A6:A167").Locked = True
    .Range("C6:C167").Locked = True
    .Protect Password:="abc"
    ...
  24. Re: Extract Data from Another workbook , Match data and Paste

    See if this version helps. If not, it would be easier to help if you could upload a copy of your files to a free site such as www.box.com. or www.dropbox.com. Once you do that, mark each file for...
  25. Re: Copy from one source file into multiple excel files - All live in one location

    Do you want the previous month's data to go below any already existing data in the destination sheet? Does the first of the month date appear in the first row for each account? Is it possible that...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4