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?
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
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'
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...
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.
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...
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...
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??
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'...
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
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...
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...
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...
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...
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!
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...
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...
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!!
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?