Menu

copying text between cells

Search this Thread

Prev

Previous Post

Next Post

Next

#4

Report Post

Posted to microsoft.public.excel.misc

Muhammed Rafeek M Muhammed Rafeek M is offline

Muhammed Rafeek M is offline

external usenet poster

Posts: 179

Default

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Summing cells that contain numbers and text	Mango	Excel Discussion (Misc queries)	10	May 13th 06 06:18 PM
Linked cells and text boxes	Alexlondon11	Excel Discussion (Misc queries)	2	November 23rd 05 04:10 PM
Formula to strip figures from cells text strings	mikeburg	Excel Discussion (Misc queries)	5	August 15th 05 10:31 PM
Cells formated as text do not always display properly	Cass	Excel Discussion (Misc queries)	2	July 23rd 05 01:59 AM
text wrap in merged cells	SteveFerd	Excel Discussion (Misc queries)	3	July 16th 05 12:46 PM

All times are GMT +1. The time now is 12:43 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement