I have a workbook with multiple sheets. When data is entered into a userform it is sent to the appropriate sheet. The data is then sent to a "mastersheet". I would like to sort the individual sheets before they are merged together to create the mastersheet. I would like this to happen automatically as new data is entered. Thanks.
Brainfreeze, it would be easy for you to record the action of you doing a sort how you want it, then where your macro calls each sheet to merged with the master you could CALL your recorded macro.
Not all forums are the same - seek and you shall find
Why write to multiple sheets then merge the data? It's far more efficient to use one sheet for daat then use Filters or PivotTables to view data.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks