Move row automatically to the bottom of the sheet when cell changes

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,476
Office Version
365
Platform
Windows
That does not seem to make any sense to me. You should not be losing any rows.
Can you create a small example where this is happening, and post images of your "before" and "after" data.
You can post images using the tools mentioned here: XL2BB - Excel Range to BBCode
 

CindyLou

New Member
Joined
Jun 23, 2020
Messages
12
Office Version
365
Platform
Windows
I think I figured out why it was happening to me. When I created "test" rows, I did have anything in Column A. I just tested it again with a value in A and it worked. Woohoo! I'm so excited. Thank you Joe!!
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,476
Office Version
365
Platform
Windows
You are welcome.
 

Watch MrExcel Video

Forum statistics

Threads
1,100,037
Messages
5,472,112
Members
406,804
Latest member
xbinsx

This Week's Hot Topics

Top