Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10,124
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell Update only at a specific time. Scott520 Excel Discussion (Misc queries) 4 August 8th 13 08:41 PM
Update one worksheet tab to automatically update all other tabs? shoechic1 Excel Worksheet Functions 1 May 24th 09 03:55 PM
Help - Update a SQL table from a specific range in Excel NormaD Excel Programming 2 June 26th 07 10:37 PM
Navigate to specific cell on specific worksheet Bryan Excel Programming 2 April 13th 06 04:33 PM
Update Only Specific Columns Jani Excel Programming 0 February 7th 06 03:26 PM


All times are GMT +1. The time now is 02:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"