Thread
:
copying text between cells
View Single Post
#
4
Posted to microsoft.public.excel.misc
Muhammed Rafeek M
external usenet poster
Posts: 179
copying text between cells
could you please send your file to
"AD" wrote:
Thanks Muhammed,
I am not quite sure what you mean by "drag to down". I only want to
increment the source cell '[source.xls]Sheet'!C10,C11 etc only if there is
text to copy from the target..
--
AD
"Muhammed Rafeek M" wrote:
Use: IF('[target book.xls]Sheet'!A2 ="y", '[source.xls]Sheet'!C10,"") in
'[target book.xls]Sheet'!B2
Once you use this function, you can drag to down.
"AD" wrote:
the logic I wish to execute goes something like this:
whenever '[target book.xls]Sheet'!$A$2:$A$100="y" I want to copy the text
from the adjacent cell in the range ie. '[target book.xls]Sheet'!$B$2:$B$100
to my source book ie. '[source.xls]Sheet'!$C$10, and this should be
incremented every time text is copied ie. the next cell to be updated would
be '[source.xls]Sheet'!$C$11 and so on until the end of the target range.
Can anybody help ?
--
AD
Reply With Quote
Muhammed Rafeek M
View Public Profile
Find all posts by Muhammed Rafeek M