copying text between cells
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 |
copying text between cells
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 |
copying text between cells
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 |
copying text between cells
|
All times are GMT +1. The time now is 06:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com