Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 13
Default HOW WILL MOVE TO 2ND WORKSHEET

Please help me if possible as below

i have in worksheet number 1 any of one cell sum text (for exsample -
DELIVERY AT)
when i put anyting in this purticular cell, automaticly the text to be
moved to worksheet number 2 in any cells.

***MY TEXT IN WORKSHEET NUMBER 1 C3 (DELIVERD) TO MOVE WORKSHEET
NUMBER 2 IN C5, HOW TO MOVE AUTOMATICLY***

please give me solution for this

Thansk
Anshad
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 364
Default HOW WILL MOVE TO 2ND WORKSHEET

wrote in message
...
Please help me if possible as below

i have in worksheet number 1 any of one cell sum text (for exsample -
DELIVERY AT)
when i put anyting in this purticular cell, automaticly the text to be
moved to worksheet number 2 in any cells.

***MY TEXT IN WORKSHEET NUMBER 1 C3 (DELIVERD) TO MOVE WORKSHEET
NUMBER 2 IN C5, HOW TO MOVE AUTOMATICLY***

please give me solution for this

Thansk
Anshad


If I understand you correctly, in sheet 2 cell C5 put the formula
=Sheet1!C3


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 13
Default HOW WILL MOVE TO 2ND WORKSHEET

On Nov 21, 12:11 pm, wrote:
Please help me if possible as below

i have in worksheet number 1 any of one cell sum text (for exsample -
DELIVERY AT)
when i put anyting in this purticular cell, automaticly the text to be
moved to worksheet number 2 in any cells.

***MY TEXT IN WORKSHEET NUMBER 1 C3 (DELIVERD) TO MOVE WORKSHEET
NUMBER 2 IN C5, HOW TO MOVE AUTOMATICLY***

please give me solution for this

Thansk
Anshad


Dear Stephen,

Thanks for helping

the below is i have work sheet 1
A1 (shipper) B1 (consignee) C1 (arrival date) D1 (b/l number) somthing
like this finaly delivery option for example H1
when i enter in cell H1, then all above to move worksheet 2, but i
dont want see the above after entry from sheet 1 H1 this purticular
row to move sheet 2 last blank row,

if it is possible, please provide solution.

Best Regards
Anshad
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
Can not copy or move some worksheet NTNH Excel Worksheet Functions 1 May 28th 07 12:14 PM
How to move from one Worksheet to another. Don J Excel Discussion (Misc queries) 3 February 20th 07 09:18 PM
Unable to Insert Worksheet/Move and copy worksheet Excel 2003 lukerush Excel Worksheet Functions 2 September 7th 06 05:05 PM
automatically move row to another worksheet CA enpet Excel Discussion (Misc queries) 0 August 4th 06 09:49 PM
How do I move my worksheet from under the toolbar? JewlyCC Excel Discussion (Misc queries) 1 January 11th 05 11:02 PM


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