• 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.

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

Status
Not open for further replies.
emmatm

emmatm

Member
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?
 
1) Do You know how to do that manually?
2) Is this act once in the life or more often?
If more often then ...
After You know, how to do it manually,
You could do it with VBA.
You just need to know every steps
or
You will do it manually.
 
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 may only go to a certain row but next week it could be a different row so I would need to include all rows with data included.

thanks
 
Once a day ... #2
If You cannot do if with VBA
then You should make a good sample file and send it here.
After that it would be possible to get some code.
 
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!
 
Status
Not open for further replies.
Back
Top