Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Charlie Payne
 
Posts: n/a
Default sending data from one cell to another (not using copy & paste)

Is there a command that automatically sends data from one
cell to another cell once the first cell contains data. I
know that the usual way to do this is to use the copy
command: =Sheet1$X53 however this is 'pulling the data'
rather than having it be sent to another cell. However I
don't want to use this formula as I require that the
worksheet that the data is sent to has all unused cells
blank (as opposed to having unused cells containing the
copy command). The reason for this requirement is that the
worksheet needs to be imported into a system that rejects
blank cells with formula's in. (usually we have to delete
each unused cell).

I hope this makes senses - And I'd be extremly thankful
for any help!


Charlie
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
this would require a VBA solution. Not possible with formulas

"Charlie Payne" wrote:

Is there a command that automatically sends data from one
cell to another cell once the first cell contains data. I
know that the usual way to do this is to use the copy
command: =Sheet1$X53 however this is 'pulling the data'
rather than having it be sent to another cell. However I
don't want to use this formula as I require that the
worksheet that the data is sent to has all unused cells
blank (as opposed to having unused cells containing the
copy command). The reason for this requirement is that the
worksheet needs to be imported into a system that rejects
blank cells with formula's in. (usually we have to delete
each unused cell).

I hope this makes senses - And I'd be extremly thankful
for any help!


Charlie

  #3   Report Post  
 
Posts: n/a
Default

Thanks Frank,

However i've never used VBA before - so any tips on how to
get started on this?

Appreciated.
-----Original Message-----
Hi
this would require a VBA solution. Not possible with

formulas

"Charlie Payne" wrote:

Is there a command that automatically sends data from

one
cell to another cell once the first cell contains data.

I
know that the usual way to do this is to use the copy
command: =Sheet1$X53 however this is 'pulling the

data'
rather than having it be sent to another cell. However

I
don't want to use this formula as I require that the
worksheet that the data is sent to has all unused cells
blank (as opposed to having unused cells containing the
copy command). The reason for this requirement is that

the
worksheet needs to be imported into a system that

rejects
blank cells with formula's in. (usually we have to

delete
each unused cell).

I hope this makes senses - And I'd be extremly thankful
for any help!


Charlie

.

  #4   Report Post  
CarlosAntenna
 
Posts: n/a
Default

As Frank has already said, you can't use formulas to change the value of
another cell. However I think you might be able to achieve the desired
result by copying the data from the source sheet and then using PASTE
SPECIAL VALUES at the destination. Formulas that evaluate to a blank on
the source will be blank on the destination.

Carlos

"Charlie Payne" wrote in message
...
Is there a command that automatically sends data from one
cell to another cell once the first cell contains data. I
know that the usual way to do this is to use the copy
command: =Sheet1$X53 however this is 'pulling the data'
rather than having it be sent to another cell. However I
don't want to use this formula as I require that the
worksheet that the data is sent to has all unused cells
blank (as opposed to having unused cells containing the
copy command). The reason for this requirement is that the
worksheet needs to be imported into a system that rejects
blank cells with formula's in. (usually we have to delete
each unused cell).

I hope this makes senses - And I'd be extremly thankful
for any help!


Charlie



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
How do I copy data (word) into respective cells when the data bei. awg9tech New Users to Excel 1 January 12th 05 12:26 PM
I need a macro to find cut and paste data to new cell Rex Excel Discussion (Misc queries) 0 December 6th 04 01:45 AM
I need a macro to find cut and paste data to new cell Rex Excel Discussion (Misc queries) 0 December 6th 04 01:23 AM
copy paste cell character limit Fred Excel Discussion (Misc queries) 1 December 2nd 04 09:58 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 08:16 PM


All times are GMT +1. The time now is 04:11 AM.

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"