How to Move Rows Based on Cell Status in Excel
Have you ever wanted to move rows in one worksheet based on the status of another? Here’s how to do that in Excel. I’m including my Visual Basic code, which
Jim Markus
June 6, 2024
Jim Markus
About Jim Markus Jim Markus is an Independent Journalist and Award-Winning Game Designer serving as an Editor for Spreadsheet Point. At Spreadsheet Point, he builds spreadsheet templates and specializes in data visualization in Google Sheets.
Highlights
- Director at Spreadsheet Point and an award-winning game designer and sales professional.
- Renowned for hosting the popular personal finance podcast Frugal Living and writing for platforms like Hackr.io and KDnuggets.
- Recipient of The Max Gladstone Special Judge's Choice Award at the Golden Cobra Awards and a Dale Carnegie-trained public speaker.
Jim creates systems that are easy to understand and use. He is the winner of the 2021 Max Gladstone Special Judge's Choice Award (Golden Cobra Challenge), where he was praised for designing straightforward rules and accessible experiences that work perfectly online.
At Spreadsheet Point, Jim applies this same focus on clarity and accessibility to technical guides, ensuring that even the most complex formulas are easy for beginners to pick up.
Beyond data, Jim is the creator of the competitive writing event Ink & Blood, the podcast Frugal Living, and the author of "The Ink and Blood Dueling Society Doesn't Exist." You can find more of his articles on MuckRack.
Additional Resources:Recent Articles
Google Sheets Tips
How To Highlight Duplicates in Google Sheets
Highlighting duplicates in Google Sheets takes one formula and a conditional formatting rule. This guide shows how to do it in a single column, across multiple columns, and for entire duplicate rows, including how to flag only the second occurrence, combine multiple conditions, and fix the two most common reasons the formula stops working.
Sumit Bansal
February 23, 2026
How to Use the ISERROR Function to Highlight Errors
If you want to highlight errors in Google Sheets, consider the ISERROR function. I’ll show you how to use it with conditional formatting to highlight an entire row when it
Jim Markus
April 27, 2024
What’s the Issue with Inserting Checkboxes in Excel?
Here’s something interesting. There’s no way to insert checkboxes in the web version of Excel. Surprised? So am I. The issue here is that we can’t alter the look of
Jim Markus
February 4, 2025
Google Sheets Tips
How to Import Stock Prices into Google Sheets
There’s an easy way to import stock prices into Google Sheets. Here’s what to know.
Jim Markus
January 10, 2025
Google Sheets Tips
Free Character Sheet Spreadsheet Template (Google Sheets RPG Builder)
If you want a character sheet you can share, edit anywhere, and actually trust during play, Google Sheets is a great option. This free template gives you a flexible base, then shows you how to customize the stats, formulas, and upgrades for almost any RPG system.
Jim Markus
February 19, 2026
Google Sheets Tips
How to Clear Formatting in Google Sheets (Step-by-Step)
To clear formatting in Google Sheets, use the dropdown menu or a keyboard shortcut. I’ll show both methods in this guide. Clear Formatting in Google Sheets When working with data
Sumit Bansal
February 6, 2024
Google Sheets Tips
How to Assign a Task in Google Sheets [Easy Guide]
To assign a task in Google Sheets, either tag someone’s email in a comment or create a drop-down list. I show both methods in this guide. The commenting method is
Chris Daniel
January 17, 2024
Google Sheets Tips
Google Sheets Count Cells with Text | Full Guide
To count cells with text, you’ll need to use a specific function. This can be done with either COUNTA or COUNTIF. However, note that the COUNTIF function only counts cells
Sumit Bansal
September 9, 2025