ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Update a specific worksheet (https://www.excelbanter.com/excel-programming/416945-update-specific-worksheet.html)

Neal Ostrander

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

Don Guillett

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