sending data from one cell to another (not using copy & paste)

C

Charlie Payne

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
 
G

Guest

Thanks Frank,

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

Appreciated.
 
C

CarlosAntenna

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy and paste slide from one presentation to another presentation gives an error 2
Index Match to ignore blank cells 0
Create if partial match then copy and paste data from one cell to another 1
How to summarize copied data 2
copying input to another cell 3
Write data from one cell to another cell 0
Column of formulas with some cells containing data derived from thereformula's I would like to find 2
Write data from one cell to another cell 1

Top