Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.26 seconds.

  1. 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...
  2. 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...
  3. Replies
    30
    Views
    686

    Re: update - copy paste with multiple criteria

    My pleasure. :)
  4. Re: Copy from one source file into multiple excel files - All live in one location

    Could you upload the files as I suggested in Post #5 ?
  5. Re: Copy from one source file into multiple excel files - All live in one location

    It would be easier to test a possible solution if you could upload a copy of your source file and at least one copy of a destination file to a free site such as www.box.com or www.dropbox.com. Once...
  6. Re: Copy from one source file into multiple excel files - All live in one location

    Can you clarify the date format in column C? What dates do the following represent: 2019189, 2019190, 2019191 and what would the corresponding sheet names be?
  7. Replies
    30
    Views
    686

    Re: update - copy paste with multiple criteria

    Try:

    Sub Import_Vessel_Availablility_Update_Sheet()
    Application.ScreenUpdating = False
    Dim srcWS As Worksheet, desWS As Worksheet, arr1 As Variant, arr2 As Variant, i As Long, Val As...
  8. Re: Copy from one source file into multiple excel files - All live in one location

    If you want to open the source file as well as the destination file, that would mean that the macro would have to be placed in a third file. Is that what you want to do or do you want to open the...
  9. Replies
    30
    Views
    686

    Re: update - copy paste with multiple criteria

    I noticed some spacing issues which I have fixed.

    Sub Import_Vessel_Availablility_Update_Sheet()
    Application.ScreenUpdating = False
    Dim srcWS As Worksheet, desWS As Worksheet, arr1 As...
  10. Replies
    30
    Views
    686

    Re: update - copy paste with multiple criteria

    This part of the macro loops through column B of "Wharf Schedules". The "i" in arr(i,1) represents the position of the value in column B and the "1" represents the first column in the array which...
  11. Re: When copying data from Forum threads, data is pasted into only one column

    JLGWhiz
    Thank you for that suggestion. Unfortunately, it happens with all web sites.
  12. Replies
    30
    Views
    686

    Re: update - copy paste with multiple criteria

    Try:

    Sub Import_Vessel_Update2_Sheet()
    Application.ScreenUpdating = False
    Dim srcWS As Worksheet, desWS As Worksheet, arr1 As Variant, arr2 As Variant, i As Long, Val As String, RngList...
  13. Re: Extract Data from Another workbook , Match data and Paste

    My plessure.. :)
  14. Replies
    8
    Views
    266

    Re: Issue With deleting rows

    Please upload a copy of your workbook that contains the additional sheets.
  15. Replies
    30
    Views
    686

    Re: update - copy paste with multiple criteria

    This seems to be working:

    Sub Import_Vessel_Update2_Sheet()
    Application.ScreenUpdating = False
    Dim srcWS As Worksheet, desWS As Worksheet, arr1 As Variant, arr2 As Variant, i As Long, Val...
  16. Replies
    30
    Views
    686

    Re: update - copy paste with multiple criteria

    Can any vessel with the same name and "In Voyage" number be listed in more than one wharf?
  17. Re: When copying data from Forum threads, data is pasted into only one column

    JLGWhiz
    I managed to have a look at your link. Thank you. Unfortunately, Excel doesn't have those options. The site also says: "By default, when you paste text copied from elsewhere into Word,...
  18. Re: When copying data from Forum threads, data is pasted into only one column

    That's correct. I am still having the problem with Edge but not with Internet Explorer or Chrome.
  19. Re: When copying data from Forum threads, data is pasted into only one column

    JLGWhiz
    Thank you for the link. I'll be out for the day but I will have a look at it and get back to you.
    Peter_SSs
    Thank you Peter for your suggestion. I tried that approach and I got the same...
  20. Re: When copying data from Forum threads, data is pasted into only one column

    Thanks for all your suggestions. :)
  21. Re: When copying data from Forum threads, data is pasted into only one column

    I am using Microsoft Edge. I tried copying from the site using both Internet Explorer and Google Chrome and it pasted correctly from both. So it must be something in Microsoft Edge but I have no...
  22. Re: When copying data from Forum threads, data is pasted into only one column

    sandy666
    Unfortunately, I get the same result. It looks like it is inserting a carriage return after every cell instead of just at the end of each row.
  23. Re: When copying data from Forum threads, data is pasted into only one column

    JLGWhiz
    Unfortunately, I couldn't find anything applicable.
    sandy666
    This is what I get:4
    Excel 2010 32 bit

    SKU

    Type
  24. Re: When copying data from Forum threads, data is pasted into only one column

    sandy666
    I have tried with many posts but here is the link to one: https://www.mrexcel.com/forum/excel-questions/1108531-check-each-row-criteria-delete-row-2-below.html
    I copy the posted data and...
  25. Re: When copying data from Forum threads, data is pasted into only one column

    It's frustrating if I'm trying to help another forum member. I copy the data from the post into Excel so that I can test a possible solution but it's pasted into one column. I would have to...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4