Display a new entry in a column in a separate cell in excel

Closed

vivek - Oct 2, 2015 at 10:54 AM
TrowaD

Posts: 2886
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: June 27, 2022

- Oct 5, 2015 at 11:54 AM

Hello,

I am having a column;

A B

1 ab
2 abc
3 abcd
4 abcde
5 xyz
6

I want the next entry in 6 row of A to be entered into 1 row of B and likewise any next entry in column A should be displayed in 1 row of B.

Please help me with this!

Thanks.

Display a new entry in a column in a separate cell in excel
Merge adjacent cells in columns with same data/value in excel - Forum - Excel
Need to find a data in a column and copy below cell data or add ✓ - Forum - Excel
Returning value from column b in column c, in a cell ajacent to ✓ - Forum - Excel
How to automatically copy rows if column contains specific text/value in excel ✓ - Forum - Office Software
How do you automatically copy rows if column contains specific text value in excel? ✓ - Forum - Excel

1 reply

Answer 1 / 1

TrowaD

Posts: 2886
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: June 27, 2022

515
Oct 5, 2015 at 11:54 AM

Hi Vivek,

Well, if you want your value not in A6 but in B1, then select B1 before entering your data.

Don't see the issue here.

Best regards,
Trowa

Subscribe To Our Newsletter!