Help with the formula

[duh123]

I need from one table if there is a value other than "0" (example column I) to copy the contents of the table from column "B" "C" and "J" to a new table in the first free row on the same sheet. New table iz in colum "M" "N" "O". Columns I B C and "J" are in the same row.
Thankful in advance for your help.

[Zizi64]

Do you want to copy the data, or you want to reference them?

[duh123]

I want to copy data. Only data not formula.

[Zizi64]

You can not copy data by a formula. You can only reference a cell content by a formula.
For example in M1 cell:

Code: Select all   Expand viewCollapse view

=B1

You need some macro for copying data from cells to cells.
You can record this macro, but it is better to write your macros.

And you can launch the macro by an object event (clinking on a menu item, or on an another control object), or you can create listeners to listen the changing a cell content, and then launching the macro.