Update a specific worksheet
Is there a way to have excel add information input on one sheet to a specific
worksheet. For example tracking fleet maintence information. If the user inputs truck #525 then the information input would be copied to 525's worksheet. Thanks for any help Neal |
Update a specific worksheet
You can do that with a worksheet_change event to copy the info to the next
available row in your desired sheet but it would probably be much better to just keep all info on the original and use DATAFILTERAUTOFILTER to see just 525 info. -- Don Guillett Microsoft MVP Excel SalesAid Software "Neal Ostrander" wrote in message ... Is there a way to have excel add information input on one sheet to a specific worksheet. For example tracking fleet maintence information. If the user inputs truck #525 then the information input would be copied to 525's worksheet. Thanks for any help Neal |
All times are GMT +1. The time now is 07:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com