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 :
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...
[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,...
[Ingres] Importing/ Exporting data Show[Ingres] Importing/ Exporting data Making use of these commands copydb unloaddb Notes Ingres allows you to export data from an Ingres installation to another (it is a platform independent procedure). unloaddb copydb The main...
UNIX system - The shell ShowIntroduction to the shell The command interpreter is the interface between the user and the operating system, hence its name "shell". The shell therefore acts as an intermediary between the operating system and the user using command lines...
CSS - Style sheets ShowFont properties Property Value Description font-family Specific font (Arial, Times, Verdana) Familly (serif, sans-serif, fantasy, monospace, cursive) Defines one or more font names or font families. If multiple fonts are defined,...

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
  • +4

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