I need to copy each row into the rows belonging tab
example : for each row where ID = 1100 { copy row to tab:1100}
etc...
I need to copy each row into the rows belonging tab
example : for each row where ID = 1100 { copy row to tab:1100}
etc...
A workbook would be much better than a picture!
Why do you need to duplicate data, it's generally unnecessary because you can use AutoFilter or PivotTables?
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
I need it to as autoated as possible this is just one of many sheets I deal with. if it were only one I could do with filtering
This code creates a sheet for each unique entry, adapt it for what you need
Please Login or Register to view this content.
Hi mammut89
You could try this code:
PS - Just saw roy's answer after I posted!!Please Login or Register to view this content.
Hope this helps
Seamus
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks