Search : in
By :

Copy data onto sheet only if cell has text

Last answer on Jan 17, 2009 12:18:55 am GMT danipants, on Sep 3, 2008 12:54:29 pm BST 
 Report this message to moderators

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

Best answers for « copy data onto sheet only if cell has text » in :
[Excel]changing cell formula to text Show[Excel]changing cell formula to text Issue Solution Notes Issue Consider that I have: In cell A4, it contains a formula =Sum(A1:B3)+A3/B2. How to extract this formula in cell A6 as a string of text? That is ... I want cell A6...
[VBA] Detecting changes in cell Show[VBA] Detecting changes in cell The Event Change feature of a sheet will detects the change in the active cell but it gives no information about the content. The example given below will help you to find out if the cell was changed,...
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
Spreadsheets - Cell Selection ShowCell 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. Line Selection An entire line can be chosen by clicking directly on the line...
Linux - The shell ShowIntroduction to the shell The command interpreter is the interface between the user and the operating system, hence the name "shell". The shell therefore acts as an intermediary between the operating system and the user thanks to command lines...

1

morina, on Oct 24, 2008 9:55:15 am BST
  • +6

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

Reply to morina

4

 rebeccachome, on Jan 17, 2009 12:18:55 am GMT

Hi, I am really struggling...
I have a very large order sheet in XL and when the customer enters the qty they want in a column there will always be many in that column with no qty in. to print the order i want to have all the data moved to another spreadsheet so i only see the items they have ordered not the whole sheet with the items they have not
can you help I have tried a few things but cannot get the formular right
Thanks
Rebecca

Reply to rebeccachome

2

Niko, on Nov 11, 2008 11:37:44 pm GMT
  • +3

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

3

rebeccachome, on Jan 17, 2009 12:18:06 am GMT
  • +1

Hi, I am really struggling...
I have a very large order sheet in XL and when the customer enters the qty they want in a column there will always be many in that column with no qty in. to print the order i want to have all the data moved to another spreadsheet so i only see the items they have ordered not the whole sheet with the items they have not
can you help I have tried a few things but cannot get the formular right
Thanks
Rebecca

Reply to rebeccachome