Copy data onto sheet only if cell has text

danipants, on Wednesday September 3, 2008 12:54:29 PM

Hello,

I need to copy formulas and data from a selection of cells in a worksheet (Figures) onto a seperate sheet (summary).

I would like the information to automatically copy across to the sheet (summary) as i type on the original page (Figures).

I would like the information to ONLY be copied if a certain cell within the orginal sheet has a specific word 'text'.

Is there a way of producing this data?

Many Thanks

Dani

Configuration: Windows Vista
Internet Explorer 7.0

Reply to danipants Report this message to moderators Go to last message

This message seems useful, vote!
Report this message to moderators

morina, on Friday October 24, 2008 09:55:15 AM

try =if(isblank(cell to be copied)," ",(cell to be copied))

Reply to morina

This message seems useful, vote!
Report this message to moderators

Niko, on Tuesday November 11, 2008 11:37:44 PM

Think that suit to your purpose:

Copy in the cell where you want your text to be automatically updated:

=IF(FIND("Text",'Figures'!B20)<>0,'Figures'!A20,"")

This will copy the text of the cell A20 of your Figures sheet in the cell where you paste the formula, only if the cell B20 of your Figures sheet contains the text "Text".

Cheers

Reply to Niko

Ask your question Reply

Results for

Firmnual Help If cell is blank go to next ce Hello, EXCEL FORMULA If cell is not blank automatically look go to next cell (across) and if the cell has text in it the show the text ? I have 35 colums some have info (dates) and some do not I am trying to show the last intry in the colum at the... en.kioskea.net/forum/affich-26805-firmnual-help-if-cell-is-blank-go-to-next-ce

Excel need to copy into new sheet Hey i need a code that is probably very basic for all of you but im a "noob" at excel so please can you help i need it so that for 10 cells like if cell k15 has data use cell k17 right down to cell k25 this is my VB code so far:- Sub... en.kioskea.net/forum/affich-31760-excel-need-to-copy-into-new-sheet

Need help in copying data Hello, can anyone help me in copying data (dont know the usedrange) from an excel and paste it in the activesheet Thanks in advance en.kioskea.net/forum/affich-29137-need-help-in-copying-data

1 2 3 Next

Results for

Excel tips : How to insert date In an Excel cellExcel tips : How to insert date In an Excel cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press “CTRL”+ “;” in the chosen cell. To insert current... en.kioskea.net/faq/sujet-313-excel-tips-how-to-insert-date-in-an-excel-cell

1 2 3 Next

Results for

Excel -Copy Macro ProblemHello, I have developed a macro (attached to a button) that copies data from one row (cells D8, E8, F8 & G8) to a sheet called transmittals. Every time the button is clicked it will then copy the data to the next available line on the transmittals... en.kioskea.net/forum/affich-22161-excel-copy-macro-problem

Copy data into next empty cell in new sheetHello, I am trying to make a 2 sheet workbook which has the input details in Sheet1 A1 and this is changed weekly but the info in this cell should then be inserted into the first blank cell in Column A in Sheet 2. I have tried this code (below) but it... en.kioskea.net/forum/affich-16567-copy-data-into-next-empty-cell-in-new-sheet

HOW TO COPY THE DATA FROM EXCEL BY USING MACRHello, My query is, How to copy Data from excel sheet in to new excel file by useing Macro. Regards, Kris en.kioskea.net/forum/affich-31122-how-to-copy-the-data-from-excel-by-using-macr

1 2 3 Next

Results for

Download Excel ViewerWith Excel Viewer, you can open, view, and print Excel workbooks, even if you don't have Excel installed. You can also copy data from Excel Viewer to another program. en.kioskea.net/telecharger/telecharger-52-excel-viewer

Download ResizRTheoretically data that it is pictures, texts, musics or videos on sites and Web pages are not modifiable directly by the user.Case can really meet when if the editor of the site allows it there. ResizR is an extension Firefox allowing to re-size... en.kioskea.net/telecharger/telecharger-645-resizr

Download Word ViewerView, print and copy Word documents, even if you don't have Word installed. en.kioskea.net/telecharger/telecharger-50-word-viewer

1 2 3 Next

Results for

IT professions - ADatabase administrator A database administrator (or DBA for short) is in charge of maintaining and operating the databases which form a company's information system. Given the critical nature of the data he/she is in charge of, the database administrator must be well... en.kioskea.net/metiers-informatique/administrateur-bases-donnees.php3

Spreadsheets - Cell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. An entire line can be chosen by clicking directly on the line header: It is also possible to choose... en.kioskea.net/tableur/tabcellselect-1.php3

Spreadsheets - The Excel Interface Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel document is called a file... en.kioskea.net/tableur/tabinterface.php3

1 2 3 Next