LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default Having Excel Move Data that has a certain value

I have a workbook that has several worksheets in it. I wanted to know
if anyone knows if it is possible for Excel to be able to recognize a
value point and when it does move an entire line of data (several
cells) to anothre worksheet within the workbook automatically.

Worksheet One

CELL A1 = Name
CELL B1 = County
CELL C1 = Date
CELL D1 = Value point 1 for yes 2 for now

What I would like to try to do is if CELL D1 equals 1 then have Excel
move cells A1, B1 and C1 to another worksheet. Is this possible and I
am not allowed to use ACCESS. My group's director doesn't understand
how to use it so we are not allowed to.

 
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
Move data Horacio Excel Worksheet Functions 2 October 31st 06 04:14 PM
Need a shaded row in Excel that doesn't move as data changes czr Excel Worksheet Functions 1 May 17th 06 02:49 PM
How do you move names and data between large Excel 2003 workbooks? shore Excel Worksheet Functions 1 September 22nd 05 12:35 PM
Macro to move data to different column based on data in another co malycom Excel Discussion (Misc queries) 3 August 2nd 05 07:07 PM
enter data in cell which will start macro to move data to sheet2 Tommy Excel Discussion (Misc queries) 0 May 12th 05 05:00 PM


All times are GMT +1. The time now is 11:53 PM.

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

About Us

"It's about Microsoft Excel"