View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default Excel 2003 - Relocating an entire row of from one worksheet to ano

Hi,

its possible but I think only with VBA code. And I think we will need more
details. For example, it sounds line you have an external data connection,
if so you can copy the data to the new worksheet but if you try to move it,
it will come back everytime you refresh the connection.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"watermt" wrote:

I'm trying to move a row of data in my worksheet to another worksheet in the
same workbook. When a date and time (02/05/09 11:19) is posted in cell 2L
from an external data source) I'd like for the entire row of data to be
removed and placed in another worksheet in my workbook. The row would be
placed in the worksheet that has the same number of columns, rows and in the
same order as the previous worksheet, is this possible?