+ Reply to Thread
Results 1 to 3 of 3

Find rows with one cell containing data, move the cell up and delete the row

  1. #1
    Registered User
    Join Date
    06-12-2018
    Location
    London
    MS-Off Ver
    15
    Posts
    2

    Find rows with one cell containing data, move the cell up and delete the row

    Hi there,

    I have an excel file that was converted from a pdf, the spreadsheet is a bank statement that I need to use for accounting purposes. Some of the rows have a single cell with a numerical value, but the description, date and further information that number is associated with is in the row above. (see attached image)
    I would like to select all the rows in the document that contain only this numerical value, move that specific cell up to the correct row, and delete the empty row.
    Is this possible?

    thanks,

    Chris

  2. #2
    Registered User
    Join Date
    06-12-2018
    Location
    London
    MS-Off Ver
    15
    Posts
    2

    Re: Find rows with one cell containing data, move the cell up and delete the row

    excel example copy.jpg please see image attached.

  3. #3
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,420

    Re: Find rows with one cell containing data, move the cell up and delete the row

    Hello chriskellyfilm and Welcome to Excel Forum.
    This proposed solution employs a helper column which may be hidden for aesthetic purposes.
    The helper column (G) is populated using:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    The values generated in the helper column are then referenced in column I (which could also be hidden) using:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Most of the table in columns J:O are populated using formulas similar to:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    The Amount column (L) is populated using:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    If you would like us to work with your data, and for future reference, please upload a copy of your spread sheet as opposed to a screen shot by clicking on GO ADVANCED button below the Quick Reply window and then scrolling down to Manage Attachments to open the upload window.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Find and delete entire rows based on a cell content
    By axtryo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-17-2017, 12:51 AM
  2. [SOLVED] Find last empty cell from range, then delete rows?
    By B.W.B. in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-06-2016, 06:15 AM
  3. [SOLVED] VBA macro, move cell contents, duplicate down if additional value, delete empty rows
    By lengwer in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-07-2015, 10:46 AM
  4. vba help to find cell based and delete rows
    By mike760534211 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-30-2014, 09:47 AM
  5. [SOLVED] Find row cell containing specific text, then delete all rows ABOVE that cell
    By ks100 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-20-2013, 02:02 PM
  6. [SOLVED] Find rows to delete with a macro based on cell content
    By mkraffert in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-28-2013, 06:27 PM
  7. Find Cell Delete All Rows Below
    By Tyler_Durden in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-24-2009, 05:35 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1