#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 226
Default Excell help !

how do i automatically move data to a seperate sheet once a specific cell is
validated?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 694
Default Excell help !

Hi Roger,

Please can you explain a little more about once your data is validated.

Generally you cannot automatically move data to other locations.

There are some ways to do it and I would suggest that you use a userform to
enter the data validate it and then put it in the desired location.


--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Roger" wrote:

how do i automatically move data to a seperate sheet once a specific cell is
validated?

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
Front page 2000 and Excell. gbc196 Excel Discussion (Misc queries) 3 December 6th 06 10:19 PM
editing documents with excell that are not excell format Jim Excel Discussion (Misc queries) 1 May 8th 06 06:31 PM
insert query into excell sheet to update excell sheet and pivot table vbsolo Excel Discussion (Misc queries) 0 August 24th 05 12:41 PM
Can I view an excell document without excell (not installed wit. Kevin Excel Discussion (Misc queries) 1 February 16th 05 08:27 PM
lable ranges in Excell david Excel Discussion (Misc queries) 2 February 2nd 05 11:26 PM


All times are GMT +1. The time now is 06:14 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"