move to next empty cell if previous contains data

pudland · Post by **pudland** » Tue Mar 18, 2008 9:40 pm

Hi,
I am looking for a way to:
have a cell "A" with variable data input, populate cell "B" with the data.
then,
move to next cell down "C", to be ready to populate with new data from cell "A".
then,
move to next cell down "D", to be ready to populate with new data from cell "A".

Thanks

edit this topic's initial post · Post by **Villeroy** » Tue Mar 18, 2008 9:52 pm

What you describe sounds more like a database form than a spreadsheet. Cetainly it is completely unrelated to formulas (wrong sub-forum).

pudland · Post by **pudland** » Tue Mar 18, 2008 10:42 pm

Villeroy wrote:What you describe sounds more like a database form than a spreadsheet. Cetainly it is completely unrelated to formulas (wrong sub-forum).

I was thinking there was a function with the ability to perform this.

edit this topic's initial post · Post by **Villeroy** » Tue Mar 18, 2008 10:49 pm

There are several shortcuts for navigation in spreadsheets. For instance, try Ctrl+Arrows to jump across contents and blank cells. But there is certainly no easy way to write the content of a cell when something has been written to another cell. Spreadsheets use formulas with references to other cells. A formula may look like this:
=IF(ISNUMBER(A1);A1*PI();"") [if A1 is a number show pi multiplied by A1, else show an empty string (nothing)].

move to next empty cell if previous contains data

move to next empty cell if previous contains data

Re: move to next empty cell if previous contains data

Re: move to next empty cell if previous contains data

Re: move to next empty cell if previous contains data