Copying DATA from Main sheet into different sheets

[Shellad]

Hi

I am new to the forum and hoping someone can help me. I have a data sheet that I enter all data into. I would like to divide the data into different sheets depending on the month the job was entered. Please see a sample I have attached. I have tried to convert the month (colE) into a figure (colF). I am hoping the data automatically copies across into the correct month sheet or perhaps I can push a button and it will do it for me. Data will get entered on a daily basis by staff but only onto the main sheet, this will then by some miracle be duplicated into the corresponding sheet without loosing any data on the main sheet. I do hope this makes sense even though I have repeated myself about 3 times

[lostinmsexcel]

I'm not sure if it is possible to automatically copy the data while classifying it. My knowledge in MS Excel isn't yet exemplary. What I do when I need to segregate data is use VLOOKUP Function to copy data based on a given value which will be manually copied and pasted on the correct sheet. In your case, I assume the order number is unique with every entry. Here's a sample if you're interested.

[jolivanes]

This assumes that you have sheets named to copy to with the headers in place.
It cleans the sheets before copying to it so you won't have double (or triple) entries.

Please Login or Register  to view this content.

[Shellad]

Thank you very much. This is exactly what I need jolivanes but have no idea how to transfer this onto my main page. I used the alt F11, insert module function and paste but when I click F5 to run it, it gives me a run time error 9. What am i doing wrong?

[jolivanes]

Could be a host of things.
Are the dates exactly the same in the cells as in the tabs?
Attach you file that does not work and we can have a look at it.
No data in it that should not be on the open net though. (personal info, email addresses etc)

[Shellad]

Jolivanes. Here is a more of an idea of what I am requiring. All entries will be entered onto the entry sheet, however I need the "date in" to be copied and seperated into each month. ie all junes to go on the June sheet, all julys onto the july sheet and so on but without any data being eliminated from the main entry sheet. This will enable me to be able to view each month separately. I hope this makes sense.

[jolivanes]

Try this.
My HD crashed on the desktop so I am doing several things at once. I hope it works.
It uses Column I as a help Column. If your original file can't handle this you'll have to change that or come back to us.

[jolivanes]

I noticed that in your attachment the dates in cells D1041 and D1017 are formatted different.
These rows will not be copied into the relevant sheets because of that.
To fix that with the code in my attachment, add one line in the code.

Please Login or Register  to view this content.

A more robust code, I think, would be:

Please Login or Register  to view this content.

This has the advantage that the dates can be of different formats.
However, empty cells are seen as a 1 which means that the month of January will have extra entries (all rows without dates in Column D)
BTW, I don't have the smart indent add on installed yet.

[jolivanes]

How are you making out?