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

Question

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

Closed

Report

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

Posts: 2829
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: November 22, 2021

- 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
Display Multiple Columns in a Validation List in Excel - How-To - 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 - Excel

1 reply

Ask a question

TrowaD · Answer 1 · 2015-10-05T11:54:45-0400

Answer 1 / 1

TrowaD

Posts: 2829
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: November 22, 2021

490
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

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

1 reply

Your reply

Subscribe To Our Newsletter!