• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. emmatm

    Copy data from various sheets onto a master

    Hey don't worry, I have been taking a look online and trying a few things and I have done some of this myself.:DD Leave it for now and if I get stuck I will give you a chase for some help. Hope you have had a good day?
  2. emmatm

    Copy data from various sheets onto a master

    Hi SirJB7, Can you advise if you have any new suggested coding for my last workbooks sent to you? I cannot see that you had sent me anything back. I am conscious that you are a very busy man so I am not chasing just want to be sure I haven't missed anything! Thanks as always
  3. emmatm

    Copy data from various sheets onto a master

    Ruptura mental I think in spanish
  4. emmatm

    Copy data from various sheets onto a master

    Now I do actually look this :awesome: on occasion
  5. emmatm

    Copy data from various sheets onto a master

    Sorry but #37 has just made me :), am I causing you a bit of a breakdown!
  6. emmatm

    Copy data from various sheets onto a master

    So E) should be as follows: MAC TRACKER tabs 'projects', 'tech & crate', 'tech only', 'crate only' & 'OH' will be moved to tabs 'all', 'scheduled' & 'complete' on the MAC ADMIN file using the status column 'P'
  7. emmatm

    Copy data from various sheets onto a master

    Hello - hope you have had a good day? A) yes correct B) the workbook we receive daily we just copy the one tab from it onto our MAC TRACKER workbook. Ignore everything else on the other tabs of the workbook. C) I want to take new data only as old data would have already been copied over. I...
  8. emmatm

    Copy data from various sheets onto a master

    Think I have answered all your questions. You are quite funny you know!
  9. emmatm

    Copy data from various sheets onto a master

    Too premature with post reply :oops: Don't need 'In progress' anymore 3. Yes exactly like now (thanks for doing that btw ;)) So are we swapping the Carlsberg for a yacht now? Emoji said he was 'awesome' - I couldn't possibly comment if you look like him, you don't have a photo in you profile.
  10. emmatm

    Copy data from various sheets onto a master

    Ok so: 1 person sends this it is in excel and is exactly the same as the tab labelled JLL Mac ID's on the MAC TRACKER workbook. This is a simple copy and paste job, copy the whole tab onto the JLL MAC ID's tab Yes you can identify the new jobs by the JLL MAC ID no, all existing jobs on the...
  11. emmatm

    Copy data from various sheets onto a master

    You can have as many six packs of Carlsberg as you like ;) I am going to attempt to explain again the scenario on how I see the process should work, if you have a better idea let me know. We receive the JLL MAC ID, every day this is longer with new jobs added This is copied onto the first tab...
  12. emmatm

    Copy data from various sheets onto a master

    I think my silly sense of humour has offended you :( Of course this wasn't my intention. I have rambled on and not explained myself very well. If you are have forgiven me shall I start again and explain in better detail??
  13. emmatm

    Copy data from various sheets onto a master

    Hello again, So thank you very much for this, it is greatly appreciated. Nice touch with the Carlsberg, you can look forward to this soon :DD, just let me know how I can get this to you?? I think you might want to kill me but I have re-named the file and attached a new version 'MAC TRACKER'...
  14. emmatm

    Copy data from various sheets onto a master

    b) each time the macro is run it should replace to the relevant tab c) you may have a better solution seeing as you are the genius here?? Negotiate.......you would like something in return! lets hope this doesn't start to get very rude and awkward:p I will upload the file later. Thank you SirJB7
  15. emmatm

    Copy data from various sheets onto a master

    So I have been asked to now have the 4 tabs of new data on a new workbook instead: ALL Scheduled Complete Progress Do you think this is something you can show me how to do? I can upload the additional workbook if you think this is possible? And to answer the question above could you code in to...
  16. emmatm

    Copy data from various sheets onto a master

    Thank you for your help, I removed the small works as instructed. Your old unanswered questions: I should have used the word 'copy' not 'transfer', as transfer does mean to move!! I did not want to add the headers from each tab but wanted only one header on the new tab. Finally column P was...
  17. emmatm

    Copy data from various sheets onto a master

    H SirJB7, This works well, just 2 questions. 1. initially I had a 'small works' sheet but I had since deleted that, the code is still looking for a small works tab. 2. I think because 'tech only' tab has columns hidden, when this data is copying over to the ALL tab the status are showing in...
  18. emmatm

    Copy data from various sheets onto a master

    Ah ok, I have amended those now to read 'scheduled'. Still no results, I have also changed 15 to 16 as the status is now in row P not O
  19. emmatm

    Copy data from various sheets onto a master

    Thank you dan, There seems to a problem, I have attached my file. Could you explain what I need to do and could you recommend a good starting point for me to learn vba language?? BTW I have removed a tab called Smallworks, I am not sure if this is the problem! I did remove any reference to this...
  20. emmatm

    Result all entries with the same code onto a new tab in a workbook

    Sorry if this was breaking rules! I didn't know if there would be various ways of doing this which is why I posted it in the VBA section and excel question. If this isn't the done thing I apologise!
  21. emmatm

    Copy data from various sheets onto a master

    Hi So I am trying to take the data from these 4 tabs: Projects Small Works Tech & Crate Tech Only And add it all onto tab 'ALL' Then where column O is 'SCHEDULED' I want this data to copy onto the Scheduled tab. Then were column O is 'COMPLETED' I want this data to copy onto the Completed tab...
  22. emmatm

    Result all entries with the same code onto a new tab in a workbook

    I can filter on the status on each tab and then copy and paste this data onto the new workbook for all 4 tabs. This will have to be done once a day every day. I think I would like to have this done with VBA but I don't know the entries to use to copy all the data excluding headers. Today my data...
  23. emmatm

    Copy data from various sheets onto a master

    So I have 4 tabs on a workbook and I want to transfer data from all 4 tabs that are of a certain status which is shown in a set column in each tab onto a new tab within a new workbook, what's the easiest way to do this? I do not want to add the headers and I have very limited knowledge of VBA!!
  24. emmatm

    Result all entries with the same code onto a new tab in a workbook

    So I have 4 tabs on a workbook and I want to transfer data from all 4 tabs that are of a certain status which is shown in a set column in each tab onto a new tab within a new workbook, what's the easiest way to do this?
  25. emmatm

    1st 2nd and 3rd place

    Ah I see - I meant I wanted the name of the person to show who had the highest score not with the highest score! sorry for the confusion.
Back
Top