Update a specific worksheet

N

Neal Ostrander

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
 
D

Don Guillett

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 DATA>FILTER>AUTOFILTER to see
just 525 info.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update several ppt documents from a single excel file 0
Crating User Form to Add Names 1
VBA Coding Help for Beginner 0
Automatically save as pdf but include location 0
Creating a Chart on form from selected data in query. 0
Copy previous record into form field 0
Embed the same Excel multiple times 0
List all tables, including document structure 0

Top